MySQL 5.7版本的6种Tablespace.docx

5.7拥有的6种Tablespacessystem tablespaceThe InnoDB system tablespace contains the InnoDB data dictionary (metadata for InnoDB-relatedobjects) and is the storage area for the doublewrite buffer, the change buffer, and undo logs. Thesystem tablespace also contains table and index data for any user-created tables that are created in the system tablespace. The system tablespace is considered a shared tablespace since it is shared by multiple tables. The system tablespace is represented by one or more data files. By default, one system data file,named ibdata1, is created in the MySQL data directory. The size and number of system data files is controlled by the innodb_data_file_path startup option.增大系统表空间The easiest way to increase the size of the InnoDB system tablespace is to configure it fromthe beginning to be auto-extending. Specify the autoextend attribute for the last data file inthe tablespace definition. Then InnoDB increases the size of that file automatically in 64MBincrements when it runs out of space. The increment size can be changed by setting the value of the innodb_autoextend_increment system variable, which is measured in megabytesYou can expand the system tablespace by a defined amount by adding another data file:Shut down the MySQL server.If the previous last data file is defined with the keyword autoextend, change its definition to use a fixed size, based on how large it has actually grown. Check the size of the data file, round it down to the closest multiple of 1024 × 1024 bytes (= 1MB), and specify this rounded size explicitly in innodb_data_file_path.Add a new data file to the end of innodb_data_file_path, optionally making that file autoextending.Only the last data file in the innodb_data_file_path can be specified as autoextending.Start the MySQL server again.For example, this tablespace has just one auto-extending data file ibdata1:innodb_data_home_dir =innodb_data_file_path = /ibdata/ibdata1:10M:autoextendSuppose that this data file, over time, ha