[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[rtuser]@*************

  SELECT GET_LOCK('S', N)

 

Any ideas?

 

Thanks.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100818/ab839979/attachment.htm>