https://bugzilla.wikimedia.org/show_bug.cgi?id=51410
--- Comment #8 from Aaron Schulz <aschulz4...@gmail.com> ---
Log snippet from today (truncated the middle since it was repetitive):
2014-06-06 20:22:22 mw1137 metawiki: Sub-optimal transaction on DB(s)
10.64.16.22 (metawiki) (000000003fecc80f00000000a293a52d):
0 30.377860 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
1 30.378035 DatabaseBase::query-master
2 0.000352 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
3 0.000396 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
4 0.000485 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
5 0.000379 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
6 0.000360 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
7 0.000310 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
8 0.000388 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
9 0.000373 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
10 0.000331 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
11 0.000379 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
12 0.000384 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
13 0.000325 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
...<snip>...
392 0.000357 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
393 0.000383 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
394 0.000424 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
395 0.000362 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
396 0.000470 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
397 0.000418 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
398 0.002223 query-m: COMMIT
Are there some mass-updates triggered by user actions that could possibly using
a job queue or something?
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
