Debian Codegraph @

mysql-test/suite/sys_vars/t/key_buffer_size_func.test

raw
1 ################### mysql-test\t\key_buffer_size_func.test ####################
2 # #
3 # Variable Name: key_buffer_size #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value: 131072 #
8 # Range:8-4294967295 #
9 # #
10 # #
11 # Creation Date: 2008-03-07 #
12 # Author: Salman Rawala #
13 # #
14 # Description: Test Cases of Dynamic System Variable key_buffer_size #
15 # that checks the functionality of this variable #
16 # #
17 # Reference: #
18 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
19 # #
20 ###############################################################################
21
22 --disable_warnings
23 DROP TABLE IF EXISTS t1;
24 --enable_warnings
25
26 #########################
27 # Creating new table #
28 #########################
29
30 --echo ## Creating new table t1 ##
31 CREATE TABLE t1
32 (
33 id INT NOT NULL AUTO_INCREMENT,
34 PRIMARY KEY (id),
35 rollno INT NOT NULL,
36 name VARCHAR(30)
37 );
38
39 SET @start_value= @@global.key_buffer_size;
40
41 FLUSH STATUS;
42
43 --echo '#--------------------FN_DYNVARS_055_01-------------------------#'
44 ########################################################################
45 # Setting initial value of key_buffer_size, inserting some rows
46 # & creating 2 new connections
47 ########################################################################
48
49 --echo ## Setting initial value of variable to 131072 ##
50 SET @@global.key_buffer_size = 131072;
51
52
53 CONNECT (test_con1,localhost,root,,);
54 CONNECT (test_con2,localhost,root,,);
55
56
57 --echo '#--------------------FN_DYNVARS_055_02-------------------------#'
58 ###############################################################################
59 # Verifying initial behavior of variable by concatinating values greater than 4
60 ###############################################################################
61
62 CONNECTION test_con1;
63 SELECT @@global.key_buffer_size;
64
65
66 --echo ## Inserting some rows in table ##
67 INSERT INTO t1(rollno, name) VALUES(1, 'Record_1');
68 INSERT INTO t1(rollno, name) VALUES(2, 'Record_2');
69 INSERT INTO t1(rollno, name) VALUES(1, 'Record_3');
70 INSERT INTO t1(rollno, name) VALUES(3, 'Record_4');
71 INSERT INTO t1(rollno, name) VALUES(1, 'Record_5');
72 INSERT INTO t1(rollno, name) VALUES(3, 'Record_6');
73 INSERT INTO t1(rollno, name) VALUES(4, 'Record_7');
74 INSERT INTO t1(rollno, name) VALUES(4, 'Record_8');
75 INSERT INTO t1(rollno, name) VALUES(4, 'Record_9');
76 INSERT INTO t1(rollno, name) VALUES(4, 'Record_10');
77
78 --echo ## Key_reads must be zero (no disk access) ##
79 show status like 'Key_reads';
80
81 connection test_con2;
82
83 --echo ## Key_reads must be zero (no disk access) ##
84 show status like 'Key_reads';
85
86 CONNECTION test_con1;
87
88 --echo ## Inserting some rows in table ##
89 INSERT INTO t1(rollno, name) VALUES(5, 'Record_11');
90 INSERT INTO t1(rollno, name) VALUES(6, 'Record_12');
91 INSERT INTO t1(rollno, name) VALUES(5, 'Record_13');
92 INSERT INTO t1(rollno, name) VALUES(7, 'Record_14');
93 INSERT INTO t1(rollno, name) VALUES(5, 'Record_15');
94 INSERT INTO t1(rollno, name) VALUES(7, 'Record_16');
95 INSERT INTO t1(rollno, name) VALUES(8, 'Record_17');
96 INSERT INTO t1(rollno, name) VALUES(8, 'Record_18');
97 INSERT INTO t1(rollno, name) VALUES(8, 'Record_19');
98 INSERT INTO t1(rollno, name) VALUES(8, 'Record_20');
99
100 --echo ## Key_reads must be zero (no disk access) ##
101 show status like 'Key_reads';
102
103 ############################################################
104 # Disconnecting all connection & dropping table #
105 ############################################################
106
107 --echo ## Dropping table ##
108 DROP TABLE IF EXISTS t1;
109
110 DISCONNECT test_con2;
111 DISCONNECT test_con1;
112
113 connection default;
114 SET @@global.key_buffer_size= @start_value;