[rt-users] RT query for test InnoDB performance

[Francesco Dalla Ca']

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.

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?

Thank in advance.
Regards, Francesco.

-- 
--------------------------------------------------
Francesco Dalla Ca'
Settore Gestione Sistemi CINECA
Via Magnanelli 6/3  40033 Casalecchio di Reno (BO)
Bologna, Italy            
http://www.cineca.it
--------------------------------------------------