Server high load

fajryassin

• June 28, 2022 12:49

Hello I have high load on my server some times up to 70 and mysl up to 600%

• 

  cPanelWilliam

  • June 29, 2022 13:54

  Hello! When MySQL is consuming a lot of CPU/Memory, I like to run a command such as the following to see which queries are running on the server: mysqladmin proc stat
  This can help to identify if one account/database is responsible for most of the usage then you can take steps to optimize the problematic databases. I will also include the following articles which may help further with the issue: Is there an easy method for doing MySQL tuning?

  0
• 

  fajryassin

  • June 30, 2022 17:36

  Hello This is the result now

  Hello! When MySQL is consuming a lot of CPU/Memory, I like to run a command such as the following to see which queries are running on the server: mysqladmin proc stat
  This can help to identify if one account/database is responsible for most of the usage then you can take steps to optimize the problematic databases. I will also include the following articles which may help further with the issue: Is there an easy method for doing MySQL tuning?

  
  

  0
• 

  cPanelWilliam

  • June 30, 2022 19:09

  Hi, The results from the screenshot indicate that there were no other active running queries at the time the command was used. This command is most useful when MySQL is consuming a lot of resources due to stacking queries. If there are no queries actively running then the usage from MySQL should be low.

  0
• 

  fajryassin

  • July 01, 2022 23:26

  RightNow, In SSH queries in low but in WHM queries are high (it is 130.74) Server Load is 2.425293 (8 CPUs) why is that happening and how do I fix it?

  Hi, The results from the screenshot indicate that there were no other active running queries at the time the command was used. This command is most useful when MySQL is consuming a lot of resources due to stacking queries. If there are no queries actively running then the usage from MySQL should be low.

  
  

  0
• 

  cPanelWilliam

  • July 05, 2022 18:39

  Hi, [QUOTE]RightNow, In SSH queries in low but in WHM queries are high (it is 130.74) Server Load is 2.425293 (8 CPUs) why is that happening and how do I fix it?
  A server load of 2.4 shouldn't cause any performance issues if your server has 8 CPU cores:

  0

Please sign in to leave a comment.