On Wed, Nov 27, 2002 at 01:26:42PM +0100, [EMAIL PROTECTED] wrote:
>
> Anyone knows the reason of this disk usage of innoDB (it's 2 time
> bigger than myISAM)
InnoDB has larger per-record overhead (row headers and such).
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAI
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-
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, tab
