Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- How to avoid a parallel execution in MyQDL.
October 19, 2005, 11:20 am
rate this thread
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")?
- Christopher Browne
October 19, 2005, 1:07 pm
Re: How to avoid a parallel execution in MyQDL.
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
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
If we were meant to fly, we wouldn't keep losing our luggage.