Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default 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 at 12:58 PM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •