mysql 查看表空间
show variables like '%innodb_data_file_path%';
--创建undo日志文件组:
CREATE LOGFILE GROUP logGroup1 ADD UNDOFILE 'E:J2EEMySQLlogGroup1_1.log'
INITIAL_SIZE 512M
UNDO_BUFFER_SIZE 64M
ENGINE NDB;
-- 给日志组增加日志文件:
ALTER LOGFILE GROUP logGroup1 ADD UNDOFILE 'E:J2EEMySQLlogGroup1_2.log'
INITIAL_SIZE 512M
ENGINE NDBCLUSTER;
-- 创建表空间:
CREATE TABLESPACE tbSpace1 ADD DATAFILE 'E:J2EEMySQLtbSpace1_1.dat'
USE LOGFILE GROUP logGroup1
EXTENT_SIZE =100M
INITIAL_SIZE = 3072M
AUTOEXTEND_SIZE = 100M
-- INITIAL_SIZE 3072M
ENGINE NDBCLUSTER;
-- 给表空间增加日志文件:
ALTER TABLESPACE tbSpace1 ADD DATAFILE 'E:J2EEMySQLtbSpace1_1_2.dat'
-- EXTENT_SIZE =100M
INITIAL_SIZE = 3072M
-- AUTOEXTEND_SIZE = 100M
ENGINE NDBCLUSTER;