[horde] locking on horde_sessionhandler
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.
Do you need professional PHP or Horde consulting?
More information about the horde