| 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 |
|