Planet MySQL

Displaying posts with tag: InnoDB Purge (reset)

Mar

2026

Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)

Posted by Jean-François Gagné on Mon 02 Mar 2026 19:47 UTC
Tags:

innodb, optimization, slow queries, MySQL, Blindspot, rows examined, delete-marked rows, InnoDB Purge, rows examined blindspot

I am starting a blog post series on using indexes — or tables — as queues.  I had this series in the back of my mind for some time.  This started a few years back when I worked on optimizing a row deletion job (I do not call this a purge job, to avoid confusion with the InnoDB Purge).  Such jobs can be generalized to using indexes (or tables) as queues (this is

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links