Debian Codegraph @

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

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