How can we treat a Mysql table as a limited FIFO buffer (Queue).
Objectives are :
Past Mysql 5 you could use a trigger to achieve this.
then your triggered sql would be along the lines off:
DELETE FROM foo WHERE id NOT IN (SELECT id FROM foo ORDER BY id DESC LIMIT 10)