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

Carlos Canau canau at keka.KPNQwest.pt
Sat Mar 15 17:09:26 EST 2003


On Fri, Mar 14, 2003 at 04:08:40PM +0000, Carlos Canau wrote:
> 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

I've   upgraded  from   3.23.54a  to   MySQL  4.0.11   (binaries  from
www.mysql.com):  more   or  less   1-2  sec.  improvement   on  ticket
browsing. I'm still on the 3-4 sec. per ticket change.

</canau





More information about the rt-users mailing list