vps上的wordpress系统的mysql的cpu占用很高怎么解决
程序员文章站
2022-04-06 16:51:09
...
cpumysqlwp
使用show full processlist;语句,一直显示下面的语句在运行,
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 15
导致cpu一直在200%左右,如何解决该问题呢?