I had this problem about a month ago. Search the archives for: Apache Session locking taking a while You should see some info on a possible fix.
Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Bryan McLellan wrote: > I'm having issues with large tickets taking a while to load. FF3, IE7 > and Links all show the symptoms where there will be long pauses > between tickets being displayed > > RT 3.8.1 (source build) on Ubuntu intrepid amd64, with fast-cgi > mysql-server 5.0.32-7etch5 on Debian etch x86, with huge.cnf > > on the mysql server in the "show process-list" shows: > | Id | User | Host | db | > Command | Time | State | Info > | > | 220 | rtuser | client:60233 | rtdb | Query | 28 | User > lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', > 3600) | > | 221 | rtuser | client:60260 | rtdb | Query | 28 | User > lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', > 3600) | > | 223 | rtuser | client:60281 | rtdb | Query | 28 | User > lock | SELECT GET_LOCK('Apache-Session-a085f3079e948dbcff5c416644dce981', > 3600) | > > About 20 comments on this ticket. One merge. > > The time column continues growing until the page is loaded: Time to > display: 87.689462 > > The database has been through a number of upgrades from about 3.6.1. > Perhaps there's something that went wrong in a db upgrade? Maybe I > should try to dump and import the data to a fresh database? > > Bryan > _______________________________________________ > 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