Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Reduce InnoDB Table Space

SpeepleSpeeple ContributorInactive User Role Beginner
I recently changed to a per-table file for InnoDB.

The problem now is I'm left over with a 70Gb old table space file which used to singularly hold the entire database.

Is there a way of reducing the size without harming the data?

I've tried moving the log files and old table space so that MySQL recreates them, but then the individual tables are lost via this process so I must revert to the old files.

I guess a full backup and re-insert will rectify the problem but that's a process that takes more time than I want.

Cheers!

Comments

  • erkuleserkules Contributor Inactive User Role Beginner
    With innodb_file_per_table you still need the tablespace!
    http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces. html:
    #v+
    Note

    InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there. The .ibd files are not sufficient for InnoDB to operate.

    #v-

    You cant reduce the tablespace. Go for dumping and reinstalling:-)
  • SpeepleSpeeple Contributor Inactive User Role Beginner
    I understand the central table space needs to exist, but being 75Gb means it contains all of the old data which is now in separate files.

    I did do a backup etc. now the default table space is 50Mb.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.