Bug #6731
closedOut-of-control queries on production server
83%
Description
This is a master ticket to track potential causes of recent performance problems on the production server.
Symptom: Webserver RAM occasionally spikes, with no corresponding traffic increase. Spikes correspond to highly increased traffic between webserver and database server, suggesting a query loop that's out of control.
I've been collecting diagnostic data over the past 24 hours about the following:
- requests that trigger large numbers of database queries
- requests that take a very long time to complete
and I have some preliminary findings, which I'll spell out in specific tickets.
Related issues
Updated by Boone Gorges almost 8 years ago
- Target version set to 1.11
The immediate problem seems to be solved. Let's continue to chip away at items during this dev cycle.
Updated by Boone Gorges over 7 years ago
- Target version changed from 1.11 to 1.12
Updated by Boone Gorges about 7 years ago
- Status changed from New to Resolved
I think we've done all the work it's worthwhile to do on this ticket, especially as we're no longer seeing performance issues.
Updated by Boone Gorges almost 7 years ago
- Related to Bug #8930: Throttle Jetpack batch routines added