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

MySQL version: 5.7.18

Main contents:

What is system tablespace?

Other functions of system tablespace

Extended system tablespace

What is system tablespace?

System tablespace is the space where innodb data dictionary is stored.

Other functions of system tablespace

At the same time, system is also used as the storage area of doublewrite buffer, the change buffer and and undo log.

Extended system tablespace

3.1 View current system tablespace

Show variables like'% innodb_data_file_path%'

Note: there is a 12m tablespace file by default

3.2 expansion steps

3.2.1 turn off mysqld

3.2.2 modify innodb_data_file_path options

Innodb_data_file_path= "ibdata1:12M;ibdata2:50M:autoextend"

3.3.3 start mysqld

Or

Mysqld-datadir=/mysqldb/mysql-5.7.18/data-socket=/mysqldb/mysql-5.7.18/mysql.sock-port=3306\

-innodb_data_file_path= "ibdata1:12M;ibdata2:50M:autoextend" &

Note1: if command line has ";", it must be referenced with "".

Note2: the size of the tablespace file must refer to the original size.

Note3: datadir is specified, and the tablespace file does not need to specify a path, otherwise it is treated as the new path of the current path.

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.