MySQL 8 Cookbook

Create a general tablespace

You can create a general tablespace either in the MySQL data directory or outside it.

To create one in a MySQL data directory:

mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB;Query OK, 0 rows affected (0.02 sec)

To create the tablespace outside it, mount the new disk on /var/lib/mysql_general_ts and change the ownership to mysql:

shell> sudo chown mysql:mysql /var/lib/mysql_general_tsmysql> CREATE TABLESPACE `ts2` ADD DATAFILE '/var/lib/mysql_general_ts/ts2.ibd' Engine=InnoDB;Query OK, 0 rows affected (0.02 sec)