Announcement

Announcement Module
Collapse
No announcement yet.

innodb_file_per_table migration

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • innodb_file_per_table migration

    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.

    Comment


    • #3
      Ok thanks Baron will do.

      Comment

      Working...
      X