Bug #75040 auto_increment id reset from empty table if instance restart
Submitted: 28 Nov 2014 10:09 Modified: 28 Dec 2014 16:22
Reporter: Larry Loi Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.5 OS:Linux
Assigned to: CPU Architecture:Any
Tags: auto_increment reset, empty table, restart

[28 Nov 2014 10:09] Larry Loi 
Description:
In fact, in our busy live system, building trigger solution may drop our performance. I am wondering why the max id would save permanently even instance restart; It doesn't make sense anyway. When will the bug fix available? This what I actually want.

How to repeat:
insert and delete records from a table then restart instance.
[28 Nov 2014 16:22] MySQL Verification Team 
Please provide a test sample (create table with engine option, insert, delete) real result and expected result, please provide the complete server version 5.5.XX. Thanks.
[29 Dec 2014 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".