Mysql high usage problem

blondie

• September 21, 2014 19:41

I have received this message from my host Mysql high usage please correct the problem Can anyone help I am a newbie with cpanel/WHM and do not know much about mysql, how can I find out where this high usage is coming from and how do I resolve it, I have 10 websites running on my whm and I have had a problem with 2 of them recently this month, they are all the free version of prismotube express v.1.13. I have had these websites before on a different server and never had a problem. Hope someone can help me Many thanks blondie

• 

  storminternet

  • September 22, 2014 04:26

  Do you know which mysql databases are consuming high resources or overloading server ? You can either optimize them and/or repair them via your cPanel. Sometimes corrupted mysql databases can also consume high resources of the server unnecessarily. For optimizing database you can do this via phpmyadmin by selecting database you want to optimize.

  0
• 

  Lion Sms

  • September 22, 2014 05:43

  You can optimize it by changing the parameters in /etc/my.cnf. MYSQL server needs to be optimized.

  0
• 

  server9host

  • September 22, 2014 05:50

  Hello, You can check which database use take long to execute the query using below command watch mysqladmin pr
  Then you get specific database who cause high memory usage on server.

  0
• 

  triantech

  • September 22, 2014 07:08

  Hey, What is your MySQL version ?

  0
• 

  cPanelMichael

  • September 22, 2014 15:25

  Hello :) Your access level indicates you do not have root access to the server. Please contact your hosting provider and ask them for more information about which database is using excessive amounts of CPU. If possible, ask them for information about specific database tables at fault. Thank you.

  0

Please sign in to leave a comment.