Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Compression mode of Innodb table

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Innodb currently supports two file formats (innodb_file_format) Antelope and Barracuda

The default is Antelope (antelope), and there are two "data table formats" (row_format): Redundant (redundant) and Compact (compact)

5.7The default is that Barracuda (Barracuda) adds support for two data table formats: Dynamic and Compressed

1. How to set the compression of mysql innodb table

Set compression for innodb tables

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

Second, set up innodb_file_format=barracuda

Innodb_file_format=barracuda

Innodb_file_per_table = 1

Innodb_strict_mode=1 # suggest adding

Innodb_default_row_format = COMPRESSED # is set when row compression format is enabled by default for the entire library without changing this value

Third, create table or alter talble add ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8

Given that the maximum row size of the InnoDB table is about 8K, usually a safe choice.

In the buffer pool, compressed data is saved in small pages based on the KEY_BLOCK_SIZE value

KEY_BLOCK_SIZE defaults to half of the innodb_page_ size value, which is 8k

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report