MySQL creating and managing the tablespace

 

select database();
prompt d>

use dbname

dbname>
create database dbname;

use dbname;

create table t1(id int);

CREATE TABLESPACE myspace add datafile 'myspace.ibd';

create table Tt2(id int) TABLESPACE=myspace;

mkdir /datafile

chown mysql /data

CREATE TABLESPACE mysecspace add datafile '/data/mysecspace.ibd';

CREATE TABLE t3(id int) TABLESPACE=mysecspace;

CREATE TABLE t4(id int) DATA DIRECTORY='/data';

show create table t1G;

show create table t2G;

show create table t3G;

show create table t4G;