We see sometimes at customers that they have very big InnoDB system tablespace files (ibdata1
) although they have set innodb_file_per_table = 1
.
So we want to know what else is stored in the InnoDB system tablespace file ibdata1
to see what we can do against this unexpected growth.
First let us check the size of the ibdata1
file: