| 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(1.1); |
| 16 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type. |
| 17 |
SELECT innodb_set_open_files_limit(1e1); |
| 18 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type. |
| 19 |
SELECT innodb_set_open_files_limit('AUTO'); |
| 20 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type. |
| 21 |
SELECT innodb_set_open_files_limit(); |
| 22 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments. |
| 23 |
SELECT innodb_set_open_files_limit(1, 2); |
| 24 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments. |
| 25 |
SELECT innodb_set_open_files_limit(1, 2, 3, 4); |
| 26 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments. |
| 27 |
SELECT innodb_set_open_files_limit(NULL); |
| 28 |
ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; First argument must not be null. |
| 29 |
select @@global.innodb_open_files; |
| 30 |
@@global.innodb_open_files |
| 31 |
4000 |
| 32 |
SELECT innodb_set_open_files_limit(-3); |
| 33 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10. |
| 34 |
SELECT innodb_set_open_files_limit(1); |
| 35 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10. |
| 36 |
SELECT innodb_set_open_files_limit(3); |
| 37 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10. |
| 38 |
SELECT innodb_set_open_files_limit(9); |
| 39 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10. |
| 40 |
SELECT innodb_set_open_files_limit(2147483648); |
| 41 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be larger than 2147483647. |
| 42 |
SELECT innodb_set_open_files_limit(12342147483647); |
| 43 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be larger than 2147483647. |
| 44 |
SELECT innodb_set_open_files_limit(10); |
| 45 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15. |
| 46 |
SELECT innodb_set_open_files_limit(14); |
| 47 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15. |
| 48 |
SELECT innodb_set_open_files_limit(15); |
| 49 |
innodb_set_open_files_limit(15) |
| 50 |
15 |
| 51 |
SELECT innodb_set_open_files_limit(14); |
| 52 |
ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15. |
| 53 |
SELECT innodb_set_open_files_limit(2147483647); |
| 54 |
innodb_set_open_files_limit(2147483647) |
| 55 |
2147483647 |
| 56 |
SELECT innodb_set_open_files_limit(4000); |
| 57 |
innodb_set_open_files_limit(4000) |
| 58 |
4000 |
| 59 |
SELECT innodb_set_open_files_limit(150); |
| 60 |
innodb_set_open_files_limit(150) |
| 61 |
150 |
| 62 |
ALTER UNDO TABLESPACE undo_009 SET INACTIVE; |
| 63 |
ALTER UNDO TABLESPACE undo_008 SET INACTIVE; |
| 64 |
ALTER UNDO TABLESPACE undo_007 SET INACTIVE; |
| 65 |
ALTER UNDO TABLESPACE undo_006 SET INACTIVE; |
| 66 |
ALTER UNDO TABLESPACE undo_005 SET INACTIVE; |
| 67 |
ALTER UNDO TABLESPACE undo_004 SET INACTIVE; |
| 68 |
ALTER UNDO TABLESPACE undo_003 SET INACTIVE; |
| 69 |
ALTER UNDO TABLESPACE undo_002 SET INACTIVE; |
| 70 |
ALTER UNDO TABLESPACE undo_001 SET INACTIVE; |
| 71 |
ALTER UNDO TABLESPACE undo_000 SET INACTIVE; |
| 72 |
DROP UNDO TABLESPACE undo_009; |
| 73 |
DROP UNDO TABLESPACE undo_008; |
| 74 |
DROP UNDO TABLESPACE undo_007; |
| 75 |
DROP UNDO TABLESPACE undo_006; |
| 76 |
DROP UNDO TABLESPACE undo_005; |
| 77 |
DROP UNDO TABLESPACE undo_004; |
| 78 |
DROP UNDO TABLESPACE undo_003; |
| 79 |
DROP UNDO TABLESPACE undo_002; |
| 80 |
DROP UNDO TABLESPACE undo_001; |
| 81 |
DROP UNDO TABLESPACE undo_000; |
| 82 |
SELECT innodb_set_open_files_limit(@start_global_value); |
| 83 |
innodb_set_open_files_limit(@start_global_value) |
| 84 |
4000 |
| 85 |
SELECT @@GLOBAL.innodb_open_files; |
| 86 |
@@GLOBAL.innodb_open_files |
| 87 |
4000 |