Tag Info

New answers tagged


Stop MySQL server; Check the error log see verify if your shutdown was successful. (No errors) Move your log files: mv /path/to/datadir/ib_logfile* /tmp/ Start MySQL server. This will create new logs; When you’re absolutely sure that MySQL server has started successfully, you can remove the old log files: rm /tmp/ib_logfile* Possible roll back would be to ...


This results in unused sequence values That's totally normal, and by design. It's also not the only way you can get such gaps. See the note on nextval in the manual. Is there any way to reclaim the lost sequence values No. or prevent the failed function from incrementing the sequence? Don't use a SEQUENCE. Instead, if you must have gapless ...

Top 50 recent answers are included