Print

Print


Gonçalo Borges wrote:

> Isn't the limit of 4G imposed at instalation/configuration time?
> Is there a way to let /var/lib/mysql/lbserver20/ grow to infinity, as 
> you say? How do you define it?

YAIM's config_lbserver_db function runs this:

   mysql --password="$MYSQL_PASSWORD" lbserver20 < ${INSTALL_ROOT}/edg/etc/server.sql

That file has these contents:

[...]
alter table short_fields max_rows=1000000000;
alter table long_fields max_rows=55000000;
alter table states max_rows=9500000;
alter table events max_rows=175000000;

According to David Smith: "this should allow the database to hold up to
about 9.5M events. (At which time it will be about 220 GB in size).
With the default limit the critical number of jobs is ~550,000."