All my table in the db are created after I enabled the option "innodb_file_per_table", so I don't understand why ibdata1 is still growing from time to time, even with a very slow speed.
Asked
Active
Viewed 3,244 times
2 Answers
2
When you use file_per_table, it doesn't mean that ibdata* isn't used at all. There will still be stored "meta-data" for all your InnoDB tables ... Only the data itself goes to the other files
![](../../users/profiles/42273.webp)
m.sr
- 1,060
- 1
- 8
- 19
1
I have the complete solution for how to clean up your innodb infrastructure permanently !!!
![](../../users/profiles/69271.webp)
RolandoMySQLDBA
- 16,364
- 3
- 47
- 80