How to know which sites still use idbdata?

konrath

Well-Known Member
May 3, 2005
366
0
166
Brasil
Hello

I added the line innodb_file_per_table = 1 in my.cnf so that sites do not use more idbdata

How to know which sites still use idbdata?

I imagine that restoring the backup of these sites under the new configuration in my.cnf, they will use inoodb in separate files.

I wish to delete the file idbdata consuming too much memory.

Convert idbdata in separate files seems very difficult.

Thank you
Marcelo Konrath