# InnoDB: Warning: you are running out of new single-table tablespace id's. **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [February 24, 2015, 7:04am UTC](https://forums.percona.com/t/innodb-warning-you-are-running-out-of-new-single-table-tablespace-ids/4072 "2015-02-24T07:04:34Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@rodrigo](https://forums.percona.com/u/rodrigo)\ **Post date:** [February 24, 2015, 7:04am UTC](https://forums.percona.com/t/innodb-warning-you-are-running-out-of-new-single-table-tablespace-ids/4072/1 "2015-02-24T07:04:34Z")
Which counter? How do you query it? Does an entire restore fix this problem? Thanks. ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [March 2, 2015, 1:25am UTC](https://forums.percona.com/t/innodb-warning-you-are-running-out-of-new-single-table-tablespace-ids/4072/2 "2015-03-02T01:25:19Z")
Hi, It seems, you have created/drop tables like crazy 🙂 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. ---
**Author:** ![rodrigo](https://avatars.discourse-cdn.com/v4/letter/r/4af34b/32.png) [@rodrigo](https://forums.percona.com/u/rodrigo)\ **Post date:** [March 11, 2015, 6:57am UTC](https://forums.percona.com/t/innodb-warning-you-are-running-out-of-new-single-table-tablespace-ids/4072/3 "2015-03-11T06:57:12Z")
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?