innodb_file_per_table migration

MySQL & MariaDB Other MySQL® Questions
1

I plan on migrating to innodb_file_per_table
I was going to add the option restart mysql and do an alter table engine=InnoDB on all the innodb tables.

Question is after I do this the main ibdata file will still be
pretty big I think. Is there anyway to shrink this once all the
tables are migrated into their own file?

What else is stored in ibdata can I just shut the server down and delete
the file ?

This is on 4.1.22 btw.

Thanks,
William

2

You’ll still have to dump, delete, recreate, and reload. The main ibdata1 file contains the data dictionary and other stuff you need. You can’t shrink it and you can’t delete it.

3

Ok thanks Baron will do.