mysql cluster表空间创建相关命令

来源：互联网发布：网络延迟测试在线编辑：程序博客网时间：2024/06/01 09:26

1.创建日志文件组

CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 1024M UNDO_BUFFER_SIZE 128M ENGINE NDBCLUSTER;

2.创建表空间

CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 409600M ENGINE NDBCLUSTER;

3.向表空间里添加数据文件

alter tablespace ts_1 add datafile 'data_13.dat' initial_size 107374172400 engine ndbcluster;

alter tablespace ts_1 add datafile 'data_13.dat' initial_size 10G engine ndbcluster;

4.删除顺序为：表——数据文件——表空间——日志文件组

DROP TABLE dt_1;

ALTER TABLESPACE ts_1 DROP DATAFILE 'data_1.dat‘ ENGINE NDBCLUSTER;

DROP TABLESPACE ts_1 ENGINE NDBCLUSTER;

DROP LOGFILE GROUP lg_1 ENGINE NDBCLUSTER;

5.查看表空间的使用情况

SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";