Summary

In this chapter, we discussed InnoDB table compression. We discussed the situations in which this feature should be useful, and how to check whether our particular workload can benefit from it. We learned how to create a compressed table and configure InnoDB compression. Then, we discussed how to monitor the performance of the compressed tables.

While discussing these topics, we also examined some InnoDB important features: the file-per-table mode (which causes new tables to be stored into separated tablespaces) and the InnoDB file format (since only the Barracuda format allows compressing tables).

However, MariaDB provides other useful storage engines. For this reason, in the final part, we compared InnoDB compression to the compression provided by other engines.

In the next chapter, we will discuss how to create or restore a backup and, more generally, how to handle data corruption.