Database settings in Gerrit configuration Database settings in Gerrit configuration
Database settings in gerrit.config.
database.poolLimitYou might want to tune the database.poolLimit parameter:
Maximum number of open database connections. If the server needs more than this number, request processing threads will wait up to poolMaxWait seconds for a connection to be released before they abort with an exception. This limit must be several units higher than the total number of httpd and sshd threads as some request processing code paths may need multiple connections. Default is 8.In the gerrit.config file, it is set by default to 50 which is a reasonable value to start with. As a reference, here are some other values used by our customers: 52, 64 and 250.
Maximum number of connections to keep idle in the pool. If there are more idle connections, connections will be closed instead of being returned back to the pool. Default is 4.Values used by our customers: 12, 16
Maximum amount of time a request processing thread will wait to acquire a database connection from the pool. If no connection is released within this time period, the processing thread will abort its current operations and return an error to the client. Values should use common unit suffixes to express their setting: ms, milliseconds s, sec, second, seconds m, min, minute, minutes h, hr, hour, hours If a unit suffix is not specified, milliseconds is assumed. Default is 30 seconds.Values used by our customers: 60 seconds