Mysql overhead

Published by

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
operations.

Categories: MySQL