MySQL Forums
Forum List  »  InnoDB

nonproportional InnoDB storage on disk
Posted by: Maxim Veksler
Date: July 06, 2008 03:12AM

Hello everyone,

I'm having a problem that might possibly suggest a bug ?


All our tables are InnoDB.
The size of storage on the disk is 27 times bigger then the textual dump of the db, I've tried running flush tables + flush logs and it doesn't help.

Could someone please suggest a solution or should I report an issue ?


Thank you,
Maxim.

[root@ML-Zeus lib]# du -sh /var/lib/mysql/
23G /var/lib/mysql/
[root@ML-Zeus lib]# mysqldump --all-databases > /tmp/mysqldump-all-databases.sql
[root@ML-Zeus lib]# du -sh /tmp/mysqldump-all-databases.sql
823M /tmp/mysqldump-all-databases.sql

Options: ReplyQuote


Subject
Views
Written By
Posted
nonproportional InnoDB storage on disk
3063
July 06, 2008 03:12AM


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.