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 --source include/have_innodb.inc
7
8 #
9 # show the global and session values;
10 #
11 select @@global.innodb_ft_cache_size;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.innodb_ft_cache_size;
14 show global variables like 'innodb_ft_cache_size';
15 show session variables like 'innodb_ft_cache_size';
16 --disable_warnings
17 select * from information_schema.global_variables where variable_name='innodb_ft_cache_size';
18 select * from information_schema.session_variables where variable_name='innodb_ft_cache_size';
19 --enable_warnings
20
21 set global innodb_ft_cache_size=1;
22 SHOW VARIABLES like 'innodb_ft_cache_size';
23
24 --error ER_GLOBAL_VARIABLE
25 set session innodb_ft_cache_size=1;
26
27 set global innodb_ft_cache_size=512*1024*1024;
28 SHOW VARIABLES like 'innodb_ft_cache_size';
29 set global innodb_ft_cache_size=default;