My tables have been created with InnoDB row compression (
ENGINE=InnoDB ROW_FORMAT=COMPRESSED). Now I am changing them to page compression. According to the official documentation of MariaDB, enabling page compression affects newly created tables only.
Thus, I create a replica table and use
INSERT INTO SELECT.
I wonder if it is possible to
ALTER a table to change the compression type (from row to page) ?
ALTER an ordinary table to use page compression using
ALTER TABLE t1 PAGE_COMPRESSED=1;
My question is about a safe way to remove
ROW_FORMAT=COMPRESSED and add