mysql进程使用非常高的cpu,在top命令中占157.5%。所以我发现mysql中的进程列表对于以下的查询永远不会消失:
SELECT post_name FROM wp_posts WHERE post_name = 'woocommerce_deliver_webhook_async...
你知道那是干什么的吗?它们重要吗?如何阻止他们?
MariaDB [(none)]> SHOW FULL PROCESSLIST;
+-----+------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| 555 | root | localhost | wp | Query | 0 | statistics | SELECT post_name FROM wp_posts WHERE post_name = 'woocommerce_deliver_webhook_async-5849' AND post_type = 'scheduled-action' AND ID != 20333 LIMIT 1 | 0.000 |
| 568 | root | localhost | wp | Sleep | 0 | | NULL | 0.000 |
| 583 | root | localhost | wp | Query | 0 | statistics | SELECT post_name FROM wp_posts WHERE post_name = 'woocommerce_deliver_webhook_async-61' AND post_type = 'scheduled-action' AND ID != 20365 LIMIT 1 | 0.000 |
| 587 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST | 0.000 |
| 591 | root | localhost | wp | Query | 0 | Writing to net | SELECT post_name FROM wp_posts WHERE post_name = 'woocommerce_deliver_webhook_async-7885' AND post_type = 'scheduled-action' AND ID != 20291 LIMIT 1 | 0.000 |
| 592 | root | localhost | wp | Query | 0 | statistics | SELECT post_name FROM wp_posts WHERE post_name = 'woocommerce_deliver_webhook_async-7912' AND post_type = 'scheduled-action' AND ID != 20391 LIMIT 1 | 0.000 |
+-----+------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
暂无答案!
目前还没有任何答案,快来回答吧!