The tungsten_show_processlist is a read-only script which will show the output from tungsten show processlist on all available Connectors.
This requires the mysql command-line client and a running manager for cctrl to poll.
tungsten_show_processlist [ -a, --all ] [ -d, --debug ] [ -f, --filter ] [ -g, --grep ] [ -h, --help ] [ -m, --manager ] [ -p, --port ] [ -v, --verbose ]
Where:
Table 9.76. tungsten_show_processlist Command-line Options
| Option | Description |
|---|---|
--all, -a | Display disconnected users |
--debug, -d | (-d implies -v also) Debug mode is VERY chatty, avoid it unless you really need it. |
--filter, -f | Specify field/regex pairs as field=regex separated by pipe symbols, like this: --filter 'User=app_user|db=db7.*'. Available Fields: connector, DataSource, Id, User, Host, db, Command, Time, State, Info |
--grep, -g | Filter by regex on entire line, case insensitive only |
--help, -h | |
--manager, -m | Specify maanager host for cctrl to poll. Default: localhost |
--port, -p | Provide the connector port number |
--verbose, -v |