David T. Ashley wrote:
Nigel wrote:
mod_php will persist the MySQL connection holding open any lock or
syncronisation token obtained through any of the three methods :
begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
ensure that even in the event of timeouts or fatal e
Nigel wrote:
> mod_php will persist the MySQL connection holding open any lock or
> syncronisation token obtained through any of the three methods :
> begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
> ensure that even in the event of timeouts or fatal errors any shutdown
>
David T. Ashley wrote:
Nigel wrote:
If you can't or won't do this properly by using a transactional table
and begin/commit at least look at using get_lock() based guard
conditions which only lock a string leaving the database accessable.
Whatever you do if you client is php install a shutdo
Nigel wrote:
> If you can't or won't do this properly by using a transactional table
> and begin/commit at least look at using get_lock() based guard
> conditions which only lock a string leaving the database accessable.
> Whatever you do if you client is php install a shutdown handler to clean
>
David T. Ashley wrote:
Hi,
I'm doing a PHP application, and there are just a few instances where I need
to do atomic operations on more than one table at a time and I can't express
what I want to do as a single SQL statement.
What I'm trying to guard against, naturally, is race conditions when
Hi,
I'm doing a PHP application, and there are just a few instances where I need
to do atomic operations on more than one table at a time and I can't express
what I want to do as a single SQL statement.
What I'm trying to guard against, naturally, is race conditions when more
than one process is
