Debian Codegraph @

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

raw
1 select @@global.innodb_ft_result_cache_limit;
2 @@global.innodb_ft_result_cache_limit
3 2000000000
4 select @@session.innodb_ft_result_cache_limit;
5 ERROR HY000: Variable 'innodb_ft_result_cache_limit' is a GLOBAL variable
6 show global variables like 'innodb_ft_result_cache_limit';
7 Variable_name Value
8 innodb_ft_result_cache_limit 2000000000
9 show session variables like 'innodb_ft_result_cache_limit';
10 Variable_name Value
11 innodb_ft_result_cache_limit 2000000000
12 select * from information_schema.global_variables where variable_name='innodb_ft_result_cache_limit';
13 VARIABLE_NAME VARIABLE_VALUE
14 INNODB_FT_RESULT_CACHE_LIMIT 2000000000
15 select * from information_schema.session_variables where variable_name='innodb_ft_result_cache_limit';
16 VARIABLE_NAME VARIABLE_VALUE
17 INNODB_FT_RESULT_CACHE_LIMIT 2000000000
18 SET @save_limit = @@innodb_ft_result_cache_limit;
19 set global innodb_ft_result_cache_limit=900000;
20 Warnings:
21 Warning 1292 Truncated incorrect innodb_ft_result_cache_limit value: '900000'
22 select @@innodb_ft_result_cache_limit;
23 @@innodb_ft_result_cache_limit
24 1000000
25 set global innodb_ft_result_cache_limit=1000000;
26 select @@innodb_ft_result_cache_limit;
27 @@innodb_ft_result_cache_limit
28 1000000
29 set global innodb_ft_result_cache_limit=4294967295;
30 select @@innodb_ft_result_cache_limit;
31 @@innodb_ft_result_cache_limit
32 4294967295
33 set global innodb_ft_result_cache_limit=4*1024*1024*1024;
34 select @@innodb_ft_result_cache_limit;
35 @@innodb_ft_result_cache_limit
36 4294967296
37 set global innodb_ft_result_cache_limit = @save_limit;