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 '#--------------------FN_DYNVARS_023_02-------------------------#'
4 CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)
5 BEGIN
6 WHILE (var1 < var2) DO
7 INSERT INTO t1 VALUES(var1,REPEAT('MYSQL',10),100000.0/var1);
8 SET var1=var1+1;
9 END WHILE;
10 END//
11 '---check when delay_key_write is OFF---'
12 SET @@global.delay_key_write = OFF;
13 CREATE TABLE t1(
14 a INT PRIMARY KEY,
15 b VARCHAR(512),
16 c DOUBLE
17 ) DELAY_KEY_WRITE = 1;
18 FLUSH GLOBAL STATUS;
19 CALL sp_addRecords(1,10);
20 SHOW STATUS LIKE 'Key_reads';
21 Variable_name Value
22 Key_reads 0
23 SHOW STATUS LIKE 'Key_writes';
24 Variable_name Value
25 Key_writes 9
26 SHOW STATUS LIKE 'Key_write_requests';
27 Variable_name Value
28 Key_write_requests 9
29 SELECT COUNT(*) FROM t1;
30 COUNT(*)
31 9
32 DROP TABLE t1;
33 '----check when delay_key_write is ON---'
34 SET @@global.delay_key_write = ON;
35 CREATE TABLE t1(
36 a INT PRIMARY KEY,
37 b VARCHAR(512),
38 c DOUBLE
39 ) DELAY_KEY_WRITE = 1;
40 FLUSH GLOBAL STATUS;
41 CALL sp_addRecords(1,10);
42 SHOW STATUS LIKE 'Key_reads';
43 Variable_name Value
44 Key_reads 0
45 SHOW STATUS LIKE 'Key_writes';
46 Variable_name Value
47 Key_writes 0
48 SHOW STATUS LIKE 'Key_write_requests';
49 Variable_name Value
50 Key_write_requests 9
51 SELECT COUNT(*) FROM t1;
52 COUNT(*)
53 9
54 DROP TABLE t1;
55 '----check when delay_key_write is ALL---'
56 SET @@global.delay_key_write = ALL;
57 CREATE TABLE t1(
58 a INT PRIMARY KEY,
59 b VARCHAR(512),
60 c DOUBLE
61 ) DELAY_KEY_WRITE = 0;
62 FLUSH GLOBAL STATUS;
63 CALL sp_addRecords(1,10);
64 SHOW STATUS LIKE 'Key_reads';
65 Variable_name Value
66 Key_reads 0
67 SHOW STATUS LIKE 'Key_writes';
68 Variable_name Value
69 Key_writes 0
70 SHOW STATUS LIKE 'Key_write_requests';
71 Variable_name Value
72 Key_write_requests 9
73 SELECT COUNT(*) FROM t1;
74 COUNT(*)
75 9
76 DROP PROCEDURE sp_addRecords;
77 DROP TABLE t1;
78 SET @@global.delay_key_write= @start_value;