Learned this the hard way. Need to alter a table's auto-increment with 16 million rows.
Now, it's taking quite sometime.
Any estimate how long it would take? Sorry.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
It depends, could be an hour or so. Perhaps you may like to give percona toolkit a try;
pt-online-schema-change alters a table’s structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully.