使用INNOTOP监控MySQL性能

最新推荐文章于 2022-02-25 20:00:37 发布

lxneng

最新推荐文章于 2022-02-25 20:00:37 发布

阅读量218

点赞数

分类专栏： MySQL 文章标签： MySQL thread C C++ C#

MySQL 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

最近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：
[url=http://www.fire9.cn/?p=112]一款开源的监控MYSQL性能的工具—INNOTOP[/url]
[url=http://www.xaprb.com/blog/2006/07/02/innotop-mysql-innodb-monitor/]The innotop MySQL and InnoDB monitor[/url]