1DROP TABLE IF EXISTS t1;
2## Creating new table t1 ##
3CREATE TABLE t1
4(
5id INT NOT NULL AUTO_INCREMENT,
6PRIMARY KEY (id),
7rollno INT NOT NULL,
8name VARCHAR(30)
9);
10SET @start_value= @@global.key_buffer_size;
11FLUSH STATUS;
12'#--------------------FN_DYNVARS_055_01-------------------------#'
13## Setting initial value of variable to 131072 ##
14SET @@global.key_buffer_size = 131072;
15CONNECT  test_con1,localhost,root,,;
16CONNECT  test_con2,localhost,root,,;
17'#--------------------FN_DYNVARS_055_02-------------------------#'
18connection test_con1;
19SELECT @@global.key_buffer_size;
20@@global.key_buffer_size
21131072
22## Inserting some rows in table ##
23INSERT INTO t1(rollno, name) VALUES(1, 'Record_1');
24INSERT INTO t1(rollno, name) VALUES(2, 'Record_2');
25INSERT INTO t1(rollno, name) VALUES(1, 'Record_3');
26INSERT INTO t1(rollno, name) VALUES(3, 'Record_4');
27INSERT INTO t1(rollno, name) VALUES(1, 'Record_5');
28INSERT INTO t1(rollno, name) VALUES(3, 'Record_6');
29INSERT INTO t1(rollno, name) VALUES(4, 'Record_7');
30INSERT INTO t1(rollno, name) VALUES(4, 'Record_8');
31INSERT INTO t1(rollno, name) VALUES(4, 'Record_9');
32INSERT INTO t1(rollno, name) VALUES(4, 'Record_10');
33## Key_reads must be zero (no disk access) ##
34show status like 'Key_reads';
35Variable_name	Value
36Key_reads	0
37connection test_con2;
38## Key_reads must be zero (no disk access) ##
39show status like 'Key_reads';
40Variable_name	Value
41Key_reads	0
42connection test_con1;
43## Inserting some rows in table ##
44INSERT INTO t1(rollno, name) VALUES(5, 'Record_11');
45INSERT INTO t1(rollno, name) VALUES(6, 'Record_12');
46INSERT INTO t1(rollno, name) VALUES(5, 'Record_13');
47INSERT INTO t1(rollno, name) VALUES(7, 'Record_14');
48INSERT INTO t1(rollno, name) VALUES(5, 'Record_15');
49INSERT INTO t1(rollno, name) VALUES(7, 'Record_16');
50INSERT INTO t1(rollno, name) VALUES(8, 'Record_17');
51INSERT INTO t1(rollno, name) VALUES(8, 'Record_18');
52INSERT INTO t1(rollno, name) VALUES(8, 'Record_19');
53INSERT INTO t1(rollno, name) VALUES(8, 'Record_20');
54## Key_reads must be zero (no disk access) ##
55show status like 'Key_reads';
56Variable_name	Value
57Key_reads	0
58## Dropping table ##
59DROP TABLE IF EXISTS t1;
60disconnect test_con2;
61disconnect test_con1;
62connection default;
63SET @@global.key_buffer_size= @start_value;
64