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; 15## Creating two new connections ## 16'#--------------------FN_DYNVARS_055_02-------------------------#' 17## Connecting with connection test_con1 ## 18SELECT @@global.key_buffer_size; 19@@global.key_buffer_size 20131072 21## Inserting some rows in table ## 22INSERT INTO t1(rollno, name) VALUES(1, 'Record_1'); 23INSERT INTO t1(rollno, name) VALUES(2, 'Record_2'); 24INSERT INTO t1(rollno, name) VALUES(1, 'Record_3'); 25INSERT INTO t1(rollno, name) VALUES(3, 'Record_4'); 26INSERT INTO t1(rollno, name) VALUES(1, 'Record_5'); 27INSERT INTO t1(rollno, name) VALUES(3, 'Record_6'); 28INSERT INTO t1(rollno, name) VALUES(4, 'Record_7'); 29INSERT INTO t1(rollno, name) VALUES(4, 'Record_8'); 30INSERT INTO t1(rollno, name) VALUES(4, 'Record_9'); 31INSERT INTO t1(rollno, name) VALUES(4, 'Record_10'); 32## Key_reads must be zero (no disk access) ## 33show status like 'Key_reads'; 34Variable_name Value 35Key_reads 0 36## Switching to connection test_con2 ## 37## Key_reads must be zero (no disk access) ## 38show status like 'Key_reads'; 39Variable_name Value 40Key_reads 0 41## Connecting with connection test_con1 ## 42## Inserting some rows in table ## 43INSERT INTO t1(rollno, name) VALUES(5, 'Record_11'); 44INSERT INTO t1(rollno, name) VALUES(6, 'Record_12'); 45INSERT INTO t1(rollno, name) VALUES(5, 'Record_13'); 46INSERT INTO t1(rollno, name) VALUES(7, 'Record_14'); 47INSERT INTO t1(rollno, name) VALUES(5, 'Record_15'); 48INSERT INTO t1(rollno, name) VALUES(7, 'Record_16'); 49INSERT INTO t1(rollno, name) VALUES(8, 'Record_17'); 50INSERT INTO t1(rollno, name) VALUES(8, 'Record_18'); 51INSERT INTO t1(rollno, name) VALUES(8, 'Record_19'); 52INSERT INTO t1(rollno, name) VALUES(8, 'Record_20'); 53## Key_reads must be zero (no disk access) ## 54show status like 'Key_reads'; 55Variable_name Value 56Key_reads 0 57## Dropping table ## 58DROP TABLE IF EXISTS t1; 59## Disconnecting both the connections ## 60SET @@global.key_buffer_size= @start_value; 61