Re: LOW_PRIORITY_UPDATES queueing from multiple servers?
The numbers show the time in seconds since the command was started.
Here it means that both updates are waiting (and/or processing) since over two minutes.
It tells nothing about the priority order in which the commands are scheduled. A quick view in the sources shows that the server should behave as you expect. It should schedule the normal update first, then all selects (including those stepping in while other selects are still running) and then the low priority update.
However, if the list you showed is complete, then this could only mean that the selecting connection holds a read lock on the table. Otherwise it would not be explainable why the ten seconds old select should run before the 128 seconds old update.
For all this I assumed that all three commands work on the same table.
BTW, next time please mention at least the MySQL version number (I looked into the 4.1 sources) and ideally also the operating system you are using.
Subject
Views
Written By
Posted
3769
November 11, 2005 01:12PM
Re: LOW_PRIORITY_UPDATES queueing from multiple servers?
2006
November 14, 2005 05:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.