MySQL Forums
Forum List  »  MyISAM

Re: Almost whole table in single index: is there a better way?
Posted by: Aftab Khan
Date: August 27, 2012 10:53AM

>I did some benchmarks using InnoDB, and found that the database file was substantially larger (more than double) than the MyISAM.

This is expected as InnoDB footprints are 2x-3x of MyISAM.

>I also had concerns about disk space not being freed up when the old data/partitions are pruned with InnoDB.
It won't be an issue if you use innodb_file_per_table=1. With multiple tablespaces enabled (i.e.innodb_file_per_table=1), InnoDB stores each newly created table into its own tbl_name.ibd file in the database directory where the table belongs. The innodb_file_per_table option affects only table creation, not access to existing tables.

How much RAM do you have on the server?
Can we see MySQL options file i.e. /etc/my.cnf?

Options: ReplyQuote

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.