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.