| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
call mtr.add_suppression("duplicate variable name"); |
| 7 |
# Simple load test |
| 8 |
INSTALL COMPONENT "file://component_test_sys_var_service"; |
| 9 |
SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info |
| 10 |
WHERE VARIABLE_NAME LIKE '%component%' |
| 11 |
ORDER BY VARIABLE_NAME; |
| 12 |
VARIABLE_NAME MIN_VALUE MAX_VALUE |
| 13 |
test_component.bool_ro_sys_var 0 0 |
| 14 |
test_component.bool_sys_var 0 0 |
| 15 |
test_component.enum_sys_var 0 0 |
| 16 |
test_component.int_sys_var 0 1024 |
| 17 |
test_component.long_sys_var 10 100 |
| 18 |
test_component.longlong_sys_var 1000 8192819281928192 |
| 19 |
test_component.str_sys_var 0 0 |
| 20 |
test_component.str_sys_var_default 0 0 |
| 21 |
test_component.uint_sys_var 10 10241024 |
| 22 |
test_component.ulong_sys_var 1000 81928192 |
| 23 |
test_component.ulonglong_sys_var 1000 8192819281928192 |
| 24 |
# Testing integer and bool type variable |
| 25 |
SELECT @@test_component.int_sys_var; |
| 26 |
@@test_component.int_sys_var |
| 27 |
8 |
| 28 |
SELECT @@global.test_component.int_sys_var; |
| 29 |
@@global.test_component.int_sys_var |
| 30 |
8 |
| 31 |
SELECT @@global.test_component.bool_sys_var; |
| 32 |
@@global.test_component.bool_sys_var |
| 33 |
1 |
| 34 |
SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var; |
| 35 |
@@test_component.int_sys_var @@test_component.bool_sys_var |
| 36 |
8 1 |
| 37 |
SET test_component.bool_sys_var=1; |
| 38 |
ERROR HY000: Variable 'test_component.bool_sys_var' is a GLOBAL variable and should be set with SET GLOBAL |
| 39 |
SET GLOBAL test_component.int_sys_var=7; |
| 40 |
SET GLOBAL test_component.int_sys_var=1234567; |
| 41 |
Warnings: |
| 42 |
Warning 1292 Truncated incorrect test_component.int_sys_var value: '1234567' |
| 43 |
SELECT @@test_component.int_sys_var; |
| 44 |
@@test_component.int_sys_var |
| 45 |
1024 |
| 46 |
SET GLOBAL test_component.int_sys_var=-1; |
| 47 |
Warnings: |
| 48 |
Warning 1292 Truncated incorrect test_component.int_sys_var value: '-1' |
| 49 |
SELECT @@test_component.int_sys_var; |
| 50 |
@@test_component.int_sys_var |
| 51 |
0 |
| 52 |
SET GLOBAL test_component.int_sys_var=1.25; |
| 53 |
ERROR 42000: Incorrect argument type to variable 'test_component.int_sys_var' |
| 54 |
SET GLOBAL test_component.int_sys_var="hello"; |
| 55 |
ERROR 42000: Incorrect argument type to variable 'test_component.int_sys_var' |
| 56 |
SET GLOBAL test_component.int_sys_var=123, test_component.bool_sys_var=0; |
| 57 |
SELECT @@test_component.int_sys_var, @@test_component.bool_sys_var; |
| 58 |
@@test_component.int_sys_var @@test_component.bool_sys_var |
| 59 |
123 0 |
| 60 |
SET SESSION test_component.int_sys_var=123; |
| 61 |
ERROR HY000: Variable 'test_component.int_sys_var' is a GLOBAL variable and should be set with SET GLOBAL |
| 62 |
# Testing enum type variable |
| 63 |
SELECT @@test_component.enum_sys_var; |
| 64 |
@@test_component.enum_sys_var |
| 65 |
MEDIUM |
| 66 |
SET GLOBAL test_component.enum_sys_var="LOW"; |
| 67 |
SELECT @@test_component.enum_sys_var; |
| 68 |
@@test_component.enum_sys_var |
| 69 |
LOW |
| 70 |
# Testing string type variable |
| 71 |
SELECT @@test_component.str_sys_var; |
| 72 |
@@test_component.str_sys_var |
| 73 |
NULL |
| 74 |
SET GLOBAL test_component.str_sys_var="dictionary.txt"; |
| 75 |
SELECT @@test_component.str_sys_var; |
| 76 |
@@test_component.str_sys_var |
| 77 |
dictionary.txt |
| 78 |
SET GLOBAL test_component.str_sys_var=default; |
| 79 |
SELECT @@test_component.str_sys_var; |
| 80 |
@@test_component.str_sys_var |
| 81 |
NULL |
| 82 |
# Testing unsigned integer type variable |
| 83 |
SELECT @@test_component.uint_sys_var; |
| 84 |
@@test_component.uint_sys_var |
| 85 |
1024 |
| 86 |
SET GLOBAL test_component.uint_sys_var=12345678; |
| 87 |
Warnings: |
| 88 |
Warning 1292 Truncated incorrect test_component.uint_sys_var value: '12345678' |
| 89 |
SELECT @@test_component.uint_sys_var; |
| 90 |
@@test_component.uint_sys_var |
| 91 |
10241024 |
| 92 |
SET GLOBAL test_component.uint_sys_var=default; |
| 93 |
SELECT @@test_component.uint_sys_var; |
| 94 |
@@test_component.uint_sys_var |
| 95 |
1024 |
| 96 |
# Testing long type variable |
| 97 |
SELECT @@test_component.long_sys_var; |
| 98 |
@@test_component.long_sys_var |
| 99 |
100 |
| 100 |
SET GLOBAL test_component.long_sys_var=1234567890; |
| 101 |
Warnings: |
| 102 |
Warning 1292 Truncated incorrect test_component.long_sys_var value: '1234567890' |
| 103 |
SELECT @@test_component.long_sys_var; |
| 104 |
@@test_component.long_sys_var |
| 105 |
100 |
| 106 |
SET GLOBAL test_component.long_sys_var=default; |
| 107 |
SELECT @@test_component.long_sys_var; |
| 108 |
@@test_component.long_sys_var |
| 109 |
100 |
| 110 |
# Testing unsigned long type variable |
| 111 |
SELECT @@test_component.ulong_sys_var; |
| 112 |
@@test_component.ulong_sys_var |
| 113 |
8192 |
| 114 |
SET GLOBAL test_component.ulong_sys_var=1234567890; |
| 115 |
Warnings: |
| 116 |
Warning 1292 Truncated incorrect test_component.ulong_sys_var value: '1234567890' |
| 117 |
SELECT @@test_component.ulong_sys_var; |
| 118 |
@@test_component.ulong_sys_var |
| 119 |
81928192 |
| 120 |
SET GLOBAL test_component.ulong_sys_var=default; |
| 121 |
SELECT @@test_component.ulong_sys_var; |
| 122 |
@@test_component.ulong_sys_var |
| 123 |
8192 |
| 124 |
# Testing long long type variable |
| 125 |
SELECT @@test_component.longlong_sys_var; |
| 126 |
@@test_component.longlong_sys_var |
| 127 |
8192 |
| 128 |
SET GLOBAL test_component.longlong_sys_var=1234567890; |
| 129 |
SELECT @@test_component.longlong_sys_var; |
| 130 |
@@test_component.longlong_sys_var |
| 131 |
1234567890 |
| 132 |
SET GLOBAL test_component.longlong_sys_var=default; |
| 133 |
SELECT @@test_component.longlong_sys_var; |
| 134 |
@@test_component.longlong_sys_var |
| 135 |
8192 |
| 136 |
# Testing unsigned long long type variable |
| 137 |
SELECT @@test_component.ulonglong_sys_var; |
| 138 |
@@test_component.ulonglong_sys_var |
| 139 |
8192 |
| 140 |
SET GLOBAL test_component.ulonglong_sys_var=1234567890; |
| 141 |
SELECT @@test_component.ulonglong_sys_var; |
| 142 |
@@test_component.ulonglong_sys_var |
| 143 |
1234567890 |
| 144 |
SET GLOBAL test_component.ulonglong_sys_var=default; |
| 145 |
SELECT @@test_component.ulonglong_sys_var; |
| 146 |
@@test_component.ulonglong_sys_var |
| 147 |
8192 |
| 148 |
# Testing PERSIST for component system variables |
| 149 |
SET PERSIST test_component.int_sys_var=7; |
| 150 |
SELECT @@test_component.int_sys_var; |
| 151 |
@@test_component.int_sys_var |
| 152 |
7 |
| 153 |
SELECT * FROM performance_schema.persisted_variables; |
| 154 |
VARIABLE_NAME VARIABLE_VALUE |
| 155 |
test_component.int_sys_var 7 |
| 156 |
RESET PERSIST `test_component.int_sys_var`; |
| 157 |
SELECT * FROM performance_schema.persisted_variables; |
| 158 |
VARIABLE_NAME VARIABLE_VALUE |
| 159 |
sync_slave_with_master; |
| 160 |
connection slave; |
| 161 |
INSTALL COMPONENT "file://component_test_sys_var_service"; |
| 162 |
SELECT VARIABLE_NAME, MIN_VALUE, MAX_VALUE FROM performance_schema.variables_info |
| 163 |
WHERE VARIABLE_NAME LIKE '%component%' |
| 164 |
ORDER BY VARIABLE_NAME; |
| 165 |
VARIABLE_NAME MIN_VALUE MAX_VALUE |
| 166 |
test_component.bool_ro_sys_var 0 0 |
| 167 |
test_component.bool_sys_var 0 0 |
| 168 |
test_component.enum_sys_var 0 0 |
| 169 |
test_component.int_sys_var 0 1024 |
| 170 |
test_component.long_sys_var 10 100 |
| 171 |
test_component.longlong_sys_var 1000 8192819281928192 |
| 172 |
test_component.str_sys_var 0 0 |
| 173 |
test_component.str_sys_var_default 0 0 |
| 174 |
test_component.uint_sys_var 10 10241024 |
| 175 |
test_component.ulong_sys_var 1000 81928192 |
| 176 |
test_component.ulonglong_sys_var 1000 8192819281928192 |
| 177 |
SET GLOBAL test_component.int_sys_var=7; |
| 178 |
SET GLOBAL test_component.str_sys_var="salve.txt"; |
| 179 |
SELECT @@test_component.int_sys_var; |
| 180 |
@@test_component.int_sys_var |
| 181 |
7 |
| 182 |
SELECT @@test_component.long_sys_var; |
| 183 |
@@test_component.long_sys_var |
| 184 |
100 |
| 185 |
SELECT @@test_component.ulong_sys_var; |
| 186 |
@@test_component.ulong_sys_var |
| 187 |
8192 |
| 188 |
SELECT @@test_component.longlong_sys_var; |
| 189 |
@@test_component.longlong_sys_var |
| 190 |
8192 |
| 191 |
SELECT @@test_component.ulonglong_sys_var; |
| 192 |
@@test_component.ulonglong_sys_var |
| 193 |
8192 |
| 194 |
SELECT @@test_component.str_sys_var; |
| 195 |
@@test_component.str_sys_var |
| 196 |
salve.txt |
| 197 |
UNINSTALL COMPONENT "file://component_test_sys_var_service"; |
| 198 |
connection master; |
| 199 |
UNINSTALL COMPONENT "file://component_test_sys_var_service"; |
| 200 |
include/rpl_end.inc |