[rt-users] RT Performance Problems

[Mat]

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.

> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Bob Apthorpe
> Sent: Thursday, 21 March 2002 4:33 AM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] RT Performance Problems
>
>
> On Wednesday 20 March 2002 02:21, you wrote:
> > 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
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users