[rt-users] Slow GET_LOCK queries on merged tickets

[Hoogstraten, Ton]

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/20080825/19b00540/attachment.htm>