Shulou(Shulou.com)05/31 Report--

MySQL 5.6tables how to compress, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Set the compression of the mysql innodb table:

First, the version of mysql needs to be greater than 5.5

Second, set up innodb_file_format=barracuda

Third, create table or alter talble adds ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; (default key_block_size=16)

MySQL 5.6Page Compression Command:

Use testdb

ALTER TABLE tab_new ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8

Data table size before compression:

Compressed data table size:

The compression ratio can reach 70%. If the table structure and table data storage are different, the compression ratio will be different.

Generally speaking, the compression ratio can reach 50%.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.