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

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/



More information about the horde mailing list