Last modified: 2014-07-04 02:49:11 UTC
Per Bug 50832 (and the comments in InitialiseSettings.php), I would like to propose raising wgQueryCacheLimit from 1000 to 2000 on en.wiki. Currently, it is set to 1000 for en.wiki, 2000 for de.wiki, and 5000 for all other wikis.
Guess Asher/Tim should probably weigh in on this
*poke* Adding springle as well.
All those queries are generally filesorts and quite expensive. I would be very surprised if the query cache limit had much of an affect on anything performance wise.
@Bawolff: Does that mean you would be OK with increasing it to 2000 or are you suggestion some other course of action (like getting rid of the limits)?
I mean im ok with increasing. Some limit is probably needed, i just doubt 1000 vs 2000 would make any appreciable difference. I would go as far as to suggest 5000 to be reasonable. Since cached special pages are paged via offset, a super really high limit would eventually introduce performance problems on the viewing cached results stage. But that's wiki agnostic anyways. No limits would probably also result in inserting a hundred thousand rows which would also be bad. (i should be 100% clear that this is just my personal opinion. I definitely *do not* have the authority to decree what is and is not acceptable performance wise for wikimedia. I also have not profiled different settings or otherwise tested)