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