You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
32 lines
1.2 KiB
32 lines
1.2 KiB
#
|
|
# MyISAM does not support undo tablespaces commands
|
|
#
|
|
#
|
|
# InnoDB supports these undo tablespaces commands
|
|
#
|
|
CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu' ENGINE InnoDB;
|
|
SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
|
|
WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
|
|
NAME SPACE_TYPE STATE
|
|
innodb_undo_001 Undo active
|
|
innodb_undo_002 Undo active
|
|
undo_003 Undo active
|
|
SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE FROM INFORMATION_SCHEMA.FILES
|
|
WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
|
|
TABLESPACE_NAME FILE_NAME FILE_TYPE
|
|
innodb_undo_001 ./undo_001 UNDO LOG
|
|
innodb_undo_002 ./undo_002 UNDO LOG
|
|
undo_003 ./undo_003.ibu UNDO LOG
|
|
ALTER UNDO TABLESPACE undo_003 SET ACTIVE ENGINE InnoDB;
|
|
ALTER UNDO TABLESPACE undo_003 SET INACTIVE ENGINE InnoDB;
|
|
DROP UNDO TABLESPACE undo_003 ENGINE InnoDB;
|
|
SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
|
|
WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
|
|
NAME SPACE_TYPE STATE
|
|
innodb_undo_001 Undo active
|
|
innodb_undo_002 Undo active
|
|
SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE FROM INFORMATION_SCHEMA.FILES
|
|
WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
|
|
TABLESPACE_NAME FILE_NAME FILE_TYPE
|
|
innodb_undo_001 ./undo_001 UNDO LOG
|
|
innodb_undo_002 ./undo_002 UNDO LOG
|
|
|