您好,登錄后才能下訂單哦!
[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
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。