Re: LOW_PRIORITY_UPDATES queueing from multiple servers?

[Ingo Strüwing]

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.