Published by exdone
Posted on February 07, 2008
MyISAM tables (the default table type in MySQL) become fragmented
when you delete records (this can even happen when you update records,
if your table format is dynamic). You cannot avoid this effect if
you’re using MyISAM tables.
If you don’t optimize fragmented MyISAM tables, they will become slow
to scan because the operating system will need more time for disk