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

This article is to share with you about how to set table spaces in MYSQL. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

First of all, you have to understand the changes in MYSQL. Previously, the data stored in ibdata files is mainly composed of

1 data dictionary data dictionary

2 change buffer

3 doublewrite buffer

4 undo logs

And so on, so there is a great demand for ibdata files, and it is hoped that multiple files will support the operation of MYSQL.

The current ibdata file has moved undo logs doublewrite and other files out of the ibdata file (not found officially in MYSQL 5.7. there is a default value of innodb_parallel_doublewrite_path in the percona version, which will generate a xb_doublewrite file in the data directory.

So the functionality of ibdata files has been reduced.

In addition, innodb_file_per_table must be opened, so you can no longer inject all the data into the ibdata file.

In addition, tables can be created directly in a way like tablespace, and tables can be moved in the table space. But at present, there are very few cases of doing so.

But we need to know how to deal with this problem, for example, if there are several tables in the system comparing HOT, then we have another data path mounted on the SSD disk, how to migrate part of the HOT table files to the SSD disk, we will encounter the above to establish the table space and then specify the TABLE SPACE on the SSD when building the table.

The specific operation is, see the following figure, need to pay attention to the following points

1 what is the format of the table? dynamic or compressed or compact

2 how much file_block_size do you have when setting up the table space, and whether it meets the block_size??? required by the format of the table you want

The above is how to set up the table space in MYSQL. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.