I found a helpful tidbit about auto-increment counters today: to reset them, issue a command like:

ALTER TABLE tablename AUTO_INCREMENT = 1

I thought that back in the 3.23 days MySQL used to reclaim auto_increment ids if they were at the end of a sequence, but perhaps I am mistaken.