1
drop table if exists t1;
2
## Creating new table t1 ##
5
id INT NOT NULL auto_increment,
11
'#--------------------FN_DYNVARS_055_01-------------------------#'
12
## Setting initial value of variable to 131072 ##
13
SET @@global.key_buffer_size = 131072;
14
## Creating two new connections ##
15
'#--------------------FN_DYNVARS_055_02-------------------------#'
16
## Connecting with connection test_con1 ##
17
SELECT @@global.key_buffer_size;
18
@@global.key_buffer_size
20
## Inserting some rows in table ##
21
INSERT into t1(rollno, name) values(1, 'Record_1');
22
INSERT into t1(rollno, name) values(2, 'Record_2');
23
INSERT into t1(rollno, name) values(1, 'Record_3');
24
INSERT into t1(rollno, name) values(3, 'Record_4');
25
INSERT into t1(rollno, name) values(1, 'Record_5');
26
INSERT into t1(rollno, name) values(3, 'Record_6');
27
INSERT into t1(rollno, name) values(4, 'Record_7');
28
INSERT into t1(rollno, name) values(4, 'Record_8');
29
INSERT into t1(rollno, name) values(4, 'Record_9');
30
INSERT into t1(rollno, name) values(4, 'Record_10');
31
## Verifying status of reading & writing variables ##
32
## Switching to connection test_con2 ##
33
## Verifying status of reading & writing variables ##
35
DROP table if exists t1;
36
## Disconnecting both the connections ##