优化前 用户页面打开需要5.49秒 ，并且他一直升级服务器升到了32核64G内存依然这么卡顿，优化后服务器配置可以降低 能省下很多钱。

优化后0.43秒

写文章优化前5.62秒

编辑页面4.47秒

该网站用户表就有35万数据。

慢语句

SELECT wp_users.ID,wp_users.user_login,wp_users.display_name

FROM wp_users

INNER JOIN wp_usermeta

ON ( wp_users.ID = wp_usermeta.user_id )

WHERE 1=1

AND ( ( ( ( wp_usermeta.meta_key = ‘wp_capabilities’

AND wp_usermeta.meta_value LIKE ‘%\”edit\\_posts\”%’ )

OR ( wp_usermeta.meta_key = ‘wp_capabilities’

AND wp_usermeta.meta_value LIKE ‘%\”administrator\”%’ )

OR ( wp_usermeta.meta_key = ‘wp_capabilities’

AND wp_usermeta.meta_value LIKE ‘%\”editor\”%’ )

OR ( wp_usermeta.meta_key = ‘wp_capabilities’

AND wp_usermeta.meta_value LIKE ‘%\”author\”%’ )

OR ( wp_usermeta.meta_key = ‘wp_capabilities’

AND wp_usermeta.meta_value LIKE ‘%\”contributor\”%’ ) ) ) )

ORDER BY user_registered desc

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

SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month

FROM wp_posts

WHERE post_type = ‘attachment’

ORDER BY post_date DESC

其他慢语句

SELECT COUNT(ID)

FROM wp_users

WHERE DATE_FORMAT( user_registered,’%Y-%m-%d’) = DATE_FORMAT(NOW(), ‘%Y-%m-%d’)

SELECT post_id, COUNT(post_id) AS count

FROM wp_cao_down_tbl

WHERE 1=1

GROUP BY post_id

ORDER BY count DESC

LIMIT 10

还有其他慢语句就不一一陈列了。

已经优化好了 都是0.几秒 不仅后台快了，前台也快了。

 祝您生活愉快

心诚网站制作

2024-6-17

欢迎老板下单优化