RT Performance Problems

Hi !
We have got a performance Problem concerning the creation of tickets:

We are running RT 2.0.7
and postfix.
Everytime we create a ticket, the systems takes ages to finnish the job. Analysis of the logfiles has shown the the mysqld process takes about 90 % CPU time during the creation. Unfortunatly the system wait until the mail ist processed. Is there a way to prevent the system from waiting for postfix.

Thanks

Nik Engel NETWAYS GmbH
Senior Systems Engineer Deutschherrnstr. 47a
Fon.0911/92885-13 D-90429 Nürnberg
Fax.0911/92885-33
nengel@netways.de www.netways.de

Hi !
We have got a performance Problem concerning the creation of tickets:

We are running RT 2.0.7
and postfix.

Upgrade to RT 2.0.11 or later. These versions have better indexing on the
MySQL tables which dramatically increases database performance. You can
probably apply these db changes without upgrading but this will require some
manual SQL queries. It may be easier just to upgrade rather than find and
apply the new indexing queries directly.

– Bob

Also you might want to make sure you have mysql optimised for your system,
while a ticket is being created try having a look at what mysql is actually
doing
by typing “show processlist” into the mysql command line, if you see any
queries
with the status of “writing to disk” that will most likely be the issue,
mysql needs
to be allocated more memory… there are quite a few other little things you
can tweak
with mysql.

Regards,
Mat.