Re: Table as fifo

[Rick James]

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

In particular, I need to know what index you are using on the table. And how big your cache is. And probably other things.

"Don't queue it, just do it" -- That is one of my mantras. To argue against this, please spell out the timings:
* How often is an item added
* How long does it take to process an item
* How long does an item stay in the queue (worst case)

Given all that info, I may agree that a FIFO is the 'right way'. And I may have enough info to explain the slowdown, or give you a fix.