In the last episode (Apr 18), tech user said: > My mysql table has been created for long time, it increases day by > day, and become huge. Right now a full scan to the table for the > first time is very slow. So I was thinking to optimize it. This table > is stored in many non-sequential disk fragments I think. I want to > make this table to be stored in disk with the sequential > fragments.That will increase the scan speed. Is there any tool to do > it? Thanks in advance.
If you are solely concerned with filesystem fragmentation, shut MySQL down, copy your .MYI and .MYD (or .ibd if you're using innodb file-per-table) files to a temporary directory, delete the originals, and move your new files into their place. Or if you're running Windows, simply run its disk defragmenter :) If you have deleted/inserted many rows in your table and are using a variable-length table (pretty much any table with VARCHARs), then you may also have internal table fragmentation. The OPTIMIZE TABLE command will compact your file by copying the row data to a new temporary table, rebuilding the indexes, and deleting the original table. http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
