[rt-users] One Performance problem identified
theillien at yahoo.com
Tue Nov 6 19:57:09 EST 2007
Keep up with my goings on at http://theillien.blogspot.com
Jesse Vincent wrote:
>> 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.
So what you're saying is that the query actually *is* taking that long?
>> 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?
>> Keep up with me and what I'm up to: http://theillien.blogspot.com
>> 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
More information about the rt-users