使用innotop监控mysql性能

下载地址:


版本:    121 KB

安装:
perl Makefile.PL (若缺少perl模块,需安装,若机器已经联网:如cpan -i DBD::mysql)
make install

使用:
[root@localhost ~]# 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
  --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.

[root@localhost ~]# innotop -uroot -pwjlcn -S/home/wjlcn/app/mysql/tmp/3306/mysql.sock

When   Load  QPS   Slow  Se/In/Up/De%  QCacheHit  KCacheHit  BpsIn  BpsOut
Now    0.10  0.20     0   0/ 0/ 0/ 0       0.00%    100.00%   8.80  811.35
Total  0.00  0.01     0  11/765/ 0/ 0      1.22%     99.71%  38.49   14.56

Cmd    ID      State  User   Host           DB      Time   Query




___________________________ Buffer Pool ____________________________
Size    Free Bufs  Pages  Dirty Pages  Hit Rate  Memory   Add'l Pool
16.75k      16963    188            0  --        373.39M       2.67M

____________________ Page Statistics _____________________
Reads  Writes  Created  Reads/Sec  Writes/Sec  Creates/Sec
   64     471      124       0.00        0.00         0.00

______________________ Insert Buffers ______________________
Inserts  Merged Recs  Merges  Size  Free List Len  Seg. Size
      0            0       0     1              0          2

_________________ Adaptive Hash Index __________________
Size  Cells Used  Node Heap Bufs  Hash/Sec  Non-Hash/Sec
                                      0.00          0.00