Debian Codegraph @

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

raw
1 select @@global.stored_program_definition_cache;
2 @@global.stored_program_definition_cache
3 256
4 select @@session.stored_program_definition_cache;
5 ERROR HY000: Variable 'stored_program_definition_cache' is a GLOBAL variable
6 show global variables like 'stored_program_definition_cache';
7 Variable_name Value
8 stored_program_definition_cache 256
9 show session variables like 'stored_program_definition_cache';
10 Variable_name Value
11 stored_program_definition_cache 256
12 select * from performance_schema.global_variables where variable_name='stored_program_definition_cache';
13 VARIABLE_NAME VARIABLE_VALUE
14 stored_program_definition_cache 256
15 select * from performance_schema.session_variables where variable_name='stored_program_definition_cache';
16 VARIABLE_NAME VARIABLE_VALUE
17 stored_program_definition_cache 256