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
Subject
Views
Written By
Posted
Optimize Table not fixing Blocks/Record
1123
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.