Debian Codegraph @

mysql-test/suite/perfschema/include/processlist_load.inc

raw
1 # ../include/processlist_load.inc
2 #
3 # SUMMARY
4 #
5 # Execute PROCESSLIST queries, sorted by user
6 #
7 # USAGE
8 #
9 # Example: Using processlist_set.inc to set @@global.performance_schema_show_processlist
10 #
11 # let $pfs_spl = on/off
12 # --source ../include/processlist_set.inc
13 # --source ../include/processlist_load.inc
14 #
15 # Columns
16 # 1 <Id> 2 <User> 3 <Host> 4 <db> 5 <Command> 6 <Time> 7 <State> 8 <Info>
17
18 # Sort SHOW PROCESSLIST by User instead of Id because Id is not zero-padded
19 # Unique usernames give best results
20 --echo
21 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
22 --replace_regex /Daemon/<Command>/ /Connect/<Command>/ /Sleep/<Command>/
23 --sorted_result
24 SHOW FULL PROCESSLIST;
25
26 --echo
27 --echo # Performance Schema processlist table
28 --echo
29 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
30 --replace_regex /Daemon/<Command>/ /Connect/<Command>/ /Sleep/<Command>/
31 select * from performance_schema.processlist order by user, id;
32
33 --echo
34 --echo # Information Schema processlist table
35 --echo
36 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
37 --replace_regex /Daemon/<Command>/ /Connect/<Command>/ /Sleep/<Command>/
38 select * from information_schema.processlist order by user, id;
39