Very High Server load

texas90

• August 18, 2015 23:05

My server load is going very high due to to mysql. I have cloudlinux already installed. But it isn't helping much in case of mysql. Here is my /etc/my.cnf [mysqld] default-storage-engine=MyISAM innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=50000

• 

  TerranceR

  • August 19, 2015 05:47

  Hello, Have you tried running MySQL Tuner yet? If not, it is located at

  0
• 

  texas90

  • August 19, 2015 13:56

  Please have a look at this and suggest me how to bring the server load down. I had added the server name in the thread title so that you could better help me. My server is dual xeon 5420 root@server77 [/]# perl mysqltuner.pl >> MySQLTuner 1.5.1 - Major Hayden >> Bug reports, feature requests, and downloads at Beware that open_files_limit (50000) variable should be greater that table_open_cache ( 400) Variables to adjust: max_connections (> 151) wait_timeout (< 28800) interactive_timeout (< 28800) query_cache_size (>= 8M) join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start at 4) table_open_cache (> 400) innodb_buffer_pool_size (>= 952M) if possible.
  

  0
• 

  cPanelMichael

  • August 19, 2015 14:02

  Hello :) I've moved this thread to our "Optimization" forum where you may receive more user-feedback to this type of question. Thank you.

  0

Please sign in to leave a comment.