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