{"id":2364,"date":"2015-12-01T22:27:51","date_gmt":"2015-12-01T13:27:51","guid":{"rendered":"http:\/\/tech.akat.info\/?p=2364"},"modified":"2015-12-01T22:27:51","modified_gmt":"2015-12-01T13:27:51","slug":"mysql-performance-tips","status":"publish","type":"post","link":"https:\/\/tech.akat.info\/?p=2364","title":{"rendered":"MySQL performance tips"},"content":{"rendered":"<p><a href=\"https:\/\/www.percona.com\/blog\/2013\/12\/07\/linux-performance-tuning-tips-mysql\/\">Linux performance tuning tips for MySQL<\/a>\u3092\u8aad\u3093\u3067\u30e1\u30e2\u03c6(\u30fb\u03c9\u30fb )<\/p>\n<p>MySQL\u306e\u6027\u80fd\u3092\u9ad8\u3081\u308bLinux\u8a2d\u5b9a\u306b\u3064\u3044\u3066<\/p>\n<h2>Filesystem<\/h2>\n<p>\u30fbext4\u306enoatime\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059\u308b<br \/>\n\u30fb\/sys\/block\/vda\/queue\/scheduler \u3067noop\u304bdeadline\u3092\u5229\u7528\u3059\u308b<\/p>\n<h2>memory<\/h2>\n<p>\u30fb\/proc\/sys\/vm\/swappiness \u3092 0 \u306b<br \/>\n\u3000\/etc\/sysctl.conf \u306b &#8220;vm.swappiness = 0&#8221; \u3092\u8ffd\u52a0<br \/>\n\u30fbnumactl &#8211;interleave=all (NUMA:\u4e26\u5217\u8a08\u7b97\u6642\u306bCPU\u3068\u30e1\u30e2\u30ea\u306e\u5272\u308a\u5f53\u3066\u65b9\u3092\u6c7a\u3081\u308b)<br \/>\n\u3000( innodb_flush_method=O_DIRECT \u3082\u5fd8\u308c\u306a\u3044\u3053\u3068)<\/p>\n<h2>CPU<\/h2>\n<p>\u30fb\u30d1\u30ef\u30fc\u30bb\u30fc\u30d6\u30e2\u30fc\u30c9\u304c\u7121\u52b9\u3068\u306a\u3063\u3066\u3044\u308b\u3053\u3068<br \/>\n\u3000(\/sys\/devices\/system\/cpu\/cpu0\/cpufreq\/scaling_governorand \u304c ondemand \u306b\u306a\u3063\u3066\u3044\u306a\u3044\u3053\u3068)<\/p>\n<h1>\u53c2\u8003URL<\/h1>\n<p><a href=\"https:\/\/www.percona.com\/blog\/2013\/12\/07\/linux-performance-tuning-tips-mysql\/\">Linux performance tuning tips for MySQL<\/a><br \/>\n<a href=\"http:\/\/blog.livedoor.jp\/rootan2007\/archives\/51319459.html\">\u4e26\u5217\u8a08\u7b97\u306e\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3000\uff0d NUMA \uff0d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Linux performance tuning tips for MySQL\u3092\u8aad\u3093\u3067\u30e1\u30e2\u03c6(\u30fb\u03c9\u30fb ) MySQL\u306e\u6027\u80fd\u3092\u9ad8\u3081\u308bLinux\u8a2d\u5b9a\u306b\u3064\u3044\u3066 Filesystem \u30fbext4\u306enoatime\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[14],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2364"}],"collection":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2364"}],"version-history":[{"count":1,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2364\/revisions"}],"predecessor-version":[{"id":2365,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2364\/revisions\/2365"}],"wp:attachment":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}