[rt-users] RT 3.0 Speed

[Jesse Vincent]

On Tue, May 06, 2003 at 01:52:50PM +0100, Simon Woodward wrote:
> Hi,
> 
> I have just completed a transfer from 2 to 3 and I am seeing something
> very similar:
> 
> Single Athlon 1Ghz
> 512Mb RAM
> RT 3.0.1
> Apache 1.3.27
> MySQL 4.0.12
> Linux 2.2.17 
> perl 5.8.0
> mod_perl 1.27
> HTML-Mason-1.19
> All perl dependencies etc met, (see below for output).
> 
> MySQL specific configuration:
> 
> datadir=/usr/local/var/mysql
> innodb_data_file_path=ibdata1:10M:autoextend:max:2000M
> innodb_buffer_pool_size=128M
> innodb_additional_mem_pool_size=32M

I don't have the mysql docs in front of me, but these feel low.

> innodb_log_buffer_size=8M
> innodb_flush_log_at_trx_commit=1
> 
> RT3 is just running dog slow, on the same system that runs RT2 at a
> decent speed. The only difference I can say other than the difference
> between RT2 and RT3 is that RT3 is using InnoDB where as RT2 was not.
> 
> I've never used InnoDB before, so am ploughing through MySQL manuals and
> looking at performance tweaks, however it can take 30 seconds to a minut
> + to load the first screen, and similar for any action that uses the DB.


Things that would be useful to know:
	How much free memory on the box? Is it swapping?
	How many rows in your: Users, Groups, GroupMembers,
	CachedGroupMembers, Queues, ACL, Tickets and Transactions 
	tables?

	What load is the box running at?

	Are you sure the RT tables are actually innodb? Mysql may
	silently ignore the innodb directive if you don't have it
	configured right.

	What mysql queries appear to be taking a long time?



-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.