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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL
PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
