Gauravk Posted April 1, 2020 Share Posted April 1, 2020 I have defrag MyISAM (Majority) and InnoDB (Minority) tables in MySQL multiple times today. Dropped from 70+ to 11 (lowest) and then climb back to 30-40 in an hour or two time. How to constantly defrag tables or identify what is causing the defrag? Link to comment Share on other sites More sharing options...
ASTRAPI Posted April 1, 2020 Share Posted April 1, 2020 Hello The best thing that you can do is to convert all tables to Innodb . You will benefit a lot. Gauravk 1 Link to comment Share on other sites More sharing options...
Recommended Posts