{"id":247,"date":"2016-12-10T16:59:32","date_gmt":"2016-12-10T08:59:32","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=247"},"modified":"2016-12-10T16:59:32","modified_gmt":"2016-12-10T08:59:32","slug":"mysql%e5%b7%a5%e5%85%b7%e6%b1%87%e6%80%bb","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=247","title":{"rendered":"MySQL\u5de5\u5177\u6c47\u603b"},"content":{"rendered":"<blockquote><p>\u6536\u5f55\u4e86MySQL\u76f8\u5173\u6709\u7528\u7684\u5de5\u5177\u3002\u5de5\u5177\u5305\u542b\uff1a\u6027\u80fd\u6d4b\u8bd5\uff0c\u72b6\u6001\u5206\u6790\uff0cSQL\u8def\u7531\u7b49\u65b9\u9762<\/p><\/blockquote>\n<p>\u672c\u6587\u6c47\u603b\u4e86\u548cMySQL\u8fd0\u7ef4\u5f00\u53d1\u76f8\u5173\u7684\u6240\u6709\u5de5\u5177\uff0c\u5e76\u4f1a\u6301\u7eed\u66f4\u65b0<\/p>\n<h2 id=\"section\">\u5de5\u5177\u5957\u4ef6\u96c6<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.percona.com\/software\/percona-toolkit\">percona-toolkit<\/a><\/li>\n<li><a href=\"http:\/\/code.openark.org\/forge\/openark-kit\">oak-toolkit<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/MarkLeith\/dbahelper\">ps-helper<\/a>\uff08performance schema \u5de5\u5177\u51fd\u6570\u96c6\uff09<\/li>\n<\/ul>\n<h2 id=\"mysql-\">MySQL \u5b9e\u65f6\u72b6\u6001\u5206\u6790<\/h2>\n<ul>\n<li><a href=\"https:\/\/code.google.com\/p\/innotop\/\">innotop<\/a><\/li>\n<li><a href=\"http:\/\/code.taobao.org\/p\/orzdba\/src\/trunk\/orzdba\">orzdba<\/a><\/li>\n<li><a href=\"http:\/\/jeremy.zawodny.com\/mysql\/mytop\/\">mytop<\/a><\/li>\n<li><a href=\"https:\/\/sourceware.org\/systemtap\/examples\/\">systemtap\u5de5\u5177\u793a\u4f8b\u96c6<\/a><\/li>\n<\/ul>\n<h2 id=\"mysql\">mysql\u5ba2\u6237\u7aef&amp;\u5f00\u53d1\u5de5\u5177<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.mysql.com\/products\/workbench\/\">MySQL Workbench<\/a><\/li>\n<li><a href=\"https:\/\/www.webyog.com\/\">SQLyog<\/a><\/li>\n<li><a href=\"http:\/\/www.adminer.org\/\">Adminer<\/a><\/li>\n<li><a href=\"http:\/\/sourceforge.net\/projects\/myquery\/\">MyQuery<\/a><\/li>\n<li><a href=\"http:\/\/www.upscene.com\/products.hopper.index.php\">Hopper\uff08\u5b58\u50a8\u8fc7\u7a0b\u8c03\u8bd5\u5de5\u5177\uff09<\/a><\/li>\n<\/ul>\n<h2 id=\"mysql-1\">MySQL\u6027\u80fd\u76d1\u63a7<\/h2>\n<ul>\n<li><a href=\"https:\/\/github.com\/spilgames\/mysql-statsd\">mysql-statsd<\/a><\/li>\n<li><a href=\"http:\/\/www.oschina.net\/p\/nethogs\/\">nethogs<\/a><\/li>\n<\/ul>\n<h2 id=\"mysql-2\">MySQL\u6027\u80fd\u6d4b\u8bd5\u5de5\u5177<\/h2>\n<ul>\n<li><a href=\"https:\/\/launchpad.net\/sysbench\">sysbench<\/a><\/li>\n<li><a href=\"https:\/\/code.launchpad.net\/~percona-dev\/perconatools\/tpcc-mysql\">tpcc-mysql<\/a><\/li>\n<li><a href=\"http:\/\/sourceforge.net\/projects\/osdldbt\/files\/dbt2\/\">dbt2<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/facebook\/linkbench\">LinkBench<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/tmcallaghan\/iibench-mysql\">iibench<\/a> Indexed Insertion Benchmark<\/li>\n<\/ul>\n<h2 id=\"data-generator\">data generator<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.generatedata.com\/\">\u6d4b\u8bd5\u6570\u636e\u751f\u6210<\/a><\/li>\n<li><a href=\"http:\/\/www.openstreetmap.org\/\">\u5730\u7406\u6570\u636e\u751f\u6210<\/a><\/li>\n<\/ul>\n<h2 id=\"section-1\">\u6570\u636e\u8def\u7531\u4e2d\u95f4\u4ef6<\/h2>\n<ul>\n<li><a href=\"http:\/\/dev.mysql.com\/downloads\/mysql-proxy\/\">mysql-proxy<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/Qihoo360\/Atlas\">Atlas<\/a><\/li>\n<li><a href=\"https:\/\/code.google.com\/p\/opencloudb\/\">mycat<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/SkySQL\/MaxScale\">MaxScale:<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/codership\/glb\">GLB<\/a><\/li>\n<li><a href=\"http:\/\/www.scalearc.com\/\">ScaleArc<\/a><\/li>\n<\/ul>\n<h2 id=\"section-2\">\u6570\u636e\u5e93\u7248\u672c\u7ba1\u7406<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.liquibase.org\/\">liquibase<\/a><\/li>\n<\/ul>\n<h2 id=\"mysql-connector\">MySQL Connector<\/h2>\n<ul>\n<li><a href=\"http:\/\/libattachsql.org\/\">libAttachSQL<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u6536\u5f55\u4e86MySQL\u76f8\u5173\u6709\u7528\u7684\u5de5\u5177\u3002\u5de5\u5177\u5305\u542b\uff1a\u6027\u80fd\u6d4b\u8bd5\uff0c\u72b6\u6001\u5206\u6790\uff0cSQL\u8def\u7531\u7b49\u65b9\u9762 &#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=247\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-247","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=247"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions\/248"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}