CPU usage by mysql

Hi,

The server is overloaded with MySQL CPU usage with queries like this:

2021-03-18T19:49:31.269603Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 744
2021-03-18T19:49:31.269677Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 929
2021-03-18T19:49:31.271895Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 928
2021-03-18T19:49:31.272541Z         8 Query     select * from wp_mcloud_task_data where complete != 1 and taskId = 744 order by id asc limit 10
2021-03-18T19:49:31.274292Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 927
2021-03-18T19:49:31.275931Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 743
2021-03-18T19:49:31.276705Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 926
2021-03-18T19:49:31.278964Z         8 Query     select * from wp_mcloud_task_data where complete != 1 and taskId = 743 order by id asc limit 10
2021-03-18T19:49:31.279080Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 925
2021-03-18T19:49:31.281386Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 924
2021-03-18T19:49:31.282222Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 742
2021-03-18T19:49:31.283764Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 923
2021-03-18T19:49:31.285150Z         8 Query     select * from wp_mcloud_task_data where complete != 1 and taskId = 742 order by id asc limit 10
2021-03-18T19:49:31.286104Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 922
2021-03-18T19:49:31.288366Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 741
2021-03-18T19:49:31.288444Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 921
2021-03-18T19:49:31.290696Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 920
2021-03-18T19:49:31.291324Z         8 Query     select * from wp_mcloud_task_data where complete != 1 and taskId = 741 order by id asc limit 10
2021-03-18T19:49:31.292965Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 919
2021-03-18T19:49:31.294503Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 740
2021-03-18T19:49:31.295309Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 918
2021-03-18T19:49:31.297474Z         8 Query     select * from wp_mcloud_task_data where complete != 1 and taskId = 740 order by id asc limit 10
2021-03-18T19:49:31.297625Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 917
2021-03-18T19:49:31.299882Z         9 Query     select count(id) from wp_mcloud_task where state = 1 and id <> 916
2021-03-18T19:49:31.300687Z         8 Query     select count(id) from wp_mcloud_task_data where complete != 1 and taskId = 739

Any idea what’s going on?

• This topic was modified 5 years, 2 months ago by securityelf.
• This topic was modified 5 years, 2 months ago by securityelf.