I am in big trouble with MySQL 5.
I have a huge table, about 25 GIGABYTES, that is a cache for hard to
compute items. Each row has two timestamps, last updated and last
retrieved timestamp, some metadata, key and a BLOB.
I would like to clean that table based on timestamps. I used to clean
it periodically, but doing a big DELETE...WHERE query locks it up for
HOURS and that means downtime for my website, lost money, ed off
So, I thought, I would write a process that would do
SELECT id FROM bincache WHERE ... LIMIT ...