[horde] locking on horde_sessionhandler

Gabriel Sere gsere at tecnet.com.uy
Wed Mar 29 05:18:12 PST 2006


The table horde_sessionhandler is defined with InnoDB
engine. The mysql 5.0 manuals says table locking on this
kind of tables should be avoided because the locking is
automatic. Also lock this tables could introduce unexpected
and long delays on select statments.

May be the statement

$result = @mysql_query('LOCK TABLES ' . $this->_params['table'] .
	' WRITE', $this->_db);

at line 97 on file lib/Horde/SessionHandler/mysql.php should be
performed only if the table is not InnoDB.

Gabriel.


More information about the horde mailing list