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

Foggi, Nicola NFOGGI at depaul.edu
Wed Aug 18 10:01:50 EDT 2010

I had the same problem and ended up dropping the Groups2 index and performance went back to "normal"


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com on behalf of Alex Young
Sent: Wed 8/18/2010 6:07 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8

                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),



Any ideas?



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

More information about the rt-users mailing list