[horde] locking on horde_sessionhandler

Jan Schneider jan at horde.org
Wed Mar 29 11:32:23 PST 2006

Zitat von Gabriel Sere <gsere at tecnet.com.uy>:

> 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.

It is.


Do you need professional PHP or Horde consulting?

More information about the horde mailing list