https://bugzilla.wikimedia.org/show_bug.cgi?id=42614
Antoine "hashar" Musso <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #22 from Antoine "hashar" Musso <[email protected]> --- db39 in production showed JobQueueDB::claimRandom has using 21% of query time: /* JobQueueDB::claimRandom */ SELECT * FROM `job` WHERE job_cmd = ? AND job_token = ? AND (job_random <= ?) ORDER BY job_random DESC limit ? And 8% for: /* JobQueueDB::claimRandom */ SELECT * FROM `job` WHERE job_cmd = ? AND job_token = ? AND (job_random >= ?) ORDER BY job_random limit ? So that sum up to 29%. Roughly 30% were admin commands, so claimRandom took like half the time of the queries :-/ -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
