[rt-users] RT query for test InnoDB performance

[Goddard Lee]

> On Mon, Jan 16, 2006 at 12:25:30PM +0100, Francesco Dalla Ca' wrote:
> > I have got RT 3.4.1 with the DB on a mysql server (4.0.20-max) with
> > InnoDB tables.
> > Since few months, i perceive a sensible performance 
> degradation. Mysql 
> > Support suggest me to do an "ALTER TABLE table 
> ENGINE=InnoDB;" (Null 
> > alter table) to defragment the table and recalculate index 
> statistics.
> 
> RT should _alway_ be run with InnoDB tables if you're running 
> on MySQL. Running with the default "MyISAM" table type is 
> dangerous and should be avoided.

I think he meant that MySQL support suggested he do that to force MySQL
to sort itself out, not to actually change the table type.

> > I want to test with a RT real and most frequently SQL query (for 
> > example
> > to search tickets) before and after "ALTER TABLE" 
> operation, to measure 
> > the improvement. Can anyone suggest a typical RT SQL query?

Why not perform a query and look in the MySQL logs?

lee