Do InnoDb tables suffer from internal table fragmentation. (Is there any way to measure it?) I only mention this because of a problem I have with another database system (not MySQL). Some of its tables are hopelessly fragmented (800,000 file fragments for one table alone! Did I set a new record here?<g>). Since InnoDb creates its own file space, it is immune from OS fragmentation which is great (provided I defrag the drive before allocating InnoDb space), but what about internal fragmentation. If I continuously add/delete small temporary Innodb tables/rows, then add more rows to a table, delete rows etc., the table rows are no longer going to be contiguous. So how do I "defrag" the InnoDb file space so I can get it back up to speed? The only way I can think of is to unload all the databases and then reload then back in which can take a bit of time. Am I worried about nothing? Or should this type of maintenance be done on a regular basis? TIA
I'm using Win2k with NTFS volumes.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
