https://bugzilla.wikimedia.org/show_bug.cgi?id=68530
Bug ID: 68530
Summary: Many INSERT queries on some web requests
Product: MediaWiki extensions
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Translate
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected]
Web browser: ---
Mobile Platform: ---
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?
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
