|
Re: Re: How does update low priority work?: msg#01052db.mysql.general
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> |
|---|---|---|
| Previous by Date: | Re: multiple master mysql servers: 01052, Gerald Clark |
|---|---|
| Next by Date: | RE: table types: 01052, Cal Evans |
| Previous by Thread: | Re: Re: How does update low priority work?i: 01052, Egor Egorov |
| Next by Thread: | need help conceptualizing my first mySQL database: 01052, Timothy J. Luoma |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |