mysql high cpu usage issue

222host

• May 05, 2016 01:54

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

• 

  222host

  • May 05, 2016 07:25

  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

  0
• 

  cPanelMichael

  • May 11, 2016 16:08

  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.

  0
• 

  Znuff

  • May 17, 2016 18:24

  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

  0

Please sign in to leave a comment.