Last modified: 2012-08-01 15:22:17 UTC
The current gerrit query limit is set to 500. This is quite low for us and makes people waste a lot of time, see for instance the stats Sumana needed which required a lot of headaches to start with and 3 queries or a script in the end. Queries are restricted to people with SSH keys so they shouldn't be a problem. https://gerrit-review.googlesource.com/#/c/23053/ has been merged a while ago: "This limit applies not only to the `gerrit query` command, but also to the web UI results pagination size." Maybe we could set it at 5000 as with our nice MediaWiki queries? Or even more? No idea. Those are even open to everyone. ;-)
Maybe All-Projects is hidden in prod? or does it not exist? (google results indicate not existing is a Bad Thing) http://gerrit-dev.wmflabs.org/r/gitweb?p=All-Projects.git;a=summary does exist https://gerrit.wikimedia.org/r/gitweb?p=All-Projects.git;a=summary is 404 See also https://gerrit.wikimedia.org/r/Documentation/access-control.html
(In reply to comment #1) > Maybe All-Projects is hidden in prod? or does it not exist? (google results > indicate not existing is a Bad Thing) > > http://gerrit-dev.wmflabs.org/r/gitweb?p=All-Projects.git;a=summary does exist > https://gerrit.wikimedia.org/r/gitweb?p=All-Projects.git;a=summary is 404 > > See also https://gerrit.wikimedia.org/r/Documentation/access-control.html It exists, it's just not readable by default (all top-level projects implement this). That way we can have private repositories. Although, we probably could just grant Read by default and explicitly DENY reading of the private repos. Either way, it's unrelated to this discussion.
As far as increasing the query limit, that's probably a safe thing to do especially now that we're on the newer beefier hardware. However, I don't want to do it on a Friday when people are going home and won't be watching things. How about we raise it Monday :)
db1048 can handle the load easily, so we've gone ahead and raised the query limit to 5000 for logged in users.
Quick note: I had to also set anonymous users back to 500. Apparently overriding the original query limits set it to 0 for anons. 500 was their default, so I restored that. So current settings in All-Projects are: 0,5000 - Registered Users 0,500 - Anonymous Users