Debian Codegraph @

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

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