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

2010-08-18 Thread 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

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

2010-08-18 Thread Foggi, Nicola
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

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

2010-08-18 Thread Alex Young
...@depaul.edu] Sent: 18 August 2010 15:02 To: Alex Young; rt-users@lists.bestpractical.com Subject: RE: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8 I had the same problem and ended up dropping the Groups2 index and performance went back to normal Nicola -Original Message- From

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

2010-08-18 Thread Alex Young
...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Young Sent: 18 August 2010 16:19 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8 Thanks Nicola, I have just tried this and it's not made