Not the answer you need?
Register and ask your own question!

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

rodrigorodrigo ContributorCurrent User Role Novice
Which counter? How do you query it? Does an entire restore fix this problem?

Thanks.

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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.
  • rodrigorodrigo Contributor Current User Role Novice
    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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.