AW: [rt-users] RT Performance Problems

[Nik Engel]

> 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.

Actually i thought there ist a possibility, to give the mails directly to postfix, i heard something like sendmailpipe.... Won´t this help ? 
I encounter performance problems only when creating tickets and sending as a result of this mails. All other jobs are working with very good performance. 
I seems that mysql is realy wainting for postfix to send the mail. The machine is a dedicated one with 512MB Ram and a PIII 900 CPU. With an average of 10- 30 Tickets a day only. Seems not too much work for a linux system. 



> 
> 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
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com 
> http://lists.fsck.com/mailman/listinfo/rt-> users
>