Debian Codegraph @

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

raw
1 let flush_hwm=`SELECT @@GLOBAL.innodb_log_wait_for_flush_spin_hwm`;
2 let cpu_lwm=`SELECT @@GLOBAL.innodb_log_spin_cpu_abs_lwm`;
3 let cpu_hwm=`SELECT @@GLOBAL.innodb_log_spin_cpu_pct_hwm`;
4
5 --echo '#-----------------------------------------------------------#'
6 --echo 'Test what happens when the innodb_log_wait_for_flush_spin_hwm is changed'
7 --echo ' in runtime (both decreased and increased).'
8
9 --disable_query_log
10 CREATE TABLE t (a INT NOT NULL PRIMARY KEY, b BLOB);
11 DELIMITER |;
12
13 CREATE PROCEDURE insert_rows()
14 BEGIN
15 DECLARE i INT DEFAULT 0;
16 DECLARE no INT DEFAULT 0;
17 SET no = (SELECT @conn_counter);
18 WHILE i < 100 DO
19 INSERT INTO t VALUES (no*100+i, REPEAT('.', 5000));
20 SET i = i + 1;
21 END WHILE;
22 END|
23
24 DELIMITER ;|
25 --enable_query_log
26
27 INSERT INTO t VALUES (1000, 'a');
28 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 100;
29 SELECT @@innodb_log_wait_for_flush_spin_hwm;
30 INSERT INTO t VALUES (2000, 'b');
31 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
32 SELECT @@innodb_log_wait_for_flush_spin_hwm;
33 INSERT INTO t VALUES (3000, 'c');
34 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 80;
35 SELECT @@innodb_log_wait_for_flush_spin_hwm;
36 INSERT INTO t VALUES (4000, 'd');
37
38 let $n = 9;
39 let $i = 0;
40 while ($n) {
41 connect(con$n, localhost, root,,);
42 eval SET @conn_counter = $n;
43 send CALL insert_rows();
44 inc $i;
45 dec $n;
46 }
47
48 let $n = 9;
49 let $i = 0;
50 while ($n) {
51 --connection con$n
52 --reap
53 --disconnect con$n
54 inc $i;
55 dec $n;
56 }
57
58 --connection default
59
60 --echo Enable spinning always
61
62 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 100;
63 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
64 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 100000;
65
66 SELECT @@innodb_log_wait_for_flush_spin_hwm;
67 SELECT @@innodb_log_spin_cpu_abs_lwm;
68 SELECT @@innodb_log_spin_cpu_pct_hwm;
69
70 --echo Modifying innodb_log_wait_for_flush_spin_hwm
71
72 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
73 SELECT @@innodb_log_wait_for_flush_spin_hwm;
74 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 50;
75 SELECT @@innodb_log_wait_for_flush_spin_hwm;
76 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 1000;
77 SELECT @@innodb_log_wait_for_flush_spin_hwm;
78 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 50;
79 SELECT @@innodb_log_wait_for_flush_spin_hwm;
80 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
81 SELECT @@innodb_log_wait_for_flush_spin_hwm;
82
83 --echo Modifying innodb_log_spin_cpu_abs_lwm
84
85 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
86 SELECT @@innodb_log_spin_cpu_abs_lwm;
87 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 50;
88 SELECT @@innodb_log_spin_cpu_abs_lwm;
89 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 100;
90 SELECT @@innodb_log_spin_cpu_abs_lwm;
91 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 50;
92 SELECT @@innodb_log_spin_cpu_abs_lwm;
93 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
94 SELECT @@innodb_log_spin_cpu_abs_lwm;
95
96 --echo Modifying innodb_log_spin_cpu_pct_hwm
97
98 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 0;
99 SELECT @@innodb_log_spin_cpu_pct_hwm;
100 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 5;
101 SELECT @@innodb_log_spin_cpu_pct_hwm;
102 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 100;
103 SELECT @@innodb_log_spin_cpu_pct_hwm;
104 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 5;
105 SELECT @@innodb_log_spin_cpu_pct_hwm;
106 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 0;
107 SELECT @@innodb_log_spin_cpu_pct_hwm;
108
109 --disable_query_log
110 DROP TABLE t;
111 DROP PROCEDURE insert_rows;
112 --enable_query_log
113
114 eval SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=$cpu_lwm;
115 eval SET @@GLOBAL.innodb_log_spin_cpu_pct_hwm=$cpu_hwm;
116 eval SET @@GLOBAL.innodb_log_wait_for_flush_spin_hwm=$flush_hwm;
117
118 SELECT @@innodb_log_wait_for_flush_spin_hwm;
119 SELECT @@innodb_log_spin_cpu_abs_lwm;
120 SELECT @@innodb_log_spin_cpu_pct_hwm;