Debian Codegraph @

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

raw
1 '#-----------------------------------------------------------#'
2 'Test what happens when the innodb_log_wait_for_flush_spin_hwm is changed'
3 ' in runtime (both decreased and increased).'
4 INSERT INTO t VALUES (1000, 'a');
5 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 100;
6 SELECT @@innodb_log_wait_for_flush_spin_hwm;
7 @@innodb_log_wait_for_flush_spin_hwm
8 100
9 INSERT INTO t VALUES (2000, 'b');
10 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
11 SELECT @@innodb_log_wait_for_flush_spin_hwm;
12 @@innodb_log_wait_for_flush_spin_hwm
13 0
14 INSERT INTO t VALUES (3000, 'c');
15 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 80;
16 SELECT @@innodb_log_wait_for_flush_spin_hwm;
17 @@innodb_log_wait_for_flush_spin_hwm
18 80
19 INSERT INTO t VALUES (4000, 'd');
20 SET @conn_counter = 9;
21 CALL insert_rows();
22 SET @conn_counter = 8;
23 CALL insert_rows();
24 SET @conn_counter = 7;
25 CALL insert_rows();
26 SET @conn_counter = 6;
27 CALL insert_rows();
28 SET @conn_counter = 5;
29 CALL insert_rows();
30 SET @conn_counter = 4;
31 CALL insert_rows();
32 SET @conn_counter = 3;
33 CALL insert_rows();
34 SET @conn_counter = 2;
35 CALL insert_rows();
36 SET @conn_counter = 1;
37 CALL insert_rows();
38 Enable spinning always
39 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 100;
40 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
41 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 100000;
42 SELECT @@innodb_log_wait_for_flush_spin_hwm;
43 @@innodb_log_wait_for_flush_spin_hwm
44 100000
45 SELECT @@innodb_log_spin_cpu_abs_lwm;
46 @@innodb_log_spin_cpu_abs_lwm
47 0
48 SELECT @@innodb_log_spin_cpu_pct_hwm;
49 @@innodb_log_spin_cpu_pct_hwm
50 100
51 Modifying innodb_log_wait_for_flush_spin_hwm
52 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
53 SELECT @@innodb_log_wait_for_flush_spin_hwm;
54 @@innodb_log_wait_for_flush_spin_hwm
55 0
56 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 50;
57 SELECT @@innodb_log_wait_for_flush_spin_hwm;
58 @@innodb_log_wait_for_flush_spin_hwm
59 50
60 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 1000;
61 SELECT @@innodb_log_wait_for_flush_spin_hwm;
62 @@innodb_log_wait_for_flush_spin_hwm
63 1000
64 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 50;
65 SELECT @@innodb_log_wait_for_flush_spin_hwm;
66 @@innodb_log_wait_for_flush_spin_hwm
67 50
68 SET GLOBAL innodb_log_wait_for_flush_spin_hwm = 0;
69 SELECT @@innodb_log_wait_for_flush_spin_hwm;
70 @@innodb_log_wait_for_flush_spin_hwm
71 0
72 Modifying innodb_log_spin_cpu_abs_lwm
73 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
74 SELECT @@innodb_log_spin_cpu_abs_lwm;
75 @@innodb_log_spin_cpu_abs_lwm
76 0
77 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 50;
78 SELECT @@innodb_log_spin_cpu_abs_lwm;
79 @@innodb_log_spin_cpu_abs_lwm
80 50
81 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 100;
82 SELECT @@innodb_log_spin_cpu_abs_lwm;
83 @@innodb_log_spin_cpu_abs_lwm
84 100
85 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 50;
86 SELECT @@innodb_log_spin_cpu_abs_lwm;
87 @@innodb_log_spin_cpu_abs_lwm
88 50
89 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
90 SELECT @@innodb_log_spin_cpu_abs_lwm;
91 @@innodb_log_spin_cpu_abs_lwm
92 0
93 Modifying innodb_log_spin_cpu_pct_hwm
94 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 0;
95 SELECT @@innodb_log_spin_cpu_pct_hwm;
96 @@innodb_log_spin_cpu_pct_hwm
97 0
98 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 5;
99 SELECT @@innodb_log_spin_cpu_pct_hwm;
100 @@innodb_log_spin_cpu_pct_hwm
101 5
102 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 100;
103 SELECT @@innodb_log_spin_cpu_pct_hwm;
104 @@innodb_log_spin_cpu_pct_hwm
105 100
106 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 5;
107 SELECT @@innodb_log_spin_cpu_pct_hwm;
108 @@innodb_log_spin_cpu_pct_hwm
109 5
110 SET GLOBAL innodb_log_spin_cpu_pct_hwm = 0;
111 SELECT @@innodb_log_spin_cpu_pct_hwm;
112 @@innodb_log_spin_cpu_pct_hwm
113 0
114 SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=80;
115 SET @@GLOBAL.innodb_log_spin_cpu_pct_hwm=50;
116 SET @@GLOBAL.innodb_log_wait_for_flush_spin_hwm=400;
117 SELECT @@innodb_log_wait_for_flush_spin_hwm;
118 @@innodb_log_wait_for_flush_spin_hwm
119 400
120 SELECT @@innodb_log_spin_cpu_abs_lwm;
121 @@innodb_log_spin_cpu_abs_lwm
122 80
123 SELECT @@innodb_log_spin_cpu_pct_hwm;
124 @@innodb_log_spin_cpu_pct_hwm
125 50