Debian Codegraph @

mysql-test/suite/sys_vars/r/key_buffer_size_func.result

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