لطفا منتظر باشید ...
• Table of Contents
• Index
• Reviews
• Reader Reviews
• Errata
• Academic
High Performance MySQL
By
Derek J. Balling, Jeremy Zawodny
Publisher: OReilly
Pub Date: April 2004
ISBN: 0-596-00306-4
Pages: 294
Slots: 1.0
In High Performance MySQL you will
learn about MySQL indexing and optimization in depth so you
can make better use of these key features. You will learn
practical replication, backup, and load-balancing strategies
with information that goes beyond available tools to discuss
their effects in real-life environments. And youll learn
the supporting techniques you need to carry out these tasks,
including advanced configuration, benchmarking, and
investigating logs.
B.3 Configuration and Usage
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. |
