{"id":1804,"date":"2020-07-01T05:33:04","date_gmt":"2020-06-30T21:33:04","guid":{"rendered":"http:\/\/39.97.231.10\/?p=1804"},"modified":"2020-07-01T05:33:04","modified_gmt":"2020-06-30T21:33:04","slug":"mysql%e7%9b%91%e6%8e%a7%e5%b7%a5%e5%85%b7innotop","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=1804","title":{"rendered":"MySQL\u76d1\u63a7\u5de5\u5177innotop"},"content":{"rendered":"<p>innotop\u662f\u4e00\u4e2a\u975e\u5e38\u597d\u7528\u7684\u5f00\u6e90MySQL\u547d\u4ee4\u884c\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u5f00\u53d1\uff0c\u62e5\u6709\u5f88\u591a\u7684\u76d1\u63a7\u6a21\u5f0f\u548c\u9009\u9879\uff0c\u80fd\u591f\u76d1\u63a7MySQL\uff08InnoDB\uff09\u591a\u4e2a\u65b9\u9762\u7684\u6027\u80fd\u6307\u6807\uff0c\u8fde\u7eed\u4e0d\u65ad\u5730\u5237\u65b0\u6570\u636e\uff0c\u67e5\u770b\u5b9e\u65f6\u7edf\u8ba1\u4fe1\u606f\uff0c\u5e2e\u5fd9\u7ba1\u7406\u5458\u5feb\u901f\u627e\u51faMySQL\u7684\u95ee\u9898\u3002<br \/>\ninnotop\u80fd\u591f\u76d1\u63a7\u7684\u6307\u6807\uff1a<\/p>\n<ul>\n<li>QPS\/TPS<\/li>\n<li>innodb buffer\u4f7f\u7528\u60c5\u51b5<\/li>\n<li>\u6267\u884c\u7684\u547d\u4ee4\u7edf\u8ba1\u4fe1\u606f<\/li>\n<li>\u67e5\u8be2\u5217\u8868\uff0c\u7c7b\u4f3c\u4e8eshow processlist<\/li>\n<li>\u9501\u7b49\u5f85\u4fe1\u606f<\/li>\n<li>\u6b7b\u9501\u4fe1\u606f<\/li>\n<li>\u5916\u952e\u9519\u8bef\u4fe1\u606f<\/li>\n<li>innodb I\/O\u4fe1\u606f<\/li>\n<li>\u4e8b\u52a1\u4fe1\u606f<\/li>\n<li>\u4e3b\u4ece\u590d\u5236\u4fe1\u606f<\/li>\n<\/ul>\n<p>\u6e90\u7801\u5730\u5740\uff1a<br \/>\n<a href=\\\"https:\/\/github.com\/innotop\/innotop\\\">github.com\/innotop\/innotop<\/a><br \/>\n\u5f53\u524d\u7248\u672c\uff1a<br \/>\ninnotop\u00a0 Ver 1.12.0<br \/>\n\u6e90\u7801\u5b89\u88c5\uff1a<\/p>\n<pre>yum install -y perl-DBD-MySQL\ncd innotop\/\nperl Makefile.PL\nmake\nmake install\n<\/pre>\n<p>\u4f7f\u7528\u65b9\u6cd5\uff1a<br \/>\ninnotop \u7684\u53c2\u6570\u4e0emysql\u5ba2\u6237\u7aef\u7684\u53c2\u6570\u76f8\u4f3c\uff0c\u4f7f\u7528\u8d77\u6765\u4e5f\u5f88\u65b9\u4fbf\uff0c\u6267\u884cinnotop &#8211;help \u53ef\u4ee5\u67e5\u770b\u5b83\u7684\u5e2e\u52a9\u4fe1\u606f\uff0c\u5982\u4e0b\uff1a<\/p>\n<pre>[root@localhost innotop]# innotop --help\nUsage: innotop &lt;options&gt; &lt;innodb-status-file&gt;\n\u00a0\u00a0--askpass\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Prompt for a password when connecting to MySQL\n\u00a0\u00a0--[no]color\u00a0\u00a0\u00a0-C\u00a0\u00a0\u00a0Use terminal coloring (default)\n\u00a0\u00a0--config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-c\u00a0\u00a0\u00a0Config file to read\n\u00a0\u00a0--count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Number of updates before exiting\n\u00a0\u00a0--delay\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-d\u00a0\u00a0\u00a0Delay between updates in seconds\n\u00a0\u00a0--help\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Show this help message\n\u00a0\u00a0--host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-h\u00a0\u00a0\u00a0Connect to host\n\u00a0\u00a0--[no]inc\u00a0\u00a0\u00a0\u00a0\u00a0-i\u00a0\u00a0\u00a0Measure incremental differences\n\u00a0\u00a0--mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-m\u00a0\u00a0\u00a0Operating mode to start in\n\u00a0\u00a0--nonint\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-n\u00a0\u00a0\u00a0Non-interactive, output tab-separated fields\n\u00a0\u00a0--password\u00a0\u00a0\u00a0\u00a0-p\u00a0\u00a0\u00a0Password to use for connection\n\u00a0\u00a0--port\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-P\u00a0\u00a0\u00a0Port number to use for connection\n\u00a0\u00a0--skipcentral -s\u00a0\u00a0\u00a0Skip reading the central configuration file\n\u00a0\u00a0--socket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-S\u00a0\u00a0\u00a0MySQL socket to use for connection\n\u00a0\u00a0--spark\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Length of status sparkline (default 10)\n\u00a0\u00a0--timestamp\u00a0\u00a0\u00a0-t\u00a0\u00a0\u00a0Print timestamp in -n mode (1: per iter; 2: per\u00a0\u00a0line)\n\u00a0\u00a0--user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-u\u00a0\u00a0\u00a0User for login if not current user\n\u00a0\u00a0--version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Output version information and exit\n\u00a0\u00a0--write\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-w\u00a0\u00a0\u00a0Write running configuration into home directory if no\u00a0\u00a0config files were loaded\ninnotop is a MySQL and InnoDB transaction\/status monitor, like \\'top\\' for\nMySQL.\u00a0\u00a0It displays queries, InnoDB transactions, lock waits, deadlocks,\nforeign key errors, open tables, replication status, buffer information,\nrow operations, logs, I\/O operations, load graph, and more.\u00a0\u00a0You can\nmonitor many servers at once with innotop.\n<\/pre>\n<p>\u4f7f\u7528\u793a\u4f8b\uff1a<br \/>\ninnotop -h 127.0.0.1 -u admin -p\\&#8217;123456\\&#8217;<br \/>\n\u8fdb\u5165\u7ec8\u7aef\u547d\u4ee4\u884c\u6a21\u5f0f\u540e\uff0c\u6309?\u952e\uff0c\u663e\u793a\u5feb\u6377\u547d\u4ee4\u9009\u9879\uff0c\u901a\u8fc7\u8fd9\u4e9b\u5feb\u6377\u952e\u80fd\u591f\u5207\u6362\u5230\u4e0d\u540c\u7684\u6a21\u5f0f\uff0c\u663e\u793a\u4e0d\u540c\u7684\u76d1\u63a7\u6307\u6807\uff0c\u6bd4\u5982InnoDB\u9501\u7b49\u5f85\uff0cInnoDB\u6b7b\u9501\uff0c\u6267\u884c\u7684\u547d\u4ee4\u6c47\u603b\uff0c\u6253\u5f00\u7684\u8868\uff0c\u590d\u5236\u72b6\u6001\u7b49\u7b49\u3002<\/p>\n<pre>[RO] Dashboard (? for help)\nSwitch to a different mode:\n\u00a0\u00a0\u00a0A\u00a0\u00a0Dashboard\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0I\u00a0\u00a0InnoDB I\/O Info\u00a0\u00a0\u00a0\u00a0\u00a0Q\u00a0\u00a0Query List\n\u00a0\u00a0\u00a0B\u00a0\u00a0InnoDB Buffers\u00a0\u00a0\u00a0\u00a0K\u00a0\u00a0InnoDB Lock Waits\u00a0\u00a0\u00a0R\u00a0\u00a0InnoDB Row Ops\n\u00a0\u00a0\u00a0C\u00a0\u00a0Command Summary\u00a0\u00a0\u00a0L\u00a0\u00a0Locks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0S\u00a0\u00a0Variables &amp; Status\n\u00a0\u00a0\u00a0D\u00a0\u00a0InnoDB Deadlocks\u00a0\u00a0M\u00a0\u00a0Replication Status\u00a0\u00a0T\u00a0\u00a0InnoDB Txns\n\u00a0\u00a0\u00a0F\u00a0\u00a0InnoDB FK Err\u00a0\u00a0\u00a0\u00a0\u00a0O\u00a0\u00a0Open Tables\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0U\u00a0\u00a0User Statistics\nActions:\n\u00a0\u00a0\u00a0d\u00a0\u00a0Change refresh interval\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0q\u00a0\u00a0Quit innotop\n\u00a0\u00a0\u00a0k\u00a0\u00a0Kill a query\\'s connection\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0r\u00a0\u00a0Reverse sort order\n\u00a0\u00a0\u00a0n\u00a0\u00a0Switch to the next connection\u00a0\u00a0s\u00a0\u00a0Choose sort column\n\u00a0\u00a0\u00a0p\u00a0\u00a0Pause innotop\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0x\u00a0\u00a0Kill a query\nOther:\nTAB\u00a0\u00a0Switch to the next server group\u00a0\u00a0\u00a0\/\u00a0\u00a0Quickly filter what you see\n\u00a0\u00a0\u00a0!\u00a0\u00a0Show license and warranty\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a0\u00a0Toggle aggregation\n\u00a0\u00a0\u00a0#\u00a0\u00a0Select\/create server groups\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0@\u00a0\u00a0Select\/create server\u00a0\u00a0connections\n\u00a0\u00a0\u00a0$\u00a0\u00a0Edit configuration settings\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Clear quick-filters\nPress any key to continue\n<\/pre>\n<p>\u5e38\u7528\u7684\u5feb\u6377\u952e\u793a\u4f8b\uff1aC\uff08Command Summary\uff09<br \/>\n<img title=\\\"innotop\\\" src=\\\"https:\/\/github.com\/zxb4221\/blog\/blob\/master\/src\/pic\/innotop_1.png?raw=true\\\" \/><br \/>\nB\uff08InnoDB Buffers\uff09<br \/>\n<img title=\\\"innotop\\\" src=\\\"https:\/\/github.com\/zxb4221\/blog\/blob\/master\/src\/pic\/innotop_2.png?raw=true\\\" \/><br \/>\nQ\uff08Query List\uff09<br \/>\n<img title=\\\"innotop\\\" src=\\\"https:\/\/github.com\/zxb4221\/blog\/blob\/master\/src\/pic\/innotop_3.png?raw=true\\\" \/><\/p>\n<h5>\u603b\u7ed3\uff1a<\/h5>\n<p>\u6574\u4f53\u6765\u770b\uff0cinnotop\u00a0\u5b89\u88c5\u4f7f\u7528\u90fd\u6bd4\u8f83\u7b80\u5355\u3001\u65b9\u4fbf\uff0c\u529f\u80fd\u4e5f\u5f88\u5f3a\u5927\uff0c\u6309\u6309\u5feb\u6377\u952e\u5c31\u80fd\u5207\u6362\u5230\u4e0d\u540c\u7684\u76d1\u63a7\u6a21\u5f0f\uff0c\u663e\u793a\u4e0d\u540c\u7684\u76d1\u63a7\u4fe1\u606f\uff0c\u5bf9\u4e8e\u6570\u636e\u5e93\u7ba1\u7406\u5458\u6765\u8bf4\uff0c\u7684\u786e\u662f\u4e00\u4e2a\u4e0d\u9519\u7684\u5de5\u4f5c\u52a9\u624b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>innotop\u662f\u4e00\u4e2a\u975e\u5e38\u597d\u7528\u7684\u5f00\u6e90MySQL\u547d\u4ee4\u884c\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u5f00\u53d1\uff0c\u62e5\u6709\u5f88\u591a\u7684\u76d1\u63a7\u6a21\u5f0f\u548c\u9009\u9879\uff0c\u80fd\u591f\u76d1 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=1804\"> <span class=\"screen-reader-text\">MySQL\u76d1\u63a7\u5de5\u5177innotop<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90,88],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"innotop\u662f\u4e00\u4e2a\u975e\u5e38\u597d\u7528\u7684\u5f00\u6e90MySQL\u547d\u4ee4\u884c\u76d1\u63a7\u5de5\u5177\uff0c\u4f7f\u7528Perl\u5f00\u53d1\uff0c\u62e5\u6709\u5f88\u591a\u7684\u76d1\u63a7\u6a21\u5f0f\u548c\u9009\u9879\uff0c\u80fd\u591f\u76d1&hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1804"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1804"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1804\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1804"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}