Mysql cpu high since upgrade to whm56
Hi i noticed that since my upgrade to whm 56 dailey process log says mysql cpu 9.65 mem 1.03 mysql processes 0.0
And when i look at process manager mysql cpu is over 100 it's use to be around 40.
Does anyone know what can be doing this please.
-
Hello :), I will suggest you please try to monitor your MySQL server process with " mysqladmin proc " command, With this command you can easily find out which user OR databases is using high CPU on your server. 0 -
You can see the same in whm under show mysql processes. And i have checked they are aew sleep progress is all 0 It's something to do with the upgrade to 56 it was all fine until then. 0 -
I have now got MySQL Tuning Primer installed but not sure how to use or what code to add to my.cnf could anyone please give me some guidance 0 -
popeye Run :./mysqltuner.pl Post the results here. To make changes to you my.cnf, use your favorite linux text editor. I use nano nano /etc/my.cnf Change the variables that you would like and save. Make sure to restart MySQL. I would also encourage you to search on the internet for how to do this. There is tons of information out there. 0 -
Hi thanks for the reply so do i jsut run :./mysqltuner.pl ? i was told it's sh tuning-primer.sh 0 -
I would not remove anything until your sure. i need to find some help because waiting for answers from here takes to long. 0 -
I have now got MySQL Tuning Primer installed but not sure how to use or what code to add to my.cnf could anyone please give me some guidance
Hello, Please review the following thread and let us know if you have additional questions: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thanks!0
Please sign in to leave a comment.
Comments
7 comments