OPTIMIZE TABLEhardly freed up any pages and to defragment you had to do a rolling restart of the data nodes.
Now, there is only a 2% discrepancy between
OPTIMIZE TABLEand doing a rolling restart. This is great stuff.
This will fix will make it into 6.3.26 and 7.0.7.
See below for details:
Creating two tables, t5 and t6:
CREATE TABLE `t5` (
`id` varchar(32) CHARACTER SET utf8 NOT NULL,