woomcommerce在wordpress中重复执行sql

u5rb5r59  于 2021-06-17  发布在  Mysql
关注(0)|答案(0)|浏览(207)

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 |
+-----+------+-----------+-------+---------+------+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------+----------+

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题