 TotalSizeBytes: 12582912 DATA_FREE: 6291456 MAXIMUM_SIZE: NULL 

TotalSizeBytes  shows the current size of the global temporary tablespace data file. For information about other field values, see Section 26.3.15, “The INFORMATION_SCHEMA FILES Table” . 

Alternatively, check the global temporary tablespace data file size on your operating system. The global temporary tablespace data file is located in the directory defined by the innodb_temp_data_file_path variable. 

To reclaim disk space occupied by a global temporary tablespace data file, restart the MySQL server. Restarting the server removes and recreates the global temporary tablespace data file according to the attributes defined by innodb_temp_data_file_path . 

To limit the size of the global temporary tablespace data file, configure innodb_temp_data_file_path to specify a maximum file size. For example: 

## 15.6.3.6 Moving Tablespace Files While the Server is Offline 

[mysqld] innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:500M 

Configuring innodb_temp_data_file_path  requires restarting the server. 

The innodb_directories  variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is offline. During startup, discovered tablespace files are used instead those referenced in the data dictionary, and the data dictionary is updated to reference the relocated files. If duplicate tablespace files are discovered by the scan, startup fails with an error indicating that multiple files were found for the same tablespace ID. 

The directories defined by the innodb_data_home_dir , innodb_undo_directory , and datadir variables are automatically appended to the innodb_directories  argument value. These directories are scanned at startup regardless of whether an innodb_directories  setting is specified explicitly. The implicit addition of these directories permits moving system tablespace files, the data directory, or undo tablespace files without configuring the innodb_directories  setting. However, settings must be updated when directories change. For example, after relocating the data directory, you must update the -- datadir  setting before restarting the server. 

The innodb_directories  variable can be specified in a startup command or MySQL option file. Quotes are used around the argument value because a semicolon (;) is interpreted as a special character by some command interpreters. (Unix shells treat it as a command terminator, for example.) 

Startup command: 

mysqld --innodb-directories=" directory_path_1 ; directory_path_2 " 

MySQL option file: 

[mysqld] innodb_directories=" directory_path_1 ; directory_path_2 " 

The following procedure is applicable to moving individual file-per-table and general tablespace files, system tablespace files, undo tablespace files, or the data directory. Before moving files or directories, review the usage notes that follow. 

1. Stop the server. 

2. Move the tablespace files or directories to the desired location. 

