An Application of MySQL to compress tables

An Application of MySQL to compress tables

1. Set server Parameters
Innodb_file_per_table = ON
Innodb_file_format = Barracuda

2. Create or modify table parameters
Alter table sod_song_log_2014_10_12 row_format = compressed key_block_size = 8;

The business system has a lot of log data, which can be processed offline for more than half a year, but cannot be deleted (the boss said it will do Data Mining in the future)
At this time, you can start an instance separately. As a centralized log server, all tables use compressed tables.
In this way, you can use data mining and reduce disk space usage.

Compressing previous log data

After compression,

We can see that the occupied space is reduced from 3.2gb to 1.2G. the effect is very obvious.

This article permanently updates link: http://www.bkjia.com/Linux/2015-06/118363tm