Tablespaces • INNODB_FT_CONFIG • INNODB_FT_INDEX_TABLE • INNODB_FT_INDEX_CACHE • INNODB_FT_DEFAULT_STOPWORD • INNODB_FT_DELETED • INNODB_FT_BEING_DELETED You can also view basic information for full-text indexes and tables by querying  INNODB_INDEXES  and INNODB_TABLES . For more information, see Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables” . This section covers topics related to  InnoDB  tablespaces. The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. In previous MySQL versions, the system tablespace contained the  InnoDB  data dictionary. In MySQL 8.0,  InnoDB stores metadata in the MySQL data dictionary. See Chapter 14,  MySQL Data Dictionary . In previous MySQL releases, the system tablespace also contained the doublewrite buffer storage area. This storage area resides in separate doublewrite files as of MySQL 8.0.20. See Section 15.6.4, “Doublewrite Buffer” . The system tablespace can have one or more data files. By default, a single system tablespace data file, named  ibdata1 , is created in the data directory. The size and number of system tablespace data files is defined by the  innodb_data_file_path  startup option. For configuration information, see System Tablespace Data File Configuration. Additional information about the system tablespace is provided under the following topics in the section: •Resizing the System Tablespace •Using Raw Disk Partitions for the System Tablespace Resizing the System Tablespace Increasing the Size of the System Tablespace 15.6.3.1 The System Tablespace 15.6.3 Tablespaces This section describes how to increase or decrease the size of the system tablespace. The easiest way to increase the size of the system tablespace is to configure it to be auto-extending. To do so, specify the  autoextend  attribute for the last data file in the  innodb_data_file_path  setting, and restart the server. For example: When the  autoextend  attribute is specified, the data file automatically increases in size by 8MB increments as space is required. The  innodb_autoextend_increment  variable controls the increment size. innodb_data_file_path=ibdata1:10M:autoextend 3049