MySQL Forums
Forum List  »  MyISAM

Optimize Table not fixing Blocks/Record
Posted by: Jim Staff
Date: November 30, 2018 12:25PM


It seems as though our MyISAM tables are becoming "fragmented". When we run myisamchk -eis TABLE, some tables show that the Blocks/Record value is > 1 (8, 30, and larger). Running OPTIMIZE TABLE has no effect on that value. Besides dumping the table and reading it back in (which we've done), how can the table be defragmented? We were using 5.6 with a weekly OPTIMIZE on all tables and never had a problem. Recently we migrated to 8.0 and are seeing problems with performance.

Thank you

Options: ReplyQuote

Written By
Optimize Table not fixing Blocks/Record
November 30, 2018 12:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.