Given:
Client A:
SELECT * FROM mytable WHERE status = 1;
Client B:
UPDATE LOW_PRIORITY mytable SET status = 2 WHERE id = $n
How long will A prevent B from writing? I'm concerned that clients
like A will prevent B from ever writing. In practice, how long does a
low priority write typi
If I use UPDATE LOW_PRIORITY, will the client then have to wait for the
update query to finish or not?
Regards, Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Jacob,
Monday, November 25, 2002, 12:03:14 PM, you wrote:
> If I use UPDATE LOW_PRIORITY, will the client then have to
> wait for the
> update to finish or not?
Yes, it will wait.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spo
Venlig hilsen
Jacob Friis Larsen
[ JFL WebCom | www.webcom.dk | +45 7027 0767 ]
> -Oprindelig meddelelse-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sendt: 25. november 2002 11:02
> Til: Jacob Friis Larsen
> Emne: Re: UPDATE LOW_PRIORITY database
>
Jacob,
Monday, July 29, 2002, 12:19:14 PM, you wrote:
JFL> MySQL question:
JFL> If I use UPDATE LOW_PRIORITY will the client then have to wait for the
JFL> update to finish or is UPDATE LOW_PRIORITY the same as INSERT DELAYED ?
It's not the same as INSERT DELAYED. Client wil
MySQL question:
If I use UPDATE LOW_PRIORITY will the client then have to wait for the
update to finish or is UPDATE LOW_PRIORITY the same as INSERT DELAYED ?
-
Before posting, please check:
http://www.mysql.com/manual.php
