On Sun, August 5, 2007 1:04 pm, Tony Earnshaw wrote: > To my mind, InnoDB should be the standard for MySQL. However, the > (only that I know of) downside is, that one'll never reclaim DB > space as one can with MyISAM tables, even by reconverting tables > to MyISAM or dropping a database and recreating it.
That's partially because MySQL stores all of the InnoDB data in a single file by default. You can get around that and have it create a new file for every table like MyISAM, by specifying innodb_file_per_table in /etc/my.cnf under the mysqld section: [mysqld] innodb_file_per_table I started doing that after I had a drive failure on a smaller system (just one drive) which corrupted the InnoDB file and then gave me problems across several tables. I like to contain damage - and it's nice to be able to reclaim the space for a dropped table. :) --Danny
