{"id":561339,"date":"2023-01-06T05:24:47","date_gmt":"2023-01-05T21:24:47","guid":{"rendered":"http:\/\/4563.org\/?p=561339"},"modified":"2023-01-06T05:24:47","modified_gmt":"2023-01-05T21:24:47","slug":"%e4%b8%ba%e4%bb%80%e4%b9%88%e9%98%bf%e9%87%8c%e4%ba%91%e7%9a%84io%e6%af%94%e6%96%af%e5%b7%b4%e8%be%be%e6%85%a2%e9%82%a3%e4%b9%88%e5%a4%9a%ef%bc%8c%e4%bd%86%e6%98%afmysql%e6%89%a7%e8%a1%8c%e5%8d%b4","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=561339","title":{"rendered":"\u4e3a\u4ec0\u4e48\u963f\u91cc\u4e91\u7684IO\u6bd4\u65af\u5df4\u8fbe\u6162\u90a3\u4e48\u591a\uff0c\u4f46\u662fmysql\u6267\u884c\u5374\u66f4\u5feb\uff1f"},"content":{"rendered":"\n<p>  \t\t\t\t\t<strong>\u5b59\u7b11\u5ddd<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3>\u4e3a\u4ec0\u4e48\u963f\u91cc\u4e91\u7684IO\u6bd4\u65af\u5df4\u8fbe\u6162\u90a3\u4e48\u591a\uff0c\u4f46\u662fmysql\u6267\u884c\u5374\u66f4\u5feb\uff1f<\/h3>\n<p>  \t\t\u4e3a\u4ec0\u4e48\u963f\u91cc\u4e91\u7684IO\u6bd4\u65af\u5df4\u8fbe\u6162\u90a3\u4e48\u591a\uff0c\u4f46\u662fmysql\u5b9e\u9645\u6027\u80fd\u5374\u66f4\u5feb\uff1f<\/p>\n<p>  \u521a\u521a\u6d4b\u8bd5\u4e86\u4e00\u4e0b\uff0c\u4e24\u53f0\u673a\u5668\u90fd\u5b89\u88c5mysql 5.7\uff0c\u5728\u7a7a\u6570\u636e\u5e93\u7684\u60c5\u51b5\u4e0b\u6267\u884c\u63d2\u5165(INSERT INTO)\u540c\u4e00\u6761\u6570\u636e\uff1a<br \/>  \u65af\u5df4\u8fbe\u5e73\u5747\u8981\u82b1\u8d39 0.02\u79d2\u5de6\u53f3\uff0c\u800c\u963f\u91cc\u4e91\u5374\u53ea\u89810.003\u79d2\u5de6\u53f3\u3002<br \/>  \u4f7f\u7528show profile\u770b\u4e86\u4e00\u4e0b\u65f6\u95f4\uff1a<br \/>  \u65af\u5df4\u8fbe\uff1aquery end\u65f6\u95f4\u82b1\u8d39\u5f88\u957f\uff0c\u898120\u6beb\u79d2\u5de6\u53f3\uff1a<br \/>  https:\/\/s2.loli.net\/2023\/01\/04\/ayH3X9IiJPcmFVb.png<\/p>\n<p>  \u963f\u91cc\u4e91\uff0c3ms\u5de6\u53f3\uff1a<br \/>  https:\/\/s2.loli.net\/2023\/01\/04\/usXq7GDKcLIwNM3.png<\/p>\n<p>  \u6709\u5927\u795e\u61c2\u8fd9\u4e2a\u539f\u56e0\u5417\uff1f<br \/>  \u57fa\u672c\u6bcf\u4e2a\u8fc7\u7a0b\u963f\u91cc\u4e91\u90fd\u6bd4\u65af\u5df4\u8fbe\u5feb\u4e00\u4e9b\uff0c\u8fd9\u4e0d\u79d1\u5b66\u554a\uff1f\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u6211y\u96f6kk<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u811a\u672c\u6d4b\u51fa\u6765IO\u90fd\u662f\u987a\u5e8f\u8bfb\u5199\uff0c\u4e91\u786c\u76d8\u666e\u904d\u90fd\u53ea\u7ed9120m\/s\u5de6\u53f3\uff0c\u4f46\u662fIOPS\/4k\u6027\u80fd\u662f\u5b9e\u6253\u5b9e\u7684SSD\u6c34\u5e73\uff0c\u57283000IOPS\u4e0a\u4e0b\u800c\u4e14\u5f88\u7a33\u5b9a\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>YorkZhao<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u963f\u91cc\u4e91\u8fd0\u7528\u7684\u81ea\u7814\u9ed1\u79d1\u6280 bla bla bla\u6253\u7834\u4e86\u56fd\u5916\u7684\u6280\u672f\u5784\u65ad \u5b9e\u73b0\u4e86xxxx<\/p>\n<p>  \u4e8b\u5b9e\u4e0a\uff1a<br \/>  \u963f\u91cc\u4e91\u865a\u62df\u9e21\u52a8\u4e86\u624b\u811a\uff0c\u5bf9mysql\u505a\u4e86\u4f18\u5316<br \/>  \u4e5f\u8bb8alisql\u4f1a\u66f4\u5feb\uff1f\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u5b59\u7b11\u5ddd<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\tYorkZhao \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2023-1-4 21:59<br \/>  \u963f\u91cc\u4e91\u8fd0\u7528\u7684\u81ea\u7814\u9ed1\u79d1\u6280 bla bla bla\u6253\u7834\u4e86\u56fd\u5916\u7684\u6280\u672f\u5784\u65ad \u5b9e\u73b0\u4e86xxxx<\/p>\n<p>  \u4e8b\u5b9e\u4e0a\uff1a<\/p>\n<p> \u65af\u5df4\u8fbe\u63d2\u5165\u4e00\u6761\u8bed\u53e5\u6709\u70b9\u592a\u6162\u4e86\uff0c\u963f\u91cc\u4e91\u5e94\u8be5\u662f\u6b63\u5e38\u901f\u5ea6\uff0c\u6211\u518d\u6d4b\u8bd5\u4e0b\u5176\u4ed6\u673a\u5668\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>ezezz<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u4f60\u7528\u4ed6\u4eec\u7684\u6570\u636e\u5e93\u670d\u52a1 \u4f60\u4f1a\u53d1\u73b0\u66f4\u5feb \u6bd4\u81ea\u5efa\u7684\u5757\u51e0\u500d\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u5b59\u7b11\u5ddd<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u6211y\u96f6kk \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2023-1-4 21:59<br \/>  \u811a\u672c\u6d4b\u51fa\u6765IO\u90fd\u662f\u987a\u5e8f\u8bfb\u5199\uff0c\u4e91\u786c\u76d8\u666e\u904d\u90fd\u53ea\u7ed9120m\/s\u5de6\u53f3\uff0c\u4f46\u662fIOPS\/4k\u6027\u80fd\u662f\u5b9e\u6253\u5b9e\u7684SSD\u6c34\u5e73\uff0c\u57283000IOPS\u4e0a &#8230;<\/p>\n<p> \u6211\u624b\u91cc\u8fd9\u53f0 \u65af\u5df4\u8fbe\u7684IOPS\u662f35K\u5de6\u53f3\uff0c\u963f\u91cc\u4e91\u8f7b\u91cf\u624d1K\u5de6\u53f3<br \/>  \u4f46\u5b9e\u9645\u5c31\u662f\u963f\u91cc\u4e91\u6570\u636e\u5e93\u6027\u80fd\u5feb\u5f88\u591a\uff0c\u79bb\u5927\u8c31\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>waterscud<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u4e00\u6761\u5199\u5165\u51fa\u6765\u7684\u6570\u636e\u771f\u7684\u53ef\u9760\u5417\uff1f \u6279\u91cf\u5199\u5165\u554a\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u5b59\u7b11\u5ddd<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\twaterscud \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2023-1-4 22:06<br \/>  \u4e00\u6761\u5199\u5165\u51fa\u6765\u7684\u6570\u636e\u771f\u7684\u53ef\u9760\u5417\uff1f \u6279\u91cf\u5199\u5165\u554a<\/p>\n<p> \u6279\u91cf\u5341\u4e07\u6761\uff0c\u6162\u5341\u500d\u5de6\u53f3\uff0c\u8fd9\u624d\u770b\u6bcf\u4e00\u6761\u54ea\u513f\u51fa\u95ee\u9898\u4e86\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u864e\u8c37<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t \u672c\u5e16\u6700\u540e\u7531 \u864e\u8c37 \u4e8e 2023-1-4 23:02 \u7f16\u8f91 <\/p>\n<p> https:\/\/img.erpweb.eu.org\/imgs\/2023\/01\/488e6be1182a5d08.png<\/p>\n<p>  \u6211\u7684\u65af\u5df4\u8fbe 3g \u3002\u3002\u3002mysql5.7<\/p>\n<p>  mysql8.0 \u7684\u9700\u89814g\u5185\u5b58\u53ca\u4ee5\u4e0a\t\t\t\t<\/p>\n<p>  \t\t\t\t\t<strong>\u5b59\u7b11\u5ddd<\/strong>  \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : \t<\/p>\n<h3><\/h3>\n<p>  \t\t\u864e\u8c37 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2023-1-4 23:00<br \/>  \u6211\u7684\u65af\u5df4\u8fbe 3g \u3002\u3002\u3002mysql5.7<\/p>\n<p>  mysql8.0 \u7684\u9700\u89814g\u5185\u5b58\u53ca\u4ee5\u4e0a<\/p>\n<p> \u8bf7\u95ee\u662finsert into\u5417\uff1f\t\t\t  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b59\u7b11\u5ddd \u5927\u4f6c\u6709\u8bdd\u8bf4 : \u4e3a\u4ec0\u4e48\u963f\u91cc&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/561339"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=561339"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/561339\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=561339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=561339"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=561339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}