Innotop

Original post: http://anothermysqldba.blogspot.com/2013/05/innotop.html

Techmint.com tem um bom artigo sobre Innotop: http://www.tecmint.com/install-innotop-to-monitor-mysql-server-performance/

Innotop é uma ferramenta de monitoramento útil e este artigo tem bons exemplos para você começar.

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. 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. 

Alguma leitura adicional sobre este tema pode ser encontrada aqui:

• 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 Livro