Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_ft_cache_size_basic.result

raw
1 select @@global.innodb_ft_cache_size;
2 @@global.innodb_ft_cache_size
3 8000000
4 select @@session.innodb_ft_cache_size;
5 ERROR HY000: Variable 'innodb_ft_cache_size' is a GLOBAL variable
6 show global variables like 'innodb_ft_cache_size';
7 Variable_name Value
8 innodb_ft_cache_size 8000000
9 show session variables like 'innodb_ft_cache_size';
10 Variable_name Value
11 innodb_ft_cache_size 8000000
12 select * from information_schema.global_variables where variable_name='innodb_ft_cache_size';
13 VARIABLE_NAME VARIABLE_VALUE
14 INNODB_FT_CACHE_SIZE 8000000
15 select * from information_schema.session_variables where variable_name='innodb_ft_cache_size';
16 VARIABLE_NAME VARIABLE_VALUE
17 INNODB_FT_CACHE_SIZE 8000000
18 set global innodb_ft_cache_size=1;
19 Warnings:
20 Warning 1292 Truncated incorrect innodb_ft_cache_size value: '1'
21 SHOW VARIABLES like 'innodb_ft_cache_size';
22 Variable_name Value
23 innodb_ft_cache_size 1600000
24 set session innodb_ft_cache_size=1;
25 ERROR HY000: Variable 'innodb_ft_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
26 set global innodb_ft_cache_size=512*1024*1024;
27 SHOW VARIABLES like 'innodb_ft_cache_size';
28 Variable_name Value
29 innodb_ft_cache_size 536870912
30 set global innodb_ft_cache_size=default;