Re: Re: How does update low priority work?

Andrei,
Thursday, June 27, 2002, 4:50:54 PM, you wrote:

AC> Is there any way to tell mySQL to return immediatly?

In any case MySQL waits for the UPDATe complete, but if you
specify LOW PRIORITY MySQL wait fot the all SELECTs to complete and then
will only execute the UPDATE.

AC> ----
AC> Andrei Cojocaru
AC> spinlock_lists@xxxxxxxxxxxxxxx

AC> ----- Original Message -----
AC> From: "Egor Egorov" <egor.egorov@xxxxxxxxxx>
AC> To: <mysql@xxxxxxxxxxxxxxx>
AC> Sent: Thursday, June 27, 2002 02:44
AC> Subject: Re: How does update low priority work?


>> Andrei,
>> Thursday, June 27, 2002, 5:19:21 AM, you wrote:
>>
>> AC> If you execute UPDATE LOW PRIORITY table_name .. does mySQL
AC> automatically
>> AC> return or does it wait for the update to execute? (that is, is it
AC> async or
>> AC> sync)?
>>
>> MySQL waits for the UPDATE complete.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@xxxxxxxxxx
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   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 <mysql-thread113297@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php