###################################################
MySQL8.0 Tablespace
###################################################
----------------------------------
Common
----------------------------------
mysql CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd'
Engine=InnoDB;
Query OK, 0 rows affected (0.31 sec)
mysql CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1
ROW_FORMAT=COMPACT;
Query OK, 0 rows affected (0.46 sec)
mysql
mysql
mysql
mysql CREATE TABLESPACE `ts2` ADD DATAFILE 'ts2.ibd'
FILE_BLOCK_SIZE = 8192 Eng
ine=InnoDB;
Query OK, 0 rows affected (0.36 sec)
mysql
mysql
mysql CREATE TABLE t4 (c1 INT PRIMARY KEY) TABLESPACE ts2
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
Query OK, 0 rows affected (0.35 sec)
mysql
mysql
mysql drop tablespace ts1;
ERROR 3120 (HY000): Tablespace `ts1` is not empty.
mysql drop tablespace ts2;
ERROR 3120 (HY000): Tablespace `ts2` is not empty.
mysql
mysql DROP TABLESPACE TS2;
ERROR 3510 (HY000): Tablespace TS2 doesn't exist.
mysql
mysql
mysql drop table t4;
Query OK, 0 rows affected (0.32 sec)
mysql drop table t3;
ERROR 1051 (42S02): Unknown table 'mysql.t3'
mysql drop table t2;
ERROR 1051 (42S02): Unknown table 'mysql.t2'
mysql
mysql drop table t1;
Query OK, 0 rows affected (0.32