Changeset 709 for trunk/UPGRADE

Show
Ignore:
Timestamp:
15/10/08 00:38:59 (3 months ago)
Author:
markdoliner
Message:

Add a key to the status table in MySQL. This should make queries to
that table a bit faster.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/UPGRADE

    r693 r709  
    11This file contains upgrade instructions between different versions of jabberd2. 
     2 
     3* 2.2.4 to 2.2.5 upgrade: 
     4 
     5A key was added to the 'status' table in MySQL.  This improves performance 
     6for queries to that table.  The is recommended for everyone, but will have 
     7the biggest impact for installations with a large number of signons and 
     8signoffs.  It only affects installations with mod_status enabled. 
     9You can add the key by running this statement: 
     10ALTER TABLE status ADD KEY (`collection-owner`(255)); 
    211 
    312