https://bugzilla.wikimedia.org/show_bug.cgi?id=69110
--- Comment #8 from Sean Pringle <[email protected]> --- The first query is heavily dependent on disk IO. It runs in ~1000s on both MariaDB 10 and 5.5 if data is cold, or if any other concurrent query is also bottle necked on disk. This should be reviewed once the switch back to SSD is done (to be scheduled very shortly after labsdb1003 migrates). Regarding the second query dying or losing connection, which still seems odd, it would be useful to know: - If the first query always completes regardless of slow runtime, or sometimes fails/is-killed itself. - If there is any delay between issuing the two queries on the same DB connection (seconds, minutes, etc ..). - If there is any transaction in use, either via explicit BEGIN or AUTO_COMMIT=0. - What client connector or library is used, and whether it could have any custom timeout settings. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
