[rt-users] One Performance problem identified
theillien at yahoo.com
Wed Nov 7 11:44:00 EST 2007
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?
>> 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