【MySQL】數(shù)據(jù)庫監(jiān)控工具--innotop

[root@wallet04?~]#?yum?-y?install?perl-DBI?perl-DBD-MySQL?perl-Time-HiRes?perl-TermReadKey

[root@wallet04?~]#?git?clone?https://github.com/innotop/innotop.git
Initialized?empty?Git?repository?in?/root/innotop/.git/
remote:?Enumerating?objects:?621,?done.
remote:?Total?621?(delta?0),?reused?0?(delta?0),?pack-reused?621
Receiving?objects:?100%?(621/621),?1.17?MiB?|?230?KiB/s,?done.
Resolving?deltas:?100%?(382/382),?done.

[root@wallet04?~]#?cd?innotop
[root@wallet04?innotop]#?perl?Makefile.PL
[root@wallet04?innotop]#make
[root@wallet04?innotop]#make?install

[root@wallet04?~]#?innotop?--version
innotop??Ver?1.11.4

[root@wallet04?~]#?innotop?--help
Usage:?innotop?<options>?<innodb-status-file>
??--askpass??????????Prompt?for?a?password?when?connecting?to?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
??--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
??
[root@wallet04?~]#?innotop?--user?root?--askpass?--host?192.168.1.201???????????????????????????
Enter?password?:??
Switch?to?a?different?mode:
???A??Dashboard?????????I??InnoDB?I/O?Info?????Q??Query?List
???B??InnoDB?Buffers????K??InnoDB?Lock?Waits???R??InnoDB?Row?Ops
???C??Command?Summary???L??Locks???????????????S??Variables?&?Status
???D??InnoDB?Deadlocks??M??Replication?Status??T??InnoDB?Txns
???F??InnoDB?FK?Err?????O??Open?Tables?????????U??User?Statistics
Actions:
???d??Change?refresh?interval????????????p??Pause?innotop
???i??Toggle?incremental?status?display??q??Quit?innotop
???n??Switch?to?the?next?connection??????
Other:
?TAB??Switch?to?the?next?server?group???/??Quickly?filter?what?you?see
???!??Show?license?and?warranty?????????=??Toggle?aggregation
???#??Select/create?server?groups???????@??Select/create?server?connections
???$??Edit?configuration?settings???????\??Clear?quick-filters
Press?any?key?to?continue

Q?Query?List
When???Load??Cxns??QPS?????Slow??Se/In/Up/De%??QCacheHit??KCacheHit??BpsIn????BpsOut
Now????0.02????29??365.11?????0??97/?0/?0/?0???????0.00%????100.00%??297.38k???1.59M
Total??0.00??100???13.98????28??69/?7/?6/?0???????0.00%?????99.99%????4.06k??23.66k
Cmd????ID??????State??User???Host?????DB??????Time???Query

B?InnoDB?Buffers
_____________________________?Buffer?Pool?_____________________________
Size?????Free?Bufs??Pages??Dirty?Pages??Hit?Rate?????Memory??Add'l?Pool
256.00k?????179732??78992????????????0??100?/?100???4.09G???????????0
____________________?Page?Statistics?_____________________
Reads??Writes??Created??Reads/Sec??Writes/Sec??Creates/Sec
73859??922096?????6753???????0.00????????0.00?????????0.00
______________________?Insert?Buffers?______________________
Inserts??Merged?Recs??Merges??Size??Free?List?Len??Seg.?Size
???????????????????0???????0?????1???????????1811???????1813
__________________?Adaptive?Hash?Index?__________________
Size???Cells?Used??Node?Heap?Bufs??Hash/Sec??Non-Hash/Sec
8.44M????????????????????????3418??????0.50??????????0.00

I?InnoDB?I/O?Info
_________________________?I/O?Threads?__________________________
Thread??Purpose???????????????Thread?Status?????????????????????
?????0??insert?buffer?thread??waiting?for?completed?aio?requests
?????1??log?thread????????????waiting?for?completed?aio?requests
?????2??read?thread???????????waiting?for?completed?aio?requests
?????3??read?thread???????????waiting?for?completed?aio?requests
?????4??read?thread???????????waiting?for?completed?aio?requests
?????5??read?thread???????????waiting?for?completed?aio?requests
?????6??write?thread??????????waiting?for?completed?aio?requests
?????7??write?thread??????????waiting?for?completed?aio?requests
?????8??write?thread??????????waiting?for?completed?aio?requests
?????9??write?thread??????????waiting?for?completed?aio?requests
____________________________?Pending?I/O?_____________________________
Async?Rds??Async?Wrt??IBuf?Async?Rds??Sync?I/Os??Log?Flushes??Log?I/Os
???????????????????????????????????0??????????0????????????0?????????0
________________________?File?I/O?Misc?_________________________
OS?Reads??OS?Writes??OS?fsyncs??Reads/Sec??Writes/Sec??Bytes/Sec
???74180????2867756????2094872???????0.00????????0.00??????????0
_____________________?Log?Statistics?______________________
Sequence?No.??Flushed?To???Last?Checkpoint??IO?Done??IO/Sec
75091882485???75091882485??75091882485??????1829529????0.00