List:General Discussion« Previous MessageNext Message »
From:adam nelson Date:May 14 2002 1:45pm
Subject:RE: Row Locking issue in 3.23.x
View as plain text  
use InnoDB which does support row-locking (MySQL-Max)

-----Original Message-----
From: Sherzod B. Ruzmetov [mailto:sherzodr@stripped] 
Sent: Tuesday, May 14, 2002 9:23 AM
To: msql-mysql-modules@stripped; MySQL Maling list
Subject: Row Locking issue in 3.23.x



Hi. As far as I know, MySQL doesn't suport row-locking, only table
locking
is available.

But I figured table locking for sessions table of CGI::Session::MySQL 
would be 
quite inefficient, for there might be millions of rows and hundreds of 
them
could be active at any time. So what do you guys think of locking a 
specific row with a semaphore file and what conventions should the
locker 
and/or the table should follow?




Thread
server has gone away, second tryDerick H Siddoway14 Apr
  • RE: Row Locking issue in 3.23.xadam nelson14 May
Re: server has gone away, second tryDerick H Siddoway14 Apr
Re: server has gone away, second tryemilio lumia14 Apr