MySQL Forums
Forum List  »  MyISAM

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

Hi,

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


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


Sorry, only registered users may post in this forum.

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.