I was testing a patch on my development wiki (copy of twn wiki) and pages were timing out so I i fired up mytop. I saw multiple queries from MessageBlobStore::clear (one for each time I reloaded the page). Observering the list, they took ~50 seconds each to complete. It looks like it has only been fixed for WMF in T29320, not properly in core.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Krinkle | T89550 MessageBlobStore::clear queries take 40+ seconds | |||
| Resolved | Krinkle | T113092 Revise the design of ResourceLoader's MessageBlobStore |
Event Timeline
Comment Actions
Where do these calls primarily come from?
Do they occur while browsing the wiki? On write actions via index.php? In api.php? In load.php? In jobqueue jobs?
Comment Actions
Unfortunately I don't remember details anymore and I can't think of why the queries would suddenly take so long.
Comment Actions
Just saw this again:
*** 13:12:27: Rebuilding caches *** [Sat Sep 5 13:13:32 2015] [hphp] [8306:7f734a212a00:0:000001] [] SlowTimer [50823ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:13:32 2015] [hphp] [8309:7f734a212a00:0:000001] [] SlowTimer [50720ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:13:32 2015] [hphp] [8308:7f734a212a00:0:000001] [] SlowTimer [50962ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:13:32 2015] [hphp] [8307:7f734a212a00:0:000001] [] SlowTimer [50906ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:14:24 2015] [hphp] [8308:7f734a212a00:0:000002] [] SlowTimer [51451ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:14:24 2015] [hphp] [8306:7f734a212a00:0:000002] [] SlowTimer [51434ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:14:24 2015] [hphp] [8309:7f734a212a00:0:000002] [] SlowTimer [51403ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` [Sat Sep 5 13:14:24 2015] [hphp] [8307:7f734a212a00:0:000002] [] SlowTimer [51491ms] at runtime/ext_mysql: slow query: DELETE /* MessageBlobStore::clear */ FROM `bw_msg_resource` *** 13:15:10: All done ***
It was running php maintenance/rebuildLocalisationCache.php --threads=4