Make WordPress Core

Opened 4 weeks ago

Last modified 4 weeks ago

#65626 new defect (bug)

7.0.1 9.9797 lagging at WP_Query->get_posts() on site with 16K= posts

Reported by: bibliata Owned by:
Priority: normal Milestone: Awaiting Review
Component: Database Version: 7.0.1
Severity: normal Keywords: needs-testing needs-patch reporter-feedback
Cc: Focuses:

Description

WordPress Core Rows 12 Time 9.9797

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND ( wp_postmeta.meta_key = '_thumbnail_id' )
AND wp_posts.post_type = 'post'
AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY RAND()
LIMIT 0, 12

[Tue Jul 14 08:40:19.216116 2026] [proxy_fcgi:error] [pid 426947:tid 139710814889536] (70007)The timeout specified has expired: [client 172.68.15.214:10260] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 09:58:00.006114 2026] [proxy_fcgi:error] [pid 527710:tid 139710806496832] (70007)The timeout specified has expired: [client 104.22.102.3:13269] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 09:58:06.495507 2026] [proxy_fcgi:error] [pid 427011:tid 139710823282240] (70007)The timeout specified has expired: [client 104.23.166.58:11062] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 09:58:14.009622 2026] [proxy_fcgi:error] [pid 427011:tid 139710747747904] (70007)The timeout specified has expired: [client 172.70.174.186:11287] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 10:09:31.561638 2026] [proxy_fcgi:error] [pid 426947:tid 139709766424128] (70007)The timeout specified has expired: [client 172.71.223.122:11059] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:17:00.561688 2026] [proxy_fcgi:error] [pid 426947:tid 139710680770112] (70007)The timeout specified has expired: [client 104.23.211.198:11988] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:19:06.963564 2026] [proxy_fcgi:error] [pid 427011:tid 139710647035456] (70007)The timeout specified has expired: [client 172.71.191.109:12030] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:21:58.529651 2026] [proxy_fcgi:error] [pid 527710:tid 139710605137472] (70007)The timeout specified has expired: [client 104.23.211.199:13219] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:22:24.018843 2026] [proxy_fcgi:error] [pid 527710:tid 139710772926016] (70007)The timeout specified has expired: [client 172.68.245.177:11419] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:23:08.984133 2026] [proxy_fcgi:error] [pid 527710:tid 139710756140608] (70007)The timeout specified has expired: [client 172.71.190.204:10807] AH01075: Error dispatching request to : (polling)
[Tue Jul 14 11:29:35.673203 2026] [proxy_fcgi:error] [pid 426947:tid 139710571730496] (70007)The timeout specified has expired: [client 104.22.93.43:9864] AH01075: Error dispatching request to : (polling)

Attachments (3)

snip.JPG (34.3 KB ) - added by bibliata 4 weeks ago.
bug.JPG (113.6 KB ) - added by bibliata 2 weeks ago.
overload persisting in 7.0.2 - this with a plain theme NO plugins
red.JPG (51.6 KB ) - added by bibliata 3 days ago.
intermediate killing redis during update and on other instances

Download all attachments as: .zip

Change History (5)

@bibliata
4 weeks ago

#1 @SergeyBiryukov
4 weeks ago

  • Keywords reporter-feedback added

Hi there, welcome to WordPress Trac! Thanks for the report.

The screenshot mentions a homepage_slider_add meta key, which likely comes from a plugin or theme. Does the issue still happen with all plugins disabled and a default theme (Twenty Twenty-Five) activated?

#2 @bibliata
4 weeks ago

Yes of course. I can post the time without the slider and with no plugins but afraid this is not it. The site has been running under this config with a normal load for years. It worked on 7.0 started lagging after the 7.1 release. Seems like the biggest lagging is front page and post editor...

@bibliata
2 weeks ago

overload persisting in 7.0.2 - this with a plain theme NO plugins

@bibliata
3 days ago

intermediate killing redis during update and on other instances

Note: See TracTickets for help on using tickets.