[rt-users] RT-IR IP lookup slow

[Jesse Vincent]

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?