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
Subject
Views
Written By
Posted
Size of ibdata1 bigger than content
5298
June 06, 2005 10:01AM
2579
July 14, 2005 05:22AM
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.