mytop's behavior is controlled by a combination of command-line arguments, configuration file options, and runtime keystrokes. Most command-line arguments appear in single letter (-p) and longer GNU-style (--password) forms. Table B-1 lists the keystrokes, command-line arguments, configuration file directives, and the actions they perform.
Upon startup, mytop looks for a ~/.mytop. If it finds one, it reads in the settings and uses them as defaults, which are then overridden by any command-line arguments. The configuration file format is composed of key/value pairs, one per line. A sample file might look like this:
user=jzawodn pass=blah!db host=localhost
Most of the command-line arguments have a counterpart option in the configuration file. Future versions of mytop are expected to read MySQL's /etc/my.cnf and ~/.my.cnf as well, possibly deprecating ~/.mytop at some point.
|
Key |
Argument(s) |
Config file |
Action |
|---|---|---|---|
|
? |
Display help screen | ||
|
--batch or --batchmode |
batchmode=1 |
Run in batch (noninteractive) mode. Useful when called from cron or another script. | |
|
c |
-m=cmd or --mode=cmd |
mode=cmd |
Command summary view. |
|
C |
--color or --nocolor |
color=[0|1] |
Use colors in the display. (Requires the Term::ANSIColor module.) The key toggles color on/off. |
|
d |
filter_db=dbname |
Show threads using one specific database. | |
|
-d or --database |
db=dbname |
Connect to this database. | |
|
e |
Explain the query a thread is running. | ||
|
f |
Show the full query a thread is executing. | ||
|
F |
Unfilter the display; return to defaults. | ||
|
-h or --host |
host=hostname |
Specify the host on which MySQL is running; default is localhost. | |
|
h |
Show only connections from a particular host. | ||
|
H |
--header or--noheader |
Display the header mytop's display (key toggles the header display). | |
|
i |
-i or --idle |
idle=[0|1] |
Filter idle (sleeping) threads from the display. Key toggles this. |
|
I |
-m= or --mode=innodb |
mode=innodb |
Show InnoDB status. |
|
k |
Kill a thread. | ||
|
m |
-m= or --mode=[qps|top|cmd|innodb] |
mode=[qps|top|cmd|innodb] |
Mode switch. Cycle between thread view, queries per second, and command summary. |
|
o |
--sort=[0|1] |
sort=[0|1] |
Reverse the sort order. Default is ascending based on time. |
|
p |
Pause the display. Any key resumes. | ||
|
-p or --password |
pass=password |
Connect using this password. | |
|
--prompt |
prompt=[0|1] |
Prompt for password interactively. | |
|
q |
Quit mytop. | ||
|
r |
Reset status counters (via FLUSH STATUS). | ||
|
R |
-r or --resolve |
resolve=[0|1] |
Resolve IP addresses into hostnames. This is useful when MySQL is configured with skip-name-resolve. |
|
s |
-s or --delay |
delay=number |
Adjust the refresh interval. |
|
S |
-m= --mode=status |
mode=status |
Switch to SHOW STATUS mode. |
|
-S or --socket |
socket=/path/to/socket |
Specify the socket to use when connecting to localhost. | |
|
t |
-m= or --mode=top |
mode=top |
Switch to thread view (the default). |
|
u |
filter_user=username |
Show only a particular user's threads. | |
|
-u or --user |
user=username |
Connect as this user. | |
|
V |
Switch to SHOW VARIABLES mode. | ||
|
: |
Enter a complex command. |