Re: Eliminate filesort in update query

[Rick James]

> 135 poll operations per second

Ugh! As I say, "Don't queue it, just do it".
It sounds like the MySQL-based queue is about to be the bottleneck in your system.

If the workers are on the same machine, then spawn processes to do the actions, and pass (what you would have put into the queue) either as parameters on the command line or in a pipe.

If the workers are on other machines, then do a round-robin HTTP request the worker machines, passing the parameters in the url (perhaps using "REST").