Problem with server load

Mosaab

• February 26, 2017 14:27

Hi, server load became very high suddenly (10-58%), I have VPS server with 2 CPU, 60 G storage, also I have 1 website on server. with command top , Mysql has lots of %cpu how can I solve this problem?

• 

  Eminds

  • February 27, 2017 01:14

  You will need to check for the slow sql queries with the command mysqladmin proc it will list the processes and queries. Further more, I dont thing the VPS is optimized . Try optimizing VPS and mysql and then check.

  0
• 

  SysSachin

  • February 27, 2017 02:08

  Hello, If MySQL causing the high load then try to optimize MySQL using script mysqltuner

  0
• 

  24x7server

  • February 27, 2017 04:25

  Hi, Use the iotop command to check for the input/output status. Check what write status is MySQL giving.. Make sure you have a working status of 24 hours for MySQL before you execute any tuning script like mysqltuner or primer, as it is recommended to get a best value for the MySQL parameters..

  0
• 

  cPanelMichael

  • February 27, 2017 17:17

  Hello, The following thread is a good place to start: Troubleshooting high server loads on Linux servers Thank you.

  0
• 

  Mosaab

  • March 02, 2017 20:18

  Thank you, the problem was my server cpu is 2 cpu just

  0

Please sign in to leave a comment.