[rt-users] Apache Session locking taking a while

[Ham MI-ID, Torsten Brumm]

Hi Micah,
as i wrote some days ago, we had/have the same problem and fixed this in a unclean way:

We changed the following: (and again, i'm not sure if it is a good idea, but it fixes the problem)

grab up from /usr/lib/perl5/site_perl/5.8.xxx/Apache/Session/Lock the file MySQL.pm and find the line with my GET_LOCK, its around line 53. It uses default 3600 sec for lock timeout. we changed this to 1sec.

     50     #MySQL requires a timeout on the lock operation.  There is no option
     51     #to simply wait forever.  So we'll wait for a hour.
     52
     53     my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 1)}, {}, 1);

And again, and hopefully some of the DB/PERL Gurus have a better idea, this fixed our problem (for over one year) but i'm not sure which site effects it has (we discovered nothing so far....)

And again as i wrote in my last post: This is working so far (several months or longer) but i'm not sure if this is the best way.

Try it, here it works well.

Torsten 


Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne


-----Ursprüngliche Nachricht-----
Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Micah Gersten
Gesendet: Mittwoch, 19. November 2008 03:56
An: RT Users
Betreff: [rt-users] Apache Session locking taking a while

For some pages, we get apache session locks taking 3-9+ seconds. 
Generally, no queries appear in the slow query log except for getting the apache session lock.  I have slow queries in MySQL set to 2 secs.
Has anyone else had any experience with this?
Current setup:
MySQL 5.0.32
Apache 1.3.34
RT 3.6.0

Let me know if you need more config info.

-- 


Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com