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.
Table B-1. mytop configuration and control
|
?
| | |
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.
|