https://bugzilla.wikimedia.org/show_bug.cgi?id=42614
--- Comment #23 from Nemo <[email protected]> --- (In reply to comment #22) > So that sum up to 29%. Roughly 30% were admin commands, so claimRandom took > like half the time of the queries :-/ Gerrit change 38454. >From #wikimedia-operations: 23.26 < binasher> AaronSchulz: look at the explain on JobQueueDB::claimRandom 23.26 < AaronSchulz> I recall doing that before and not seeing anything interesting 23.26 < binasher> | 1 | SIMPLE | job | ref | job_cmd,job_cmd_token,job_cmd_token_id | job_cmd_token | 291 | const,const | 110700 | Using where | 23.27 < binasher> 110700 = the rows read column 23.29 < apergos> o_O 23.31 < binasher> no wonder the claimRandom calls were killing commons 23.31 < binasher> AaronSchulz: can you drop the order by from that query? 23.32 < MaxSem> mmm, ORDER BY kinda gives us the randomness:) 23.32 < binasher> its not needed for some randomness since the job_random constraint is itself picked randomly 23.32 < binasher> nor is totally random claiming of jobs a requirement -- 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
