Thanks for the response. I’ll change the setting and see how it goes.
But the reason for the question is also INSERTS, not just DELETE. What some applications do is that they reply on the table locks to guarantee the auto-increment value in order to update another table with that value. Deleting a record may or may not matter, but this is only part of the question.
(Yes – I simplified the subject, but if set the subject as “Anyone know if I can set innodb_autoinc_lock_mode=2” no-one would have read it!)
Cheers – we’ll see how we go.
