| 1 |
CREATE UNDO TABLESPACE undo_009 ADD DATAFILE 'undo_009.ibu'; |
| 2 |
CREATE UNDO TABLESPACE undo_008 ADD DATAFILE 'undo_008.ibu'; |
| 3 |
CREATE UNDO TABLESPACE undo_007 ADD DATAFILE 'undo_007.ibu'; |
| 4 |
CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu'; |
| 5 |
CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu'; |
| 6 |
CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu'; |
| 7 |
CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu'; |
| 8 |
CREATE UNDO TABLESPACE undo_002 ADD DATAFILE 'undo_002.ibu'; |
| 9 |
CREATE UNDO TABLESPACE undo_001 ADD DATAFILE 'undo_001.ibu'; |
| 10 |
CREATE UNDO TABLESPACE undo_000 ADD DATAFILE 'undo_000.ibu'; |
| 11 |
SET @start_global_value = @@GLOBAL.innodb_open_files; |
| 12 |
SELECT @start_global_value; |
| 13 |
@start_global_value |
| 14 |
4000 |
| 15 |
SELECT innodb_set_open_files_limit(150); |
| 16 |
innodb_set_open_files_limit(150) |
| 17 |
150 |
| 18 |
SET DEBUG_SYNC='fil_open_files_desired_limit_set SIGNAL started WAIT_FOR proceed'; |
| 19 |
SELECT innodb_set_open_files_limit(200);; |
| 20 |
SET DEBUG_SYNC= 'now WAIT_FOR started'; |
| 21 |
SELECT innodb_set_open_files_limit(250); |
| 22 |
ERROR HY000: The innodb_set_open_files_limit was called when there was already another concurrent call to this procedure. No action was taken. Wait for other calls to innodb_set_open_files_limit to finish before retrying. |
| 23 |
SET DEBUG_SYNC= 'now SIGNAL proceed'; |
| 24 |
innodb_set_open_files_limit(200) |
| 25 |
200 |
| 26 |
SELECT @@GLOBAL.innodb_open_files; |
| 27 |
@@GLOBAL.innodb_open_files |
| 28 |
200 |
| 29 |
ALTER UNDO TABLESPACE undo_009 SET INACTIVE; |
| 30 |
ALTER UNDO TABLESPACE undo_008 SET INACTIVE; |
| 31 |
ALTER UNDO TABLESPACE undo_007 SET INACTIVE; |
| 32 |
ALTER UNDO TABLESPACE undo_006 SET INACTIVE; |
| 33 |
ALTER UNDO TABLESPACE undo_005 SET INACTIVE; |
| 34 |
ALTER UNDO TABLESPACE undo_004 SET INACTIVE; |
| 35 |
ALTER UNDO TABLESPACE undo_003 SET INACTIVE; |
| 36 |
ALTER UNDO TABLESPACE undo_002 SET INACTIVE; |
| 37 |
ALTER UNDO TABLESPACE undo_001 SET INACTIVE; |
| 38 |
ALTER UNDO TABLESPACE undo_000 SET INACTIVE; |
| 39 |
DROP UNDO TABLESPACE undo_009; |
| 40 |
DROP UNDO TABLESPACE undo_008; |
| 41 |
DROP UNDO TABLESPACE undo_007; |
| 42 |
DROP UNDO TABLESPACE undo_006; |
| 43 |
DROP UNDO TABLESPACE undo_005; |
| 44 |
DROP UNDO TABLESPACE undo_004; |
| 45 |
DROP UNDO TABLESPACE undo_003; |
| 46 |
DROP UNDO TABLESPACE undo_002; |
| 47 |
DROP UNDO TABLESPACE undo_001; |
| 48 |
DROP UNDO TABLESPACE undo_000; |
| 49 |
SELECT innodb_set_open_files_limit(@start_global_value); |
| 50 |
innodb_set_open_files_limit(@start_global_value) |
| 51 |
4000 |
| 52 |
SELECT @@GLOBAL.innodb_open_files; |
| 53 |
@@GLOBAL.innodb_open_files |
| 54 |
4000 |