[rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8

[Alex Young]

Hi,

                Since upgrading from 3.8.6 to 3.8.8 our RT system has
been very slow to return any pages containing ticket data such as the
home page, searches and tickets themselves.

 

I enabled the MySQL slow running query log and this was at the top of
the list:

 

mysqldumpslow -t 10 /var/log/mysql/mysql-slow.log

Reading mysql slow query log from /var/log/mysql/mysql-slow.log

Count: 47  Time=10.12s (475s)  Lock=0.00s (0s)  Rows=1.0 (47),
rtuser[rtus...@*************

  SELECT GET_LOCK('S', N)

 

Any ideas?

 

Thanks.


RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!