Debian Codegraph @

mysql-test/suite/sys_vars/r/delay_key_write_func.result

raw
1 '#--------------------FN_DYNVARS_023_01-------------------------#'
2 SET @start_value= @@global.delay_key_write;
3 SET @@global.delay_key_write = ON;
4 SELECT @@global.delay_key_write;
5 @@global.delay_key_write
6 ON
7 'connect (user1,localhost,root,,,,)'
8 'connection user1'
9 SELECT @@global.delay_key_write AS res_is_ON;
10 res_is_ON
11 ON
12 SET @@global.delay_key_write = ALL;
13 'connect (user1,localhost,root,,,,)'
14 'connection user1'
15 SELECT @@global.delay_key_write AS res_is_ALL;
16 res_is_ALL
17 ALL
18 '#--------------------FN_DYNVARS_023_02-------------------------#'
19 '---check when delay_key_write is OFF---'
20 SET @@global.delay_key_write = OFF;
21 FLUSH STATUS;
22 CALL sp_addRecords(1,10);
23 SHOW STATUS LIKE 'Key_reads';
24 Variable_name Value
25 Key_reads 0
26 SHOW STATUS LIKE 'Key_writes';
27 Variable_name Value
28 Key_writes 9
29 SHOW STATUS LIKE 'Key_write_requests';
30 Variable_name Value
31 Key_write_requests 9
32 SELECT COUNT(*) FROM t1;
33 COUNT(*)
34 9
35 '----check when delay_key_write is ON---'
36 SET @@global.delay_key_write = ON;
37 FLUSH STATUS;
38 CALL sp_addRecords(1,10);
39 SHOW STATUS LIKE 'Key_reads';
40 Variable_name Value
41 Key_reads 0
42 SHOW STATUS LIKE 'Key_writes';
43 Variable_name Value
44 Key_writes 0
45 SHOW STATUS LIKE 'Key_write_requests';
46 Variable_name Value
47 Key_write_requests 9
48 SELECT COUNT(*) FROM t1;
49 COUNT(*)
50 9
51 '----check when delay_key_write is ALL---'
52 SET @@global.delay_key_write = ALL;
53 FLUSH STATUS;
54 CALL sp_addRecords(1,10);
55 SHOW STATUS LIKE 'Key_reads';
56 Variable_name Value
57 Key_reads 0
58 SHOW STATUS LIKE 'Key_writes';
59 Variable_name Value
60 Key_writes 0
61 SHOW STATUS LIKE 'Key_write_requests';
62 Variable_name Value
63 Key_write_requests 9
64 SELECT COUNT(*) FROM t1;
65 COUNT(*)
66 9
67 DROP PROCEDURE sp_addRecords;
68 DROP TABLE t1;
69 SET @@global.delay_key_write= @start_value;