You’ve probably had some troubles with the shared InnoDB tablespace stored in the ibdata file. Especially when it has grown for some reasons and reached a critical size.
This behavior occurs in some cases, due to excessive rollback segments growth or during a migration from a unique shared tablespace to a file-per-table configuration for example.
In this post, I would like to explain how to shrink the ibdata
file after an unwanted file growth in a file-per-table
Note that the process could be done without Trite but the tool avoids to write the script used to transport tables yourself.
Initial situation… [Read more...]