[rt-users] One Performance problem identified

[Jesse Vincent]

> SELECT GET_LOCK('Apache-Session-d279953494e7dcbbaca2e566a94002f2', 3600);
> 
> Why is it taking so long to get a lock on a table?  I know it isn't taking

It's not a table lock. it's a session lock. As in Apache::Session
lcoking that row for the duration of an HTTP request.


> forever to actually query the database because the page loaded almost
> immediately after the above query completed.  We're using InnoDB as opposed to
> MyISAM.  Might that have something to do with it?
> 
> Any thoughts on this?
> 
> Mathew
> -- 
> Keep up with me and what I'm up to: http://theillien.blogspot.com
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
> 
> If you sign up for a new RT support contract before December 31, we'll take
> up to 20 percent off the price. This sale won't last long, so get in touch today. 
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
> 
> 
> 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
> 

--