We are running OPTIMIZE TABLE , but not seeing any fragmentation reduction. They are as high as 120% to 200%.
Am calculating the fragmentation % using this: Data_Free / (Data_Length + Index_Length)
My tables are using INNODB engine and "innodb_file_per_table" set to 1.
What am I missing?
Has something change with Mysql 5.5+ onwards?