[rt-users] What software is recommended for high-loaded RT3.8-latest?

Kenneth Marshall ktm at rice.edu
Thu Apr 2 10:37:58 EDT 2009


On Thu, Apr 02, 2009 at 05:03:30PM +0300, Agnislav Onufrijchuk wrote:
> > Are these 4000 tickets per day or 4000 updates total? 100000 tickets
> > is not very many if you actually generate 4000 tickets per day. Do
> > you "shred" old tickets to remove them from your DB?
> 
> One more thing: we have 4000 transactions, but we have a number of long SELECT 
> queries every day. No, we didn't shred any of tickets yet, because currently we 
> use 3.4.4 version :(
> 

Have you run EXPLAIN or the MySQL equivalent to see what is taking
the time in the long queries? Maybe adjusting your indexes would
help.

Cheers,
Ken



More information about the rt-users mailing list