In the last episode (Jun 15), Ben Clewett said:
> > Are there any reasons why one would NOT use separate ibd files for
> > each table
>
> Fragmentation for one.
>
> A single file can re-use empty space from deleted rows for any added
> rows. A single file can only re-use space from that one file.
>
> Therefore the sum table size will be larger with many files.
> Depending on how much data you regularly delete.
I would claim that the file-per-table method reduces fragmentation and
overall tablepsace size as compared to the tablespace method:
OPTIMIZE'ing a file-per-table table recreates that .ibd file and
removes all the empty space. To do that with the single tablespace
setup, you would have to dump all tables, delete your tablespace file,
and reload.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
