admin管理员组

文章数量:1122832

Over the last few weeks, I've noticed that my website's backend has been getting extremely slow, and today it has come to a complete crawl. I installed the Query Monitor and found that this WP core query takes upwards of 40s.

query:

SELECT DISTINCT meta_key
FROM wp_postmeta
WHERE meta_key NOT BETWEEN '_'
AND '_z'
HAVING meta_key NOT LIKE '\\_%'
ORDER BY meta_key
LIMIT 30

37 to 40 seconds.

Caller:

meta_form()
wp-admin/includes/template.php:722
post_custom_meta_box()
wp-admin/includes/meta-boxes.php:825
do_meta_boxes()
wp-admin/includes/template.php:1456

Rows: 30

Component: Wordpress Core

SELECT DISTINCT meta_key

I know enough to be dangerous, and at this point, I have no idea how to proceed other than hiring a MySQL/MariaDB developer.

Any thoughts on how I could do this without hiring someone else?

本文标签： mysqlAdmin backend is very slow to create or edit posts by core meta query

版权声明：本文标题：mysql - Admin backend is very slow to create or edit posts by core meta query 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736305716a1932690.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。