[rt-users] MySQL Optimization

[Michael S. Liebman]

On Fri, Mar 19, 2004 at 10:26:50AM -0500, Asif Iqbal wrote:
> Has anyone tried to optimize the mysql to improve the performance on RT
> 3.0.9 ?

Make sure you are using the appropriate memory settings from the
my-(small|medium|large|huge).cnf sample files.

> mysqldump -f --opt {database_name} > /tmp/db.sql
> mysql {database_name} < /tmp/db.sql

All that will do is give you a faster dump/load of your database. It doesn't optimize the database just the dump/load process.

Michael
-- 
Michael S. Liebman                      m-liebman at northwestern.edu
                  http://msl521.freeshell.org/
"I have vision and the rest of the world wears bifocals."
        -Paul Newman in "Butch Cassidy & the Sundance Kid"