logo       

Re: Re: How does update low priority work?: msg#01052

db.mysql.general

Subject: Re: Re: How does update low priority work?

k I understand that, but is there any way to make a statement async?
----
Andrei Cojocaru
spinlock_lists@xxxxxxxxxxxxxxx
----- Original Message -----
From: "Egor Egorov" <egor.egorov@xxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Friday, June 28, 2002 06:00
Subject: 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-spinlock_lists=empirequest.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
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-thread113301@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise