Is there a way to stop increasing the auto increment value in mysql when running specs?
<p>I have about 100 specs, In a Sinatra project I'm currently developing.
For testing I'm currently using rspec + DatabaseCleaner with the :transaction strategy.</p>

<p>Some of those specs require creating new records in the database and thus they increase the auto increment table value in mysql. Is there a way I can run my tests with the transaction strategy, without increasing the auto increment value using DatabaseCleaner or another gem?</p>

<p>Edit: I would like for auto_increment to have the value it had before the tests ran.</p>