Debian Codegraph @

mysql-test/suite/innodb/r/innodb_set_open_files_limit_concurrent.result

raw
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