I just did a practice insert that put in 1700 rows. When I verified that it worked, I deleted all of them. The next rID that was used, on the next insert, was still 1700 higher than I thought it should be. Won't mySQL make use of primary row numbers that have been deleted? Otherwise I can see that primary key field getting quite high over time.

Thank you.