Debian Codegraph @

mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic.test

raw
1
2 #
3 # Only global
4 #
5
6 select @@global.performance_schema_max_table_handles;
7
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.performance_schema_max_table_handles;
10
11 show global variables like 'performance_schema_max_table_handles';
12
13 show session variables like 'performance_schema_max_table_handles';
14
15 select * from performance_schema.global_variables
16 where variable_name='performance_schema_max_table_handles';
17
18 select * from performance_schema.session_variables
19 where variable_name='performance_schema_max_table_handles';
20
21 #
22 # Read-only
23 #
24
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 set global performance_schema_max_table_handles=1;
27
28 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
29 set session performance_schema_max_table_handles=1;
30