I had the same problem and ended up dropping the Groups2 index and performance went back to "normal"
Nicola -----Original Message----- From: [email protected] on behalf of Alex Young Sent: Wed 8/18/2010 6:07 AM To: [email protected] Subject: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8 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!
