[rt-users] Slow GET_LOCK queries on merged tickets

[Kenny Seever]

Hello everyone.   I was looking through the archives and came across the following.  It looks like we are having the same problem and I was wondering if a solution was ever found.
 
Thanks in advance,
 
Kenny Seever
Innovative Networks, Inc.
 
 
 
Original Message…:
 
Hi all, 



I managed to track down a problem with merged tickets being slow to 
display. I have enabled the slow queries log on Mysql (5.0.51a) and get 
the following in the log files. I searched over the RT list archives and 
I found note of setting low_priority_updates to 1 on mysql for this. 
This however makes no difference. Does someone perhaps have an answer 
for this problem? 



The server is a test setup I made to test the migration of 3.6.6 RT 
installation to 3.8.1. The problem was there in 3.6.6 when I imported 
the production database from a mysql dump the production server also 
running rt 3.6.6 is fine (not slow on merged tickets). The difference 
between the systems is that the production server is a Redhat Enterprise 
4 server (MySQL-server-community-5.0.51a-0.rhel4) and the test system is 
a newer Fedora 9 (mysql-server-5.0.51a-1.fc9). The fedora 9 installation 
installed all required modules from CPAN during installation. After 
migrating it to 3.8.1 the problem remains. It looks like it slightly 
faster but not much. Database has been updated from mysql 4.0 to 4.1 
followed by the database update script. All is working fine accept for 
the slow queries on merged tickets and the GET_LOCK reports in the slow 
query log. 



I've cleared the session table. This currently makes no difference. It 
had about 1100 records in it before I cleared it. 



Regards, 



Ton Hoogstraten 



SELECT GET_LOCK('Apache-Session-7dee36ca13e864c568b1659d2fa18751', 
3600); 

# Time: 080822 14:36:01 

# User[at]Host: rt[rt] @ localhost [] 

# Query_time: 110 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 

SELECT GET_LOCK('Apache-Session-a196db0f41ab721840dba0b78f2dd36e', 
3600); 

# User[at]Host: rt[rt] @ localhost [] 

# Query_time: 80 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 

SELECT GET_LOCK('Apache-Session-a196db0f41ab721840dba0b78f2dd36e', 
3600);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081107/8c025dba/attachment.htm>