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 ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
