This is from the docs . "The auto-increment value of a deleted record will
only not be reused until the server is restarted, then it will be reused. In
other words, if you insert 10 rows into an InnoDB table and then delete them
the AUTO_INCREMENT value will stay at 11 until the server is s
When i do some insert or edit operations on my BDB tables i sometimes get an
error saying "table in use". After this i cannot proceed further. I only have
to shut down the server and restart it all over again. Why do i get this and
what should be done ??
