Debian Codegraph @

mysql-test/suite/perfschema/t/processlist_no_pfs.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source ../include/start_server_common.inc
4
5 --echo
6 select * from information_schema.engines
7 where engine = "PERFORMANCE_SCHEMA";
8
9 --echo
10 --echo # If the Performance Schema is disabled, then expect
11 --echo # performance-schema-show-processlist = OFF
12 --echo # regardless of its initial setting
13 --echo
14 select @@global.performance_schema_show_processlist;
15
16 --echo
17 --echo # If the Performance Schema is disabled, then setting
18 --echo # performance-schema-show-processlist = ON
19 --echo # succeeds, SHOW PROCESSLIST returns no data.
20 --echo
21 set @@global.performance_schema_show_processlist = ON;
22
23 SHOW PROCESSLIST;
24
25 --echo
26 show global variables like "performance_schema";
27