CPU high overload

Mladen

• January 01, 2017 11:49

When I have a large number of visitors (just around 200 vistiros) a websites will not work. Server load jumps over 80 I believe that we are not a good setting of "MySQL". Would be really grateful if someone could help me how to set up. System information - Removed - Daily Process Log - Removed - Server [LIST]

Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz

48 GB DDR3 RAM

2x 2 TB SATA II Enterprise HDD /etc/my.cnf [mysqld] innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=48364 default-storage-engine=MyISAM

• 

  SysSachin

  • January 02, 2017 03:46

  Hello, You have to monitor your server using "top" command when server load goes high then you will get idea which process or user causing the load on the server. Also you can try adjusting your /etc/my.cnf file based on the "Variables to adjust" output of the MySQLtuner script

  0
• 

  Mladen

  • January 02, 2017 11:49

  when using: top - Removed - when using: perl mysqltuner.pl I get the following... Variables to adjust: 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 (>= 547M) if possible. innodb_log_file_size should be equals to 1/4 of buffer pool size (=32M) if possible. How to correctly enter in my.cnf? Currently, entered this /etc/my.cnf [mysqld] innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=48364 default-storage-engine=MyISAM

  0
• 

  cPanelMichael

  • January 03, 2017 21:34

  Hello, The following thread is a good place to start: Troubleshooting high server loads on Linux servers Regarding MySQL usage, you may also want to use the "mysqladmin processlist" command when the load is high to help determine if a specific database is the culprit. Thank you.

  0

Please sign in to leave a comment.