[MDEV-9693] fututre request: innodb_default_row_format=COMPRESSED, copy from mysql's code a new setting Created: 2016-03-07  Updated: 2016-03-07  Resolved: 2016-03-07

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Shimon Doodkin Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

i want to be abe to set that all tables will be compressed, by default. even maybe forced if possible while importing non compressed dump (without error,during import).

https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_default_row_format

another thing i want is
to see compression types used per table , maybe this already exists
but i dont know how to see it.

 Comments   
Comment by Elena Stepanova [ 2016-03-07 ]

The InnoDB option that was introduced in MySQL 5.7 will appear in MariaDB when InnoDB 5.7 and XtraDB 5.7 are merged, which is supposed to be in 10.2 (see MDEV-6113).

For compression types per table, if you mean ROW_FORMAT, you can see it in INFORMATION_SCHEMA, e. g.

select table_schema, table_name, engine, row_format from information_schema.tables;

Generated at Thu Feb 08 07:36:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.