3.6.0/mysql 4: sessions is MyISAM?

(3.6.0/mysql-4.1.20/CentOS 4.3)

Hi -
Trying to figure out why my performance goes in the crapper on
requests for merged tickets, and I noticed that all of my db tables are
InnoDB – except sessions, which is MyISAM. I also noticed that when I’m
monitoring with mysql-administrator, the query that seems to take
forever (>120 seconds sometimes, on a db with only about 300 tickets in
it so far) looks like this:

SELECT GET_LOCK(‘Apache-Session-b2dec1598b67a7a5cfc7c7c9696c002c’, 3600)

Is there anything to be gained by converting sessions to InnoDB, or
should I leave it as MyISAM? (I have no other MyISAM tables in this
server, so at the very least I could free up the resources by removing
the engine.)

Thoughts?

Thanks,
	Ole

/Ole Craig
Security Engineer

303-381-3802 (main support hotline)
303-381-3824 (my direct line)
303-381-3801 (fax)

www.stillsecure.com
. . .

Hello everyone,

I have the same problem Ole had with his installation:

After upgrading to 3.6.6 merged tickets are really slow.

I saw a lot of MySQL entrys stating that get_lock queries took a long
time:

Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 0

use rtdb;
SELECT GET_LOCK(‘Apache-Session-1b11b6323211dc42ec9d40473784e254’,
3600);

After changing the session backend to Apache::Session::File the mysql
log entries are gone but the ticket system is not faster than before…

However, this does only affect merged tickets.

It seems that rt locks and tries to access the locked data in some way
because it used to be two tickets.

Has anyone a solution to this problem?On Mi, Aug 23, 2006 at 11:14:20 -0600, Ole Craig ocraig@stillsecure.com wrote:

(3.6.0/mysql-4.1.20/CentOS 4.3)

Hi -
Trying to figure out why my performance goes in the crapper on
requests for merged tickets, and I noticed that all of my db tables are
InnoDB – except sessions, which is MyISAM. I also noticed that when I’m
monitoring with mysql-administrator, the query that seems to take
forever (>120 seconds sometimes, on a db with only about 300 tickets in
it so far) looks like this:

SELECT GET_LOCK(‘Apache-Session-b2dec1598b67a7a5cfc7c7c9696c002c’, 3600)

Is there anything to be gained by converting sessions to InnoDB, or
should I leave it as MyISAM? (I have no other MyISAM tables in this
server, so at the very least I could free up the resources by removing
the engine.)

Thoughts?

Thanks,
Ole


/Ole Craig
Security Engineer

303-381-3802 (main support hotline)
303-381-3824 (my direct line)
303-381-3801 (fax)

www.stillsecure.com
. . .


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Warning: You are not root

     -- nmap V. 2.54BETA31