[rt-users] sessions table myisam or innodb
Roy El-Hames
rfh at pipex.net
Tue Jan 15 09:54:44 EST 2008
Hi;
rt-3.6.3
apache2
mysql5.1
For better performance should the sessions table be myisam or innondb??
had a look in etc/schema.mysql and there is no engine type definition
for sessions
currently my sessions table is myisam, every now and then rt freezes due
to user lock on the session table. To keep it small, I have a script
that delete expired sessions every 6 hours. however I am wondering if
this is causing another problem with concurrent inserts due to deleted
rows in the middle of the table ?/ any suggestion.
Regards
Roy
More information about the rt-users
mailing list