Debian Codegraph @

mysql-test/suite/innodb/t/innodb_set_open_files_limit_concurrent.test

raw
1 --source include/have_debug_sync.inc
2
3 --enable_warnings
4 --enable_query_log
5
6 # Create some non-LRU files so there exists the limit value that can't be set.
7 let $i = 9;
8 while ($i >= 0)
9 {
10 let $sql = CREATE UNDO TABLESPACE undo_00$i ADD DATAFILE 'undo_00$i.ibu';
11 --eval $sql
12 --dec $i
13 }
14
15
16 SET @start_global_value = @@GLOBAL.innodb_open_files;
17 SELECT @start_global_value;
18
19 SELECT innodb_set_open_files_limit(150);
20
21 #
22 # Set value concurrently.
23 #
24 --connect (con1,localhost,root,,)
25 SET DEBUG_SYNC='fil_open_files_desired_limit_set SIGNAL started WAIT_FOR proceed';
26 --send SELECT innodb_set_open_files_limit(200);
27
28 --connection default
29 SET DEBUG_SYNC= 'now WAIT_FOR started';
30 --error ER_CONCURRENT_PROCEDURE_USAGE
31 SELECT innodb_set_open_files_limit(250);
32 SET DEBUG_SYNC= 'now SIGNAL proceed';
33
34 --connection con1
35 --reap
36 --disconnect con1
37 --connection default
38 SELECT @@GLOBAL.innodb_open_files;
39
40
41 #
42 # Cleanup
43 #
44 let $i = 9;
45 while ($i >= 0)
46 {
47 let $sql = ALTER UNDO TABLESPACE undo_00$i SET INACTIVE;
48 --eval $sql
49 --dec $i
50 }
51
52 let $i = 9;
53 while ($i >= 0)
54 {
55 let $inactive_undo_space = undo_00$i;
56 source include/wait_until_undo_space_is_empty.inc;
57 let $sql = DROP UNDO TABLESPACE undo_00$i;
58 --eval $sql
59
60 --dec $i
61 }
62
63 SELECT innodb_set_open_files_limit(@start_global_value);
64 SELECT @@GLOBAL.innodb_open_files;