You are here: Re: How to avoid a parallel execution in MyQDL. « PHP Programming Language « IT news, forums, messages
Re: How to avoid a parallel execution in MyQDL.

Posted by Christopher Browne on 10/19/05 16:07

> 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.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация