mysql high cpu usage issue

[Ahmed Hany]

Hi,

I have a wordpress website that have 200 unique visitors on the same time or more , i can't believe that only 200 online visitors can cause this high cpu !


anyone help me to resolve this problem !

Thanks in advanced

 

[Ahmed Hany]

I ran this command ( mysqladmin processlist ) and i received the following:

 root@server [/]# mysqladmin processlist
-bash: root@server: command not found
root@server [/]# +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
-bash: +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+: command not found
root@server [/]# | Id  | User  | Host  | db  | Command | Time | State  | Info  | Progress |
-bash: syntax error near unexpected token `|'
root@server [/]# +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
-bash: +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+: command not found
root@server [/]# | 7897  | eximstats  | localhost | eximstats  | Sleep  | 961  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59073 | meshmomk_wp752 | localhost | meshmomk_wp752 | Query  | 0  | query end  | INSERT INTO `wphl_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES (11005, '_wpweb_select_hour | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59245 | meshmomk_wp752 | localhost | meshmomk_wp752 | Sleep  | 0  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59247 | meshmomk_wp752 | localhost | meshmomk_wp752 | Query  | 0  | query end  | DELETE FROM `wphl_postmeta` WHERE `meta_id` = 61273  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59248 | meshmomk_wp752 | localhost | meshmomk_wp752 | Query  | 0  | Sending data | SELECT wphl_posts.* FROM wphl_posts WHERE ID IN (10992,10989,10988,10987,10985,10983)  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59252 | meshmomk_wp752 | localhost | meshmomk_wp752 | Sleep  | 0  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59253 | meshmomk_wp752 | localhost | meshmomk_wp752 | Query  | 0  | query end  | UPDATE `wphl_postmeta` SET `meta_value` = '1316' WHERE `post_id` = 10733 AND `meta_key` = 'tie_views | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59254 | meshmomk_wp752 | localhost | meshmomk_wp752 | Query  | 0  | query end  | UPDATE `wphl_postmeta` SET `meta_value` = '31249' WHERE `post_id` = 1124 AND `meta_key` = 'tie_views | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59255 | meshmomk_wp752 | localhost | meshmomk_wp752 | Sleep  | 0  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59256 | meshmomk_wp752 | localhost | meshmomk_wp752 | Sleep  | 0  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59257 | meshmomk_wp752 | localhost | meshmomk_wp752 | Sleep  | 0  |  |  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# | 59258 | root  | localhost |  | Query  | 0  | init  | show processlist  | 0.000  |
-bash: syntax error near unexpected token `|'
root@server [/]# +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
-bash: +-------+----------------+-----------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+:

Any help it would be appreciated

 

[cPanelMichael]

Hello,

Have you verified that MySQL is the culprit for the high load average? You can review the following thread for help determining the cause of the high load average:

Troubleshooting high server loads on Linux servers

Thank you.

 

[Znuff]

Use

mytop -d ''

to see real time MySQL usage.

mytop comes by default with mariadb, otherwise you will have to install it manually (yum install mytop) if you are still on mysql