Just to contribute our anecdotal experience, we also found a 2x increase in space required when we converted our MyISAM tables over to InnoDB. While it was surprising, it wasn't unexpected. We just had to go buy another 60GB of disk space (luckily we had planned for this). :)
Owen On Wed, 2002-11-27 at 07:26, [EMAIL PROTECTED] wrote: > Hello all, > I'm using mySQL for many databases, now I want to test innoDB so I have > created another DB (on the same machine) and I have populated it with the > same data of the first DB (via: insert into table_name select * from > db1.table_name); > > I have this tables: > tableA: 80.000 recs > tableB, tableC, tableD and tableE: 150.000 records (each) > tableF: 275.000 recs > tableG: 1.800.000 recs > > the problem is: in the myISAM tables disk usage of the DB is 376MB, with > innoDN the datafile grows to 724MB (and show table status tells there is > 37MB free) > > Anyone knows the reason of this disk usage of innoDB (it's 2 time bigger > than myISAM) > > Tommaso > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
