Debian Codegraph @

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

raw
1
2
3 ################## mysql-test\t\innodb_buffer_pool_size_basic.test ############
4 # #
5 # Variable Name: innodb_buffer_pool_size #
6 # Scope: Global #
7 # Access Type: Static #
8 # Data Type: numeric #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author : Sharique Abdullah #
13 # #
14 # #
15 # Description:Test Cases of Dynamic System Variable innodb_buffer_pool_size #
16 # that checks the behavior of this variable in the following ways #
17 # * Value Check #
18 # * Scope Check #
19 # #
20 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
21 # server-system-variables.html #
22 # #
23 ###############################################################################
24
25 --source include/have_innodb.inc
26
27 SET @start_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size;
28
29 --echo '#---------------------BS_STVARS_022_02----------------------#'
30 ####################################################################
31 # Check if Value can set #
32 ####################################################################
33
34 --enable_warnings
35 SELECT @@GLOBAL.innodb_buffer_pool_size_max;
36 SELECT @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max;
37 SET GLOBAL innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max + 1048576;
38 SELECT @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max;
39 --disable_warnings
40
41 --echo '#---------------------BS_STVARS_022_03----------------------#'
42 #################################################################
43 # Check if the value in GLOBAL Table matches value in variable #
44 #################################################################
45
46 --disable_warnings
47 SELECT @@GLOBAL.innodb_buffer_pool_size = VARIABLE_VALUE
48 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
49 WHERE VARIABLE_NAME='innodb_buffer_pool_size';
50 --enable_warnings
51 --echo 1 Expected
52
53 --disable_warnings
54 SELECT COUNT(VARIABLE_VALUE)
55 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
56 WHERE VARIABLE_NAME='innodb_buffer_pool_size';
57 --enable_warnings
58 --echo 1 Expected
59
60 --echo '#---------------------BS_STVARS_022_04----------------------#'
61 ################################################################################
62 # Check if accessing variable with and without GLOBAL point to same variable #
63 ################################################################################
64 SELECT @@innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size;
65 --echo 1 Expected
66
67
68
69 --echo '#---------------------BS_STVARS_022_05----------------------#'
70 ################################################################################
71 # Check if innodb_buffer_pool_size can be accessed with and without @@ sign #
72 ################################################################################
73
74 SELECT COUNT(@@innodb_buffer_pool_size);
75 --echo 1 Expected
76
77 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
78 SELECT COUNT(@@local.innodb_buffer_pool_size);
79 --echo Expected error 'Variable is a GLOBAL variable'
80
81 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
82 SELECT COUNT(@@SESSION.innodb_buffer_pool_size);
83 --echo Expected error 'Variable is a GLOBAL variable'
84
85 SELECT COUNT(@@GLOBAL.innodb_buffer_pool_size);
86 --echo 1 Expected
87
88 --Error ER_BAD_FIELD_ERROR
89 SELECT innodb_buffer_pool_size = @@SESSION.innodb_buffer_pool_size;
90
91
92 # Restore the original buffer pool size.
93 SET GLOBAL innodb_buffer_pool_size = @start_buffer_pool_size;
94
95 SELECT @@innodb_buffer_pool_size = @start_buffer_pool_size;