MySQL Forums
Forum List  »  InnoDB

Size of ibdata1 bigger than content
Posted by: l.monsees
Date: June 06, 2005 10:01AM

Hello,

we have a InnoDB that only contains one DB (called asm). The file ibdata1 has been ~600mb big. The dump that I created was about 100mb big. Then I dropped the asm-DB, stopped the server and manually deleted the InnoDB files.

After I had imported the dump, the file ibdata1 was 210mb big.

I guess this behaviour (ibdata1 bigger than content) is normal?
How can I compress the DB from time to time (without dumping data, dropping DB and reimporting)?

mysql-max 4.1.12 on linux


Lars

Options: ReplyQuote


Subject
Views
Written By
Posted
Size of ibdata1 bigger than content
5257
June 06, 2005 10:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.