使用INNOTOP监控MySQL性能

最近MySQL性能不太理想，已经搭建了MySQL主从同步，但是还要对数据库进一步优化。
老大在server上装了个叫innotop的工具，可以检测很多状态，上去用了一下，是个很不错的工具。

Switch to a different mode:
   B  InnoDB Buffers    I  InnoDB I/O Info     Q  Query List
   C  Command Summary   L  Locks               R  InnoDB Row Ops
   D  InnoDB Deadlocks  M  Replication Status  S  Variables & Status
   F  InnoDB FK Err     O  Open Tables         T  InnoDB Txns

Actions:
   a  Toggle the innotop process    k  Kill a query's connection
   c  Choose visible columns        n  Switch to the next connection
   d  Change refresh interval       p  Pause innotop
   e  Explain a thread's query      q  Quit innotop
   f  Show a thread's full query    r  Reverse sort order
   h  Toggle the header on and off  s  Change the display's sort column
   i  Toggle idle processes         x  Kill a query

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

参考blog：
    一款开源的监控MYSQL性能的工具—INNOTOP
    The innotop MySQL and InnoDB monitor

评论

1 楼 康跷_0613 2012-11-30  

官方网站怎么连个使用手册都没有~~