6.18.1 database tuning

[Martin Heiland]

Hi all,

with 6.18.1 we introduced a very convenient new folder tree that shows all visible folders in a simple overview. This feature triggers slightly more "burst" database load since a lot folders have to be loaded right away when logging in or accessing a certain module with many folders.

We have experienced some cases where the database connection count climbed up until the maximum configured at the database server. Open-Xchange Server contains a database connection limit which should be enabled. Per default, OX is allowed to open 100 concurrent database connections, but the limit is disabled. To enabled it, do the following:

# /opt/open-xchange/sbin/listdatabase -A oxadminmaster -P secret
id name       hostname  master mid weight maxctx curctx hlimit max inital
 4 oxdatabase localhost true     0    100   1000      1 false  100      0

# /opt/open-xchange/sbin/changedatabase -A oxadminmaster -P secret -i 4 -l true 
database 4 changed

# /opt/open-xchange/sbin/listdatabase -A oxadminmaster -P secret
id name       hostname  master mid weight maxctx curctx hlimit max inital
 4 oxdatabase localhost true     0    100   1000      1 true   100      0

This enables the "hlimit" option for the selected database. The database id is shown at the first column of the "listdatabase" output. Use this id for the -i parameter of "changedatabase". The overall database usage should not be much higher than before, but some action might trigger more intense access for a short period of time.

Hope that helps