[rt-users] One Performance problem identified

Mathew Snyder theillien at yahoo.com
Wed Nov 7 11:44:00 EST 2007


Question:

As I stated before, our tables are using InnoDB.  No particular reason, just the
default which wasn't changed.  If I use the InnoDB specific file
(my-innodb-heavy-4G.cnf) located in /usr/share/doc/mysql-server-xx and restart
the server, I lose everything when I refresh my screen.  I can no longer access
RT at a glance.  Instead, it appears that I'm dumped to the self-service screen.
 How can I change mysqld to use this .cnf without breaking RT?

Keep up with me and what I'm up to: 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.
> 
> 
>> 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
>>
> 



More information about the rt-users mailing list