Databases Reference
In-Depth Information
Figure 16-2. innotop help screen
Figure 16-3. innotop in Q (Query List) mode
The header shows statistics for “Now” (which measures incremental activity since the
last time
innotop
refreshed itself with new data from the server) and “Total” (which
measures all activity since the MySQL server started, in this case 25 days ago). Each
column in the header is derived from an equation involving values from
SHOW STATUS
and
SHOW VARIABLES
. The default headers shown in
Figure 16-3
are built in, but it's easy
to add your own. All you have to do is add a column to the header “table.” Press the
^ key to start the table editor, then enter
q_header
at the prompt to edit the header
table (
Figure 16-4
). Tab completion is built in, so you can just press
q
and then Tab to
complete the word.
