innotop mysql_使用innotop监控mysql性能

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