[rt-users] RT-IR IP lookup slow

Jesse Vincent jesse at bestpractical.com
Fri Oct 23 13:16:51 EDT 2009




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?



More information about the rt-users mailing list