On 26 Aug 2001 13:55:40 -0700, Jeremy Zawodny wrote:
> On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote:
> > Does mysql have something like NO LOCK?
> >
> > SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
>
> By default, no. But if you use InnoDB tables in MySQL, you'll get
> non-locking SELECTS, which is probably what you're looking for. See
> the docs at http://www.mysql.com/doc/ for more info.
Yes, this is true. Additionally I would like to say that I asked similar
question from Monty when I yet wasn't empoyed by MySQL and he told that
usually same behaviour can be got if INSERT DELAYED is used. SELECTS do
not lock on tables like adview/adclick stuff where no high accuracy
needed.
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php