1
'#--------------------FN_DYNVARS_023_01-------------------------#'
2
SET @@global.delay_key_write = ON;
3
SELECT @@global.delay_key_write;
4
@@global.delay_key_write
6
'connect (user1,localhost,root,,,,)'
8
SELECT @@global.delay_key_write AS res_is_ON;
11
SET @@global.delay_key_write = ALL;
12
'connect (user1,localhost,root,,,,)'
14
SELECT @@global.delay_key_write AS res_is_ALL;
17
'#--------------------FN_DYNVARS_023_02-------------------------#'
18
'---check when delay_key_write is OFF---'
19
SET @@global.delay_key_write = OFF;
21
CALL sp_addRecords(1,10);
22
SHOW STATUS LIKE 'Key_reads';
25
SHOW STATUS LIKE 'Key_writes';
28
SHOW STATUS LIKE 'Key_write_requests';
31
select count(*) from t1;
34
'----check when delay_key_write is ON---'
35
SET @@global.delay_key_write = ON;
37
CALL sp_addRecords(1,10);
38
SHOW STATUS LIKE 'Key_reads';
41
SHOW STATUS LIKE 'Key_writes';
44
SHOW STATUS LIKE 'Key_write_requests';
47
select count(*) from t1;
50
'----check when delay_key_write is ALL---'
51
SET @@global.delay_key_write = ALL;
53
CALL sp_addRecords(1,10);
54
SHOW STATUS LIKE 'Key_reads';
57
SHOW STATUS LIKE 'Key_writes';
60
SHOW STATUS LIKE 'Key_write_requests';
63
select count(*) from t1;
66
DROP PROCEDURE sp_addRecords;