[MDEV-27856] ROW_FORMAT=COMPRESSED temporary tables documentation error Created: 2022-02-16  Updated: 2022-02-16  Resolved: 2022-02-16

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ian Gilfillan Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

From https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/innodb_data_home_dir/near/269694298

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.


Generated at Thu Feb 08 09:56:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.