Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
In MariaDB we do not allow the creation of ROW_FORMAT=COMPRESSED temporary tables. All temporary tables will be uncompressed. Writes to those temporary tables will be avoided: MDEV-12227, MDEV-15528.
https://mariadb.com/kb/en/innodb-temporary-tablespaces/ states "when compressed, the temporary table is written to a dedicated temporary tablespace for that table" which is wrong. That probably holds true for MySQL 5.7, but not for MariaDB.