Announcement

Collapse
No announcement yet.

6.18.1 database tuning

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 6.18.1 database tuning

    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:

    Code:
    # /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
    Last edited by Martin Heiland; 10-19-2010, 12:58 PM.
Working...
X