Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-26 Thread Perrin Harkins
md wrote: --- md <[EMAIL PROTECTED]> wrote: Is it possible to have row-level locking (as opposed to table-level or null locker) with MySQL 4.x and Apache::Session? You effectively have that already, since the MySQL locker only locks an individual session. Check the code. Looks like I get that wi

Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-26 Thread md
--- md <[EMAIL PROTECTED]> wrote: > Is it possible to have row-level locking (as opposed > to table-level or null locker) with MySQL 4.x and > Apache::Session? Looks like I get that with InnoDB automatically... __ Do you Yahoo!? Yahoo! Tax Center

Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-26 Thread md
--- Perrin Harkins <[EMAIL PROTECTED]> wrote: > If you look at the actual contents of > Apache::Session::MySQL, you'll see > that it's essentially just a config file. There's > no need to be > concerned about using Flex, but you could easilly > code up your own > Apache::Session::MySQLNoLock

Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-25 Thread md
--- Perrin Harkins <[EMAIL PROTECTED]> wrote: > It would be. Frankly, there is no value to the kind > of mutual exclusion > that the Apache::Session locking provides in a > typical web application. > If you use the null locker you will still get > atomic updates, but you > will have the pos

Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-25 Thread Perrin Harkins
md wrote: Also, we'll soon be adding a substantial number of users to our system and I wonder if it would be wise to move away from the table locking that is currently being used with Apache::Session::MySQL. It would be. Frankly, there is no value to the kind of mutual exclusion that the Apache::

Re: Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-25 Thread Cory 'G' Watson
On Tuesday, February 25, 2003, at 11:55 AM, md wrote: We're using Apache::Session::MySQL (Apache::Session 1.54) and occassionaly see long lock times. I had a similar problem a few months ago with Apache::Session::Postgres. I occasionally had Apache processes hang, and a quick ps aux shows a st

Table/row locking with Apache::Session::Mysql /Apache::Session::Flex

2003-02-25 Thread md
We're using Apache::Session::MySQL (Apache::Session 1.54) and occassionaly see long lock times. Also, we'll soon be adding a substantial number of users to our system and I wonder if it would be wise to move away from the table locking that is currently being used with Apache::Session::MySQL. I'