On Fri, Oct 23, 2009 at 12:00:05PM +0300, Laas Toom wrote:
> Hello!
>
> We have RT with ca 50 000 tickets in it, which, I think, has been
> running since 3.2 and upgraded lately to 3.8.5. After that I added RT-
> IR to it and everything seems to be fine except the Lookup IP query.
> First of all it takes ages. MySQL slow log reports query_time in order
> of 500 to 800 seconds and rows examined 3 to 4 millions.
What sorts of tuning have you done to mysql to date?
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
