[rt-users] RT query for test InnoDB performance

[Jesse Vincent]

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.

Jesse


> 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
> -------------------------------------------------- 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at 
> http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html
> 

--