Re: How to avoid a parallel execution in MyQDL.

> On my server users have access to MySQL database (through PHP). What I
> would like to avoid is parallel execution of commands. I mean, if one
> user run some sequence of command the sequence of commands run by
> another user should stay in query till the first sequence is finished.
> Is it possible to reach this only with the usage of "mysql_connect"
> in the beginning of sequence of command and "mysql_close" in the
> end. In another words, is it true that another user cannot make
> connection with DB and execute commands before the first user close
> connection (with "mysql_close")?

You might check with the vendor to see if there is some way to
configure it to limit the number of connections. If so, then your
process could grab all the connections, and not relinquish any until
the vital process is complete.

Alternatively, you might check to see if there is a way of expressly
requesting locks on the tables which the vital process uses. If you
start by locking them, that might accomplish the goal without fiddling
with connections.

-- 
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://cbbrowne.com/info/
If we were meant to fly, we wouldn't keep losing our luggage.