[rt-users] rt-2-1-85: mysql performance ?

Carlos Canau canau at keka.KPNQwest.pt
Fri Mar 14 11:08:40 EST 2003


On Fri, Mar 14, 2003 at 04:07:28PM +0100, Harald Wagener wrote:
> 
> Am Freitag, 14.03.03 um 16:03 Uhr schrieb Carlos Canau:
> 
> >I've  DROPped the  INDEXes  and  ALTERed all  tables  to type  INNODB.
> >Performance is  better but  it still takes  about 5 seconds  to change
> >between  tickets.

Nopes... I was  wrong. What I observe from  "feeling" and looking into
the clock in the righthand of the screen:

Ticket browsing:

MyISAM (RH73-mysql-3.23.54a-3.73-default): +/- 10 sec
INNODB (RH73-mysql-3.23.54a-3.73): +/- 7 sec
INNODB + my INDEXes: +/- 5 sec

> >
> >Should it be this way and  should I upgrade the hardware or can mysql,
> >innodb and rt3 be fine tuned to perform better ?
> >
> >An upgrade from RH7.3 to RH8.0 would help ??
> 
> No! RedHat 8.0 is a rat's nest for other problems (apache/perl/modperl 
> setup and versions don't seem to play nice with RT3 at the moment. I 
> tend to blame RH for this these days...).

Yikes!... luckily RH  will drop support for it on the  end of the year
:->>>

regards,
</canau



More information about the rt-users mailing list