mysql表空间查看及创建

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;  
上一篇:Docker必备基础知识


下一篇:ES数据库创建索引