how to optimization my.cnf

Motamedi

• April 21, 2016 05:30

hello Please provide a brief Lessons, Both me and others understand Other education did not understand anything Tell us for a server with 8 GB of RAM and 8 Core CPU and CentOs 6.5 How do I set the CPU the RAM cache ? Now I am using this my.cnf client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking key_buffer_size = 784M max_allowed_packet = 10M table_open_cache = 1024 sort_buffer_size = 2M read_buffer_size = 16M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 table_open_cache = 400 tmp_table_size = 24M max_heap_table_size = 24M table_definition_cache = 400 table_open_cache = 400 max_allowed_packet=32M open_files_limit=900000 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
But MySQL to 130% of the CPU usage And 100% of CPU usage and hang server Please tell me how I set full all amounts thanks ... ]http://ft.trillian.im/3a38c1b4d3162d7ca1e69c52a7cec8e0082ec605/6GVR0SoqA2nuVzhxpwO6mhIeIhlLg.jpg

• 

  24x7server

  • April 21, 2016 12:35

  Hello :), Have you tried mysql mysqltuner (MySQLTuner-perl by major) script on your server ? Please give a try with mysqltuner and monitor your mysql server performance

  0
• 

  cPanelMichael

  • April 21, 2016 17:34

  Hello :) The following thread is a good place to start when attempting to modify your MySQL configuration values: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.