InnoDB: Warning: you are running out of new single-table tablespace id's.

Which counter? How do you query it? Does an entire restore fix this problem?



It seems, you have created/drop tables like crazy :slight_smile: Above warning is related to table id. When you create one table in innodb, that counter will be increased by 1. So now you can imagine how many tables you have created. (Approx. 70 per second for a year). So the solution is already mentioned in warning. You don’t only need to backup/restore but also need to re-install innodb (or MySQL) to reset that counter.

Maybe it wasn’t great idea to have innodb as default engine for temporary tables…
Thansks niljoshi for your answer. Would you know of any official documentation about this?