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 performance_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 performance_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 global innodb_ft_result_cache_limit=900000;
19 Warnings:
20 Warning 1292 Truncated incorrect innodb_ft_result_cache_limit value: '900000'
21 select @@innodb_ft_result_cache_limit;
22 @@innodb_ft_result_cache_limit
23 1000000
24 set global innodb_ft_result_cache_limit=1000000;
25 select @@innodb_ft_result_cache_limit;
26 @@innodb_ft_result_cache_limit
27 1000000
28 set global innodb_ft_result_cache_limit=4294967295;
29 select @@innodb_ft_result_cache_limit;
30 @@innodb_ft_result_cache_limit
31 4294967295
32 set global innodb_ft_result_cache_limit=4*1024*1024*1024;
33 Warnings:
34 Warning 1292 Truncated incorrect innodb_ft_result_cache_limit value: '4294967296'
35 select @@innodb_ft_result_cache_limit;
36 @@innodb_ft_result_cache_limit
37 4294967295
38 set global innodb_ft_result_cache_limit=2000000000;