<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7655.8">
<TITLE>RE: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>I had the same problem and ended up dropping the Groups2 index and performance went back to "normal"<BR>
<BR>
Nicola<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com on behalf of Alex Young<BR>
Sent: Wed 8/18/2010 6:07 AM<BR>
To: rt-users@lists.bestpractical.com<BR>
Subject: [rt-users] Slow MySQL after upgrade from 3.8.6 to 3.8.8<BR>
<BR>
Hi,<BR>
<BR>
Since upgrading from 3.8.6 to 3.8.8 our RT system has<BR>
been very slow to return any pages containing ticket data such as the<BR>
home page, searches and tickets themselves.<BR>
<BR>
<BR>
<BR>
I enabled the MySQL slow running query log and this was at the top of<BR>
the list:<BR>
<BR>
<BR>
<BR>
mysqldumpslow -t 10 /var/log/mysql/mysql-slow.log<BR>
<BR>
Reading mysql slow query log from /var/log/mysql/mysql-slow.log<BR>
<BR>
Count: 47 Time=10.12s (475s) Lock=0.00s (0s) Rows=1.0 (47),<BR>
rtuser[rtuser]@*************<BR>
<BR>
SELECT GET_LOCK('S', N)<BR>
<BR>
<BR>
<BR>
Any ideas?<BR>
<BR>
<BR>
<BR>
Thanks.<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>