{"id":5314,"date":"2015-12-11T12:34:59","date_gmt":"2015-12-11T03:34:59","guid":{"rendered":"http:\/\/www.skyarch.net\/blog\/?p=5314"},"modified":"2015-12-11T12:34:59","modified_gmt":"2015-12-11T03:34:59","slug":"mysql-%e3%83%91%e3%83%a9%e3%83%a1%e3%83%bc%e3%82%bf%e3%83%81%e3%83%a5%e3%83%bc%e3%83%8b%e3%83%b3%e3%82%b0","status":"publish","type":"post","link":"https:\/\/www.skyarch.net\/blog\/mysql-%e3%83%91%e3%83%a9%e3%83%a1%e3%83%bc%e3%82%bf%e3%83%81%e3%83%a5%e3%83%bc%e3%83%8b%e3%83%b3%e3%82%b0\/","title":{"rendered":"MySQL \u30d1\u30e9\u30e1\u30fc\u30bf\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0"},"content":{"rendered":"

\u3088\u304f\u5206\u304b\u3089\u306a\u3044\u30d1\u30e9\u30e1\u30fc\u30bf\u3002
\n\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3057\u305f\u304f\u3066\u3082\u3000\u306a\u304b\u306a\u304b\u624b\u304c\u51fa\u305b\u306a\u3044\u3067\u3059\u3088\u306d\u3002
\n\u305d\u3093\u306a\u6642\u3001\u6539\u5584\u3059\u3079\u304d\u63a8\u5968\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6559\u3048\u3066\u304f\u308c\u308b\u306e\u304c\u3001\u300cmysqltuner\u300d<\/p>\n

\u2460\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9
\nMySQLTuner\u3092\u4e0b\u8a18\u304b\u3089\u53d6\u5f97<\/p>\n

http:\/\/mysqltuner.com\/<\/p>\n

\u2461\u3000\u5b9f\u884c
\nperl .\/mysqltuner.pl<\/p>\n

mysqltuner\u306e\u5b9f\u884c\u7d50\u679c\u306e\u300cRecommendations\u300d\u4ee5\u964d\u306b\u6ce8\u76ee\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n

\u3042\u304f\u307e\u3067\u3082\u6539\u5584\u3057\u305f\u65b9\u304c\u3044\u3044\u3088\u3063\u3066\u3044\u3046\u63a8\u5968\u30d1\u30e9\u30e1\u30fc\u30bf\u7b49\u3092\u6559\u3048\u3066\u304f\u308c\u308b\u3082\u306e\u306a\u306e\u3067
\n\u30d1\u30e9\u30e1\u30fc\u30bf\u5024\u306b\u3064\u3044\u3066\u306f\u3001\u3061\u3083\u3093\u3068\u8003\u3048\u3066\u8a2d\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n

 <\/p>\n

\u7279\u306b\u30e1\u30e2\u30ea\u95a2\u9023\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u306f\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff01<\/h1>\n

\u203b\u3000\u30b5\u30fc\u30d0\u3067\u4f7f\u7528\u3067\u304d\u308b\u30e1\u30e2\u30ea\u3092\u3061\u3083\u3093\u3068\u8003\u3048\u3066\u3001\u00a0\u8a2d\u5b9a\u3057\u3066\u307e\u3057\u3087\u3046\uff01<\/strong><\/p>\n

 <\/p>\n

\u306a\u304a\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u4fee\u6b63\u306b\u3064\u3044\u3066\u306f\u3001<\/h1>\n

\u3054\u81ea\u8eab\u306b\u304a\u3044\u3066\u8cac\u4efb\u3092\u3082\u3063\u3066<\/h1>\n

\u3054\u5224\u65ad\u30fb\u3054\u5bfe\u5fdc\u304f\u3060\u3055\u3044\u3002<\/h1>\n

 <\/p>\n

############################################################
\nmysqltuner.pl\u306e\u5b9f\u884c\u7d50\u679c\u4f8b
\n############################################################
\n>> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
\n>> Bug reports, feature requests, and downloads at http:\/\/mysqltuner.com\/
\n>> Run with '--help' for additional options and output filtering
\nPlease enter your MySQL administrative login: root
\nPlease enter your MySQL administrative password:
\n[OK] Currently running supported MySQL version 5.5.34-log
\n[OK] Operating on 64-bit architecture<\/p>\n

-------- Storage Engine Statistics -------------------------------------------
\n[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
\n[--] Data in MyISAM tables: 86M (Tables: 24)
\n[--] Data in InnoDB tables: 16K (Tables: 1)
\n[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
\n[!!] Total fragmented tables: 6<\/p>\n

-------- Security Recommendations -------------------------------------------
\n[OK] All database users have passwords assigned<\/p>\n

-------- Performance Metrics -------------------------------------------------
\n[--] Up for: 12m 20s (105K q [142.505 qps], 3K conn, TX: 642M, RX: 9M)
\n[--] Reads \/ Writes: 20% \/ 80%
\n[--] Total buffers: 711.0M global + 1.1M per thread (3002 max threads)
\n[OK] Maximum possible memory usage: 4.0G (6% of installed RAM)
\n[OK] Slow queries: 0% (0\/105K)
\n[OK] Highest usage of available connections: 27% (829\/3002)
\n[OK] Key buffer size \/ total MyISAM indexes: 217.0M\/4.9M
\n[!!] Key buffer hit rate: 77.5% (14K cached \/ 3K reads)
\n[OK] Query cache efficiency: 98.2% (84K cached \/ 86K selects)
\n[OK] Query cache prunes per day: 0
\n[OK] Sorts requiring temporary tables: 0% (0 temp sorts \/ 21 sorts)
\n[!!] Joins performed without indexes: 7
\n[OK] Temporary tables created on disk: 0% (4 on disk \/ 1K total)
\n[OK] Thread cache hit rate: 73% (829 created \/ 3K connections)
\n[!!] Table cache hit rate: 10% (494 open \/ 4K opened)
\n[OK] Open file limit used: 3% (498\/15K)
\n[!!] Table locks acquired immediately: 26%
\n[OK] InnoDB buffer pool \/ data size: 435.0M\/16.0K
\n[OK] InnoDB log waits: 0
\n-------- Recommendations -----------------------------------------------------
\nGeneral recommendations:
\nRun OPTIMIZE TABLE to defragment tables for better performance
\nMySQL started within last 24 hours - recommendations may be inaccurate
\nAdjust your join queries to always utilize indexes
\nIncrease table_cache gradually to avoid file descriptor limits
\nRead this before increasing table_cache over 64: http:\/\/bit.ly\/1mi7c4C
\nOptimize queries and\/or use InnoDB to reduce lock wait
\nVariables to adjust:
\njoin_buffer_size (> 128.0K, or always use indexes with joins)
\ntable_cache (> 456)
\n############################################################<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

\u3088\u304f\u5206\u304b\u3089\u306a\u3044\u30d1\u30e9\u30e1\u30fc\u30bf\u3002 \u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3057\u305f\u304f\u3066\u3082\u3000\u306a\u304b\u306a\u304b\u624b\u304c\u51fa\u305b\u306a\u3044\u3067\u3059\u3088\u306d\u3002 \u305d\u3093\u306a\u6642\u3001\u6539\u5584\u3059\u3079\u304d\u63a8\u5968\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6559\u3048\u3066\u304f\u308c\u308b\u306e\u304c\u3001\u300cmysqltuner\u300d \u2460\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9 MySQLTuner\u3092\u4e0b\u8a18\u304b\u3089\u53d6\u5f97 h…<\/p>\n","protected":false},"author":1,"featured_media":2394,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"5314","footnotes":""},"categories":[24],"tags":[],"class_list":{"0":"post-5314","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"ja"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/comments?post=5314"}],"version-history":[{"count":16,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5314\/revisions"}],"predecessor-version":[{"id":5360,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5314\/revisions\/5360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media\/2394"}],"wp:attachment":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media?parent=5314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/categories?post=5314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/tags?post=5314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}