Innotop is a helpful monitoring tool and this article has nice examples to get you started.
innotop-1.9.0]# /usr/local/bin/innotop --help
Usage: innotop
--[no]color -C Use terminal coloring (default)
--config -c Config file to read
--count Number of updates before exiting
--delay -d Delay between updates in seconds
--help Show this help message
--host -h Connect to host
--[no]inc -i Measure incremental differences
--mode -m Operating mode to start in
--nonint -n Non-interactive, output tab-separated fields
--password -p Password to use for connection
--port -P Port number to use for connection
--skipcentral -s Skip reading the central configuration file
--socket -S MySQL socket to use for connection
--spark Length of status sparkline (default 10)
--timestamp -t Print timestamp in -n mode (1: per iter; 2: per line)
--user -u User for login if not current user
--version Output version information and exit
--write -w Write running configuration into home directory if no config files were loaded
innotop is a MySQL and InnoDB transaction/status monitor, like 'top' for
MySQL. It displays queries, InnoDB transactions, lock waits, deadlocks,
foreign key errors, open tables, replication status, buffer information,
row operations, logs, I/O operations, load graph, and more. You can
monitor many servers at once with innotop.
Some additional reading on this topic can be found here:
- http://www.xaprb.com/blog/2006/07/02/innotop-mysql-innodb-monitor/
- http://www.xaprb.com/blog/category/innotop/
- http://csrdu.org/toqeer/2010/09/27/innotop-and-mtop-installation-for-monitoring-mysql/
- http://www.linux-mag.com/id/7646/
- http://www.onlamp.com/pub/a/mysql/2006/10/19/mysql-tools.html
- High Performance MySQL Book
