Debian Codegraph @

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

raw
1
2 #
3 # 2011-11-17 - Added
4 #
5
6
7 #
8 # show the global and session values;
9 #
10 select @@global.innodb_ft_cache_size;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_ft_cache_size;
13 show global variables like 'innodb_ft_cache_size';
14 show session variables like 'innodb_ft_cache_size';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_ft_cache_size';
17 select * from performance_schema.session_variables where variable_name='innodb_ft_cache_size';
18 --enable_warnings
19
20 #
21 # show that it's read-only
22 #
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set global innodb_ft_cache_size=1;
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 set session innodb_ft_cache_size=1;
27