Last modified: 2014-07-24 20:17:11 UTC
Still seeing things like this occasionally: 2014-07-24 18:01:35 mw1191 outreachwiki: Sub-optimal transaction on DB(s) [10.64.16.27 (outreachwiki) (TRX#9ebd0c667c2b)]: 0 0.003455 query-m: UPDATE `page` SET page_links_updated = 'X' [TRX#9ebd0c667c2b] 1 0.000335 query-m: BEGIN 2 0.002425 query-m: DELETE FROM `protected_titles` WHERE pt_namespace = 'X' [TRX#9ebd0c667c2b] 3 0.000422 query-m: REPLACE INTO `updates` (up_page,up_action,up_timestamp,up_sequence) VALUES ('X',NULL) [TRX#9ebd0c667c2b] 4 0.002569 query-m: DELETE FROM `revtag` WHERE rt_page = 'X' [TRX#9ebd0c667c2b] 5 0.001807 query-m: DELETE FROM `translate_groupstats` WHERE tgs_group = 'X' [TRX#9ebd0c667c2b] 6 0.001250 query-m: REPLACE INTO `revtag` (rt_page,rt_type,rt_revision,rt_value) VALUES ('X') [TRX#9ebd0c667c2b] 7 0.000414 query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#9ebd0c667c2b] 8 0.000831 query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#9ebd0c667c2b] 9 0.004765 query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#9ebd0c667c2b] 10 0.005821 query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#9ebd0c667c2b] ... 366 0.005821 query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#9ebd0c667c2b] There must have been some >= 3 second method but the log entry was cutoff (being too long). Can these sorts of large updates always use the job queue?