How to Set a Default Level for InnoDB Table Compression?

In this sql tutorial we'll walk you through how can you set a default level for sql tables running the InnoDB storage engine in MariaDB Server. This mariadb tutorial is only applicable for servers running MariaDB 10 and above.

To set the default level for InnoDB table compression, adjust the innodb_compression_level variable. Valid values for this variable include numbers from 1 to 9, and the default value for this mariadb variable is 6. Level 1 is the fastest level of InnoDB table compression, while level 9 is the most compact one.

--innodb-compression-level=[0-9]

Make sure to experiment with this MariaDB variable when tuning your SQL database instances!

Music:
Creative Commons — Attribution 3.0 Unported — CC BY 3.0

#shorts #database #sql #mariadb #mysql #developer #web