Has anyone used/experimented with InnoDB page compression with Zabbix?
innodb_file_format: https://mariadb.com/kb/en/innodb-sys...db_file_format
Markku
Enabling InnoDB Page Compression
InnoDB page compression is not enabled by default. However, InnoDB page compression can be enabled for just individual InnoDB tables or it can be enabled for all new InnoDB tables by default.
InnoDB page compression is also only supported if the InnoDB table is in a file per-table tablespace. Therefore, the innodb_file_per_table system variable must be set to ON to use InnoDB page compression.
InnoDB page compression is only supported if the InnoDB table uses the Barracuda file format.Therefore, in MariaDB 10.1 and before, the innodb_file_format system variable must be set to Barracuda to use InnoDB page compression.
InnoDB page compression is also only supported if the InnoDB table's row format is COMPACT or DYNAMIC.
InnoDB page compression is not enabled by default. However, InnoDB page compression can be enabled for just individual InnoDB tables or it can be enabled for all new InnoDB tables by default.
InnoDB page compression is also only supported if the InnoDB table is in a file per-table tablespace. Therefore, the innodb_file_per_table system variable must be set to ON to use InnoDB page compression.
InnoDB page compression is only supported if the InnoDB table uses the Barracuda file format.Therefore, in MariaDB 10.1 and before, the innodb_file_format system variable must be set to Barracuda to use InnoDB page compression.
InnoDB page compression is also only supported if the InnoDB table's row format is COMPACT or DYNAMIC.
- Default Value:
- Barracuda (>= MariaDB 10.2.2)
- Antelope (<= MariaDB 10.2.1)
- Valid Values: Antelope, Barracuda
- Deprecated: MariaDB 10.2
- Removed: MariaDB 10.3.1
- Re-introduced: MariaDB 10.4.3 (for compatibility purposes)
- Removed: MariaDB 10.6.0