アドバイザ・システムは、サーバの状態変数を分析することにより、ふさわしいと思われるサーバ変数の調整方法を提供するものです。

このシステムは、単純な計算を基にして経験則によって調整方法を提供するため、お使いのシステムに必ずしも当てはまるものではないことに注意してください。

設定を変更する前に、（ドキュメントを読んで）変更内容と変更箇所を元に戻す方法を確認しておいてください。間違ったチューニングは、パフォーマンスに非常に悪影響を与える可能性があります。

システムチューニングの最善のやり方は、一度に行う変更を 1 箇所のみにすることです。変更の度に、監視やベンチマークを行い、明確な改善が測定されなかった場合は変更した箇所を元に戻します。

{"parse":{"errors":[]},"run":{"fired":[{"name":"\u9577\u3044\u30af\u30a8\u30ea\u6642\u9593","formula":"long_query_time","test":"value >= 10","issue":"{long_query_time} \u306f 10 \u79d2\u4ee5\u4e0a\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u5f93\u3063\u3066\u300110 \u79d2\u3092\u8d85\u3048\u308b\u3082\u306e\u304c\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u3068\u3057\u3066\u30ed\u30b0\u306b\u8a18\u9332\u3055\u308c\u307e\u3059\u3002","recommendation":"\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u3001<a href=\"server_variables.php?filter=long_query_time&amp;lang=ja\">long_query_time<\/a> \u3092\u4f4e\u3044\u5024\u306b\u8a2d\u5b9a\u3059\u308b\u307b\u3046\u304c\u3044\u3044\u3067\u3057\u3087\u3046\u3002\u901a\u5e38\u30011\uff5e5 \u79d2\u306e\u5024\u304c\u63a8\u5968\u3055\u308c\u307e\u3059\u3002","justification":"long_query_time \u306f\u73fe\u5728 10 \u79d2\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002","id":"Long query time"},{"name":"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0","precondition":"PMA_MYSQL_INT_VERSION >= 50600","formula":"slow_query_log","test":"value == 'OFF'","issue":"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u304c\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=slow_query_log&amp;lang=ja\">slow_query_log<\/a> \u3092\u300cON\u300d\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u304c\u6709\u52b9\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u60aa\u3044\u30af\u30a8\u30ea\u306e\u5207\u308a\u5206\u3051\u306b\u5f79\u7acb\u3064\u3067\u3057\u3087\u3046\u3002","justification":"slow_query_log \u304c\u300cOFF\u300d\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059","id":"Slow query logging"},{"name":"\u884c\u306e\u30bd\u30fc\u30c8","formula":"Sort_rows \/ Uptime","test":"value * 60 >= 1","issue":"\u30bd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u884c\u304c\u591a\u304f\u5b58\u5728\u3057\u307e\u3059\u3002","recommendation":"\u591a\u304f\u306e\u884c\u304c\u30bd\u30fc\u30c8\u3055\u308c\u3066\u3044\u3066\u3082\u7279\u306b\u554f\u984c\u306a\u3044\u306e\u3067\u3042\u308c\u3070\u3001\u591a\u304f\u306e\u30bd\u30fc\u30c8\u3092\u5fc5\u8981\u3068\u3059\u308b\u30af\u30a8\u30ea\u306b\u5bfe\u3057\u3066\u3001ORDER BY \u7bc0\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u3042\u308b\u30ab\u30e9\u30e0\u3092\u4f7f\u3046\u306e\u3092\u691c\u8a0e\u3059\u308b\u7a0b\u5ea6\u3067\u3044\u3044\u3067\u3057\u3087\u3046\u3002\u305d\u306e\u30af\u30a8\u30ea\u7d50\u679c\u306e\u30bd\u30fc\u30c8\u306f\u3001\u3068\u3066\u3082\u901f\u304f\u306a\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002","justification":"\u30bd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u884c\u306e\u5e73\u5747\uff1a4.8 \/ \u5206","id":"Sort rows"},{"name":"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u7d50\u5408\u306e\u5272\u5408","formula":"(Select_range_check + Select_scan + Select_full_join) \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u7d50\u5408\u304c\u591a\u304f\u3042\u308a\u307e\u3059\u3002","recommendation":"\u3053\u308c\u306f\u7d50\u5408\u306b\u304a\u3044\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u5168\u30b9\u30ad\u30e3\u30f3\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u7d50\u5408\u6761\u4ef6\u306b\u5408\u3063\u305f\u30ab\u30e9\u30e0\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3067\u3001\u30c6\u30fc\u30d6\u30eb\u7d50\u5408\u306e\u30b9\u30d4\u30fc\u30c9\u306f\u5927\u5e45\u306b\u4e0a\u304c\u308b\u3067\u3057\u3087\u3046\u3002","justification":"\u30c6\u30fc\u30d6\u30eb\u7d50\u5408\u306e\u5e73\u5747\uff1a9.7 \/ \u5206\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of joins without indexes"},{"name":"\u6700\u521d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a8\u30f3\u30c8\u30ea\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408","formula":"Handler_read_first \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u6700\u521d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a8\u30f3\u30c8\u30ea\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"\u3053\u308c\u306f\u3001\u901a\u5e38\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u304c\u983b\u7e41\u306b\u884c\u308f\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30e3\u30f3\u3088\u308a\u306f\u901f\u3044\u3067\u3059\u304c\u3001\u5927\u304d\u306a\u30c6\u30fc\u30d6\u30eb\u3067\u306f CPU \u30ea\u30bd\u30fc\u30b9\u3092\u591a\u304f\u5fc5\u8981\u3068\u3057\u307e\u3059\u3002\u3053\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066 UPDATE \u3084 DELETE \u304c\u591a\u304f\u884c\u308f\u308c\u305f\u307e\u305f\u306f\u884c\u308f\u308c\u3066\u3044\u308b\u306e\u3067\u3042\u308c\u3070\u3001\u300cOPTIMIZE TABLE\u300d\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u306e\u6e1b\u5c11\u3084\u30b9\u30ad\u30e3\u30f3\u30b9\u30d4\u30fc\u30c9\u306e\u4e0a\u6607\u304c\u898b\u8fbc\u3081\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u307e\u305f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u306f\u3001\u30af\u30a8\u30ea\u3092\u66f8\u304d\u76f4\u3059\u3053\u3068\u3067\u3082\u6e1b\u3089\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002","justification":"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30b9\u30ad\u30e3\u30f3\u306e\u5e73\u5747\uff1a13.42 \/ \u6642\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of reading first index entry"},{"name":"\u6c7a\u307e\u3063\u305f\u4f4d\u7f6e\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408","formula":"Handler_read_rnd \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u6c7a\u307e\u3063\u305f\u4f4d\u7f6e\u306e\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"\u591a\u304f\u306e\u30af\u30a8\u30ea\u304c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u7d50\u5408\u30af\u30a8\u30ea\u3092\u542b\u3093\u3067\u3044\u308b\u305f\u3081\u306b\u3001\u7d50\u679c\u306e\u30bd\u30fc\u30c8\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u3001\u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u4e21\u65b9\u3092\u5fc5\u8981\u3068\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u8a72\u5f53\u7b87\u6240\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u6c7a\u307e\u3063\u305f\u4f4d\u7f6e\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408\u306e\u5e73\u5747\uff1a4.71 \/ \u5206\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of reading fixed position"},{"name":"\u30c6\u30fc\u30d6\u30eb\u306e\u6b21\u884c\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408","formula":"Handler_read_rnd_next \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u30c6\u30fc\u30d6\u30eb\u306e\u6b21\u884c\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"\u591a\u304f\u306e\u30af\u30a8\u30ea\u304c\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u30b9\u30ad\u30e3\u30f3\u3092\u884c\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u8a72\u5f53\u7b87\u6240\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u30c6\u30fc\u30d6\u30eb\u306e\u6b21\u884c\u3092\u8aad\u307f\u8fbc\u3080\u5272\u5408\uff1a2.64 \/ \u79d2\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of reading next table row"},{"name":"\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u30c7\u30a3\u30b9\u30af\u4e0a\u306b\u5c55\u958b\u3055\u308c\u308b\u5272\u5408","precondition":"!fired('Percentage of temp tables on disk')","formula":"Created_tmp_disk_tables \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u591a\u304f\u306e\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u3001\u30e1\u30e2\u30ea\u3067\u306f\u306a\u304f\u30c7\u30a3\u30b9\u30af\u4e0a\u306b\u5c55\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=max_heap_table_size&amp;lang=ja\">max_heap_table_size<\/a> \u3068 <a href=\"server_variables.php?filter=tmp_table_size&amp;lang=ja\">tmp_table_size<\/a> \u3092\u5897\u52a0\u3055\u305b\u308b\u3053\u3068\u3067\u6539\u5584\u3055\u308c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u306a\u304c\u3089\u3001\u3053\u308c\u3089\u306e\u5909\u6570\u5024\u306b\u95a2\u308f\u308a\u306a\u304f\u3001\u5e38\u306b\u30c7\u30a3\u30b9\u30af\u306b\u5c55\u958b\u3055\u308c\u308b\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306f\u5b58\u5728\u3057\u307e\u3059\u3002\u3053\u306e\u72b6\u6cc1\u3092\u3082\u6539\u5584\u3057\u305f\u3044\u306e\u3067\u3042\u308c\u3070\u3001BLOB \u3084 TEXT \u306e\u30ab\u30e9\u30e0\u3082\u3057\u304f\u306f 512 \u30d0\u30a4\u30c8\u3092\u8d85\u3048\u308b\u30ab\u30e9\u30e0\u3092\u4f7f\u308f\u306a\u3044\u3088\u3046\u306b\u3001\u30af\u30a8\u30ea\u3092\u66f8\u304d\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308b\u3067\u3057\u3087\u3046\u3002\u3053\u306e\u3053\u3068\u306f\u3001<a href=\".\/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Finternal-temporary-tables.html\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a>\u306b\u8a73\u3057\u304f\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059","justification":"\u30c7\u30a3\u30b9\u30af\u66f8\u304d\u8fbc\u307f\u3092\u4f34\u3046\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u5272\u5408\uff1a1.78 \/ \u5206\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Temp disk rate"},{"name":"\u4f7f\u308f\u308c\u3066\u3044\u305f %MyISAM \u30ad\u30fc\u30d0\u30c3\u30d5\u30a1\u306e\u6700\u5927\u6bd4\u7387","precondition":"key_buffer_size > 0","formula":"Key_blocks_used * key_cache_block_size \/ key_buffer_size * 100","test":"value < 95","issue":"MyISAM \u30ad\u30fc\u30d0\u30c3\u30d5\u30a1%\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30ad\u30e3\u30c3\u30b7\u30e5\uff09\u306e\u4f7f\u7528\u7387\u304c\u4f4e\u3044\u3067\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=key_buffer_size&amp;lang=ja\">key_buffer_size<\/a> \u306e\u5fc5\u8981\u3068\u3059\u308b\u30b5\u30a4\u30ba\u304c\u6e1b\u5c11\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002\u3054\u4f7f\u7528\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u524a\u9664\u3055\u308c\u3066\u3044\u306a\u3044\u304b\u3088\u304f\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u307e\u305f\u3001\u30af\u30a8\u30ea\u3042\u308b\u3044\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f7f\u7528\u304c\u60f3\u5b9a\u3055\u308c\u308b\u3082\u306e\u304c\u306a\u3044\u304b\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u4f7f\u308f\u308c\u3066\u3044\u305f % MyISAM \u30ad\u30fc\u30d0\u30c3\u30d5\u30a1\u306e\u6700\u5927\u6bd4\u7387: 0%\u3002\u3053\u306e\u5024\u306f\u300195% \u4ee5\u4e0a\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Max % MyISAM key buffer ever used"},{"name":"\u4e2d\u65ad\u3055\u308c\u305f\u63a5\u7d9a\u306e\u6bd4\u7387","formula":"Aborted_connects \/ Connections * 100","test":"value > 1","issue":"\u4e2d\u65ad\u3055\u308c\u305f\u63a5\u7d9a\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u63a5\u7d9a\u306f\u4e2d\u65ad\u3055\u308c\u305f\u3068\u3044\u3046\u306e\u306f\u3001\u4e00\u822c\u7684\u306b\u3001\u8a8d\u8a3c\u3067\u304d\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u3053\u3068\u3067\u3059\u3002<a href=\".\/url.php?url=https%3A%2F%2Fwww.percona.com%2Fblog%2F2008%2F08%2F23%2Fhow-to-track-down-the-source-of-aborted_connects%2F\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u306e\u8a18\u4e8b (\u82f1\u8a9e)<\/a> \u306f\u3001\u539f\u56e0\u3092\u7a81\u304d\u6b62\u3081\u308b\u306e\u306b\u53c2\u8003\u306b\u306a\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002","justification":"\u5168\u63a5\u7d9a\u306e\u3046\u3061 2% \u304c\u4e2d\u65ad\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u30011% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Percentage of aborted connections"},{"name":"\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u7121\u52b9","formula":"query_cache_size","test":"value == 0 || query_cache_type == 'OFF' || query_cache_type == '0'","issue":"\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u307e\u305b\u3093\u3002","recommendation":"\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u306f\u3001\u7684\u78ba\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u3068\u3066\u3082\u6539\u5584\u3055\u308c\u308b\u3053\u3068\u304c\u77e5\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6709\u52b9\u306b\u3059\u308b\u306b\u306f\u3001<a href=\"server_variables.php?filter=query_cache_size&amp;lang=ja\">query_cache_size<\/a> \u3092 2 \u6841 MiB \u306b\u3057\u3066\u3001<a href=\"server_variables.php?filter=query_cache_type&amp;lang=ja\">query_cache_type<\/a> \u3092\u300cON\u300d\u306b\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<b>\u6ce8\uff1a<\/b>memcached \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u3053\u306e\u4e8b\u8c61\u306b\u95a2\u3059\u308b\u3053\u3068\u306f\u7121\u8996\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"query_cache_size \u304c 0 \u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u304b\u3001query_cache_type \u304c\u300cOFF\u300d\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059","id":"Query cache disabled"}],"notfired":[{"name":"\u7a3c\u50cd\u6642\u9593\u304c 1 \u65e5\u672a\u6e80","formula":"Uptime","test":"value < 86400","issue":"\u7a3c\u50cd\u6642\u9593\u304c 1 \u65e5\u672a\u6e80\u3067\u3059\u3002\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u304c\u6b63\u78ba\u3067\u306a\u3044\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002","recommendation":"\u7d71\u8a08\u30c7\u30fc\u30bf\u3092\u3088\u308a\u6b63\u78ba\u306b\u3059\u308b\u305f\u3081\u306b\u3001\u30b5\u30fc\u30d0\u3092 1 \u65e5\u4ee5\u4e0a\u7a3c\u52d5\u3055\u305b\u3066\u304b\u3089\u89e3\u6790\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059","justification":"10 \u65e5 5 \u6642\u9593 37 \u5206 18 \u79d2 \u3057\u304b\u7a3c\u52d5\u3057\u3066\u3044\u307e\u305b\u3093","id":"Uptime below one day"},{"name":"\u554f\u3044\u5408\u308f\u305b\u6570\u304c 1,000 \u672a\u6e80","formula":"Questions","test":"value < 1000","issue":"\u3053\u306e\u30b5\u30fc\u30d0\u3067\u5b9f\u884c\u3055\u308c\u305f\u554f\u3044\u5408\u308f\u305b\u6570\u304c 1000 \u672a\u6e80\u3068\u3001\u5341\u5206\u3068\u3044\u3048\u308b\u91cf\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u63a8\u5968\u4e8b\u9805\u306f\u6b63\u78ba\u3067\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002","recommendation":"\u5b9f\u884c\u3055\u308c\u305f\u30af\u30a8\u30ea\u304c\u5341\u5206\u306a\u91cf\u306b\u306a\u308b\u307e\u3067\u3001\u9577\u6642\u9593\u30b5\u30fc\u30d0\u3092\u7a3c\u52d5\u3055\u305b\u305f\u307b\u3046\u304c\u3044\u3044\u3067\u3057\u3087\u3046\u3002","justification":"\u73fe\u5728\u306e\u554f\u3044\u5408\u308f\u305b\u7dcf\u6570: 264106","id":"Questions below 1,000"},{"name":"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u6bd4\u7387","precondition":"Questions > 0","formula":"Slow_queries \/ Questions * 100","test":"value >= 5","issue":"\u30af\u30a8\u30ea\u306e\u5168\u4f53\u91cf\u306b\u5bfe\u3057\u3066\u9577\u6642\u9593\u51e6\u7406\u3067\u3042\u308b\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u304c\u591a\u304f\u5b58\u5728\u3057\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=long_query_time&amp;lang=ja\">long_query_time<\/a> \u3092\u5897\u3084\u3059\u304b\u3001\u30af\u30a8\u30ea\u30ed\u30b0\u304b\u3089\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u3092\u898b\u3064\u3051\u51fa\u3057\u6700\u9069\u5316\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044","justification":"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u5272\u5408\u306f 5% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002\u73fe\u5728\u306f 0% \u3067\u3059\u3002","id":"Percentage of slow queries"},{"name":"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u5272\u5408","precondition":"Questions > 0","formula":"(Slow_queries \/ Questions * 100) \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u30b5\u30fc\u30d0\u306e\u7a3c\u50cd\u6642\u9593\u3068\u6bd4\u8f03\u3057\u3066\u9577\u6642\u9593\u51e6\u7406\u3067\u3042\u308b\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u6bd4\u7387\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=long_query_time&amp;lang=ja\">long_query_time<\/a> \u3092\u5897\u3084\u3059\u304b\u3001\u30af\u30a8\u30ea\u30ed\u30b0\u304b\u3089\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u3092\u898b\u3064\u3051\u51fa\u3057\u6700\u9069\u5316\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044","justification":"\u73fe\u5728\u306e\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u5272\u5408\u306f 1 \u6642\u9593\u5f53\u305f\u308a <0.01 \/ \u65e5 \u3067\u3059\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002","id":"Slow query rate"},{"name":"\u30d0\u30fc\u30b8\u30e7\u30f3\u7cfb\u7d71","formula":"version","test":"substr(value,0,2) <= '5.' && substr(value,2,1) < 1","issue":"MySQL \u30b5\u30fc\u30d0\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c 5.1 \u672a\u6e80\u3067\u3059\u3002","recommendation":"\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3092\u63a8\u5968\u3057\u307e\u3059\u3002MySQL 5.1 \u306f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u5411\u4e0a\u3057\u3066\u3044\u307e\u3059\u3057\u3001MySQL 5.5 \u3067\u3042\u308c\u3070\u66f4\u306b\u5411\u4e0a\u3057\u3066\u3044\u307e\u3059\u3002","justification":"\u73fe\u5728\u306e\u30d0\u30fc\u30b8\u30e7\u30f3: 10.4.16-MariaDB","id":"Release Series"},{"name":"\u30de\u30a4\u30ca\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3","precondition":"! fired('Release Series')","formula":"version","test":"substr(value,0,2) <= '5.' && substr(value,2,1) <= 1 && substr(value,4,2) < 30","issue":"\u30d0\u30fc\u30b8\u30e7\u30f3 5.1.30 (5.1 \u306e \u6700\u521d\u306e\u5b89\u5b9a\u7248) \u672a\u6e80\u3067\u3059\u3002","recommendation":"\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3092\u63a8\u5968\u3057\u307e\u3059\u3002\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u306e MySQL 5.1 \u306f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u5411\u4e0a\u3057\u3066\u3044\u307e\u3059\u3057\u3001MySQL 5.5 \u3067\u3042\u308c\u3070\u66f4\u306b\u5411\u4e0a\u3057\u3066\u3044\u307e\u3059\u3002","justification":"\u73fe\u5728\u306e\u30d0\u30fc\u30b8\u30e7\u30f3: 10.4.16-MariaDB","id":"Minor Version"},{"name":"\u30de\u30a4\u30ca\u30fc\u30d0\u30fc\u30b8\u30e7\u30f3","precondition":"! fired('Release Series')","formula":"version","test":"substr(value,0,1) == 5 && substr(value,2,1) == 5 && substr(value,4,2) < 8","issue":"\u30d0\u30fc\u30b8\u30e7\u30f3 5.5.8 (5.5 \u306e \u6700\u521d\u306e\u5b89\u5b9a\u7248) \u672a\u6e80\u3067\u3059\u3002","recommendation":"\u5b89\u5b9a\u7248 MySQL 5.5 \u3078\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3092\u63a8\u5968\u3057\u307e\u3059\u3002","justification":"\u73fe\u5728\u306e\u30d0\u30fc\u30b8\u30e7\u30f3: 10.4.16-MariaDB","id":"Minor Version"},{"name":"\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3","formula":"version_comment","test":"preg_match('\/source\/i',value)","issue":"\u3054\u4f7f\u7528\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u30bd\u30fc\u30b9\u304b\u3089\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u305f\u3082\u306e\u3067\u3001MySQL \u30aa\u30d5\u30a3\u30c3\u30b7\u30e3\u30eb\u306e\u30d0\u30a4\u30ca\u30ea\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002","recommendation":"\u30e6\u30fc\u30b6\u304c\u72ec\u81ea\u306b\u30bd\u30fc\u30b9\u304b\u3089\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u305f\u306e\u3067\u306a\u3044\u306e\u3067\u3042\u308c\u3070\u3001\u304a\u305d\u3089\u304f\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3\u306b\u3088\u308b\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u3082\u306e\u3060\u3068\u601d\u308f\u308c\u307e\u3059\u3002MySQL \u306e\u30de\u30cb\u30e5\u30a2\u30eb\u306f\u3001MySQL \u30aa\u30d5\u30a3\u30c3\u30b7\u30e3\u30eb\u306e\u30d0\u30a4\u30ca\u30ea\u306b\u5bfe\u3057\u3066\u306f\u53b3\u683c\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u304c\u3001(RedHat\u3001Debian\/Ubuntu \u306a\u3069\u306e\u3088\u3046\u306a) \u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u306b\u5bfe\u3057\u3066\u306f\u591a\u5c11\u7570\u306a\u308b\u90e8\u5206\u3082\u3042\u308a\u307e\u3059\u3002","justification":"\u30d0\u30fc\u30b8\u30e7\u30f3\u30b3\u30e1\u30f3\u30c8 (version_comment) \u306b \u300csource\u300d\u3068\u3044\u3046\u6587\u5b57\u304c\u3042\u308a\u307e\u3059","id":"Distribution"},{"name":"\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30b7\u30e7\u30f3","formula":"version_comment","test":"preg_match('\/percona\/i',value)","issue":"MySQL \u306e\u30de\u30cb\u30e5\u30a2\u30eb\u306f\u3001MySQL \u30aa\u30d5\u30a3\u30c3\u30b7\u30e3\u30eb\u306e\u30d0\u30a4\u30ca\u30ea\u306b\u5bfe\u3057\u3066\u3060\u3051\u53b3\u683c\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002","recommendation":"Percona \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306f<a href=\".\/url.php?url=https%3A%2F%2Fwww.percona.com%2Fsoftware%2Fdocumentation%2F\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.percona.com\/software\/documentation\/<\/a>\u306b\u3042\u308a\u307e\u3059","justification":"\u30d0\u30fc\u30b8\u30e7\u30f3\u30b3\u30e1\u30f3\u30c8 (version_comment) \u306b \u300cpercona\u300d\u3068\u3044\u3046\u6587\u5b57\u304c\u3042\u308a\u307e\u3059","id":"Distribution"},{"name":"MySQL \u4ed5\u69d8","formula":"system_memory","test":"value > 3072*1024 && !preg_match('\/64\/',version_compile_machine) && !preg_match('\/64\/',version_compile_os)","issue":"MySQL \u304c\u300164 \u30d3\u30c3\u30c8\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3068\u3057\u3066\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002","recommendation":"\u30e1\u30e2\u30ea\u4e0a\u9650\u304c (\u3053\u306e\u30b5\u30fc\u30d0\u4e0a\u306b\u304a\u3044\u3066) 3 GiB \u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u306e\u3067\u3001MySQL \u306f\u30e1\u30e2\u30ea\u3092\u5341\u5206\u6d3b\u7528\u3067\u304d\u306a\u3044\u3067\u3057\u3087\u3046\u300264 \u30d3\u30c3\u30c8\u7248\u306e MySQL \u306e\u5c0e\u5165\u3092\u691c\u8a0e\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u3053\u306e\u30db\u30b9\u30c8\u4e0a\u306e\u5229\u7528\u53ef\u80fd\u30e1\u30e2\u30ea: 0 \u30d0\u30a4\u30c8","id":"MySQL Architecture"},{"name":"\u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u65b9\u5f0f","precondition":"!fired('Query cache disabled')","formula":"Questions \/ Uptime","test":"value > 100","issue":"\u6e96\u6700\u9069\u30ad\u30e3\u30c3\u30b7\u30e5\u65b9\u5f0f\u3067\u3059\u3002","recommendation":"MySQL \u306e\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u304b\u306a\u308a\u9ad8\u3044\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002MySQL \u306e\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u4ee3\u308f\u308a\u306b <a href=\".\/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fha-memcached.html\" target=\"_blank\" rel=\"noopener noreferrer\">memcached<\/a> \u306e\u4f7f\u7528\u3092\u691c\u8a0e\u3059\u308b\u4fa1\u5024\u304c\u3042\u308b\u3068\u601d\u308f\u308c\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30de\u30eb\u30c1\u30b9\u30ec\u30fc\u30d6\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u7279\u306b\u63a8\u5968\u3055\u308c\u307e\u3059\u3002","justification":"\u30af\u30a8\u30ea\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u6709\u52b9\u3067\u3001\u30b5\u30fc\u30d0\u304c\u6bce\u79d2 0 \u500b\u306e\u30af\u30a8\u30ea\u3092\u53d7\u4fe1\u3057\u3066\u3044\u307e\u3059\u3002\u6bce\u79d2 100 \u500b\u3092\u8d85\u3048\u308b\u306e\u30af\u30a8\u30ea\u304c\u3042\u308b\u5834\u5408\u3001\u3053\u306e\u30eb\u30fc\u30eb\u304c\u9069\u7528\u3055\u308c\u307e\u3059\u3002","id":"Query caching method"},{"name":"\u30bd\u30fc\u30c8\u6642\u306b\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u4f7f\u308f\u308c\u308b\u6bd4\u7387","precondition":"Sort_scan + Sort_range > 0","formula":"Sort_merge_passes \/ (Sort_scan + Sort_range) * 100","test":"value > 10","issue":"\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u591a\u304f\u306e\u30bd\u30fc\u30c8\u3067\u4f7f\u308f\u308c\u3066\u3044\u307e\u3059\u3002","recommendation":"\u3054\u4f7f\u7528\u306e\u30b7\u30b9\u30c6\u30e0\u306e\u30e1\u30e2\u30ea\u74b0\u5883\u306b\u5408\u308f\u305b\u3066\u3001<a href=\"server_variables.php?filter=sort_buffer_size&amp;lang=ja\">sort_buffer_size<\/a> \u3068 <a href=\"server_variables.php?filter=read_rnd_buffer_size&amp;lang=ja\">read_rnd_buffer_size<\/a> \u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u4e21\u65b9\u3092\u5897\u52a0\u3055\u305b\u308b\u3053\u3068\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u5168\u30bd\u30fc\u30c8\u306e\u5185 0% \u304c\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u300110% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002","id":"Percentage of sorts that cause temporary tables"},{"name":"\u30bd\u30fc\u30c8\u6642\u306b\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u4f7f\u308f\u308c\u308b\u5272\u5408","formula":"Sort_merge_passes \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u591a\u304f\u306e\u30bd\u30fc\u30c8\u3067\u4f7f\u308f\u308c\u3066\u3044\u307e\u3059\u3002","recommendation":"\u3054\u4f7f\u7528\u306e\u30b7\u30b9\u30c6\u30e0\u306e\u30e1\u30e2\u30ea\u74b0\u5883\u306b\u5408\u308f\u305b\u3066\u3001<a href=\"server_variables.php?filter=sort_buffer_size&amp;lang=ja\">sort_buffer_size<\/a> \u3068 <a href=\"server_variables.php?filter=read_rnd_buffer_size&amp;lang=ja\">read_rnd_buffer_size<\/a> \u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u4e21\u65b9\u3092\u5897\u52a0\u3055\u305b\u308b\u3053\u3068\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u4f7f\u7528\u7387\u306e\u5e73\u5747\uff1a<0.01 \/ \u65e5\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002","id":"Rate of sorts that cause temporary tables"},{"name":"\u7570\u306a\u308btmp_table_size \u3068 max_heap_table_size","formula":"tmp_table_size - max_heap_table_size","test":"value !=0","issue":"{tmp_table_size} \u3068 {max_heap_table_size} \u304c\u540c\u3058\u5024\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002","recommendation":"\u3044\u305a\u308c\u304b 1 \u3064\u306e\u5909\u66f4\u3057\u305f\u5834\u5408\u3001\u30e1\u30e2\u30ea\u5185\u30c6\u30fc\u30d6\u30eb\u306e\u30b5\u30a4\u30ba\u304c\u6700\u5927\u306b\u306a\u308b\u3088\u3046\u306b\u3001\u30b5\u30fc\u30d0\u306f\u3044\u305a\u308c\u304b\u4f4e\u3044\u307b\u3046\u306e\u5024\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3067\u3059\u304b\u3089\u3001\u30e1\u30e2\u30ea\u5185\u30c6\u30fc\u30d6\u30eb\u306e\u5236\u9650\u3092\u5897\u3084\u3057\u305f\u3044\u306e\u3067\u3042\u308c\u3070\u3001\u3082\u3046\u4e00\u65b9\u306e\u5024\u3082\u5897\u3084\u3057\u305f\u307b\u3046\u304c\u3044\u3044\u3067\u3057\u3087\u3046\u3002","justification":"\u4e21\u8005\u306e\u73fe\u5728\u306e\u5024\u306f\u3001tmp_table_size \u304c 16.00 MiB\u3001max_heap_table_size \u304c 16.00 MiB \u3067\u3059","id":"Different tmp_table_size and max_heap_table_size"},{"name":"\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u30c7\u30a3\u30b9\u30af\u4e0a\u306b\u5c55\u958b\u3055\u308c\u308b\u6bd4\u7387","precondition":"Created_tmp_tables + Created_tmp_disk_tables > 0","formula":"Created_tmp_disk_tables \/ (Created_tmp_tables + Created_tmp_disk_tables) * 100","test":"value > 25","issue":"\u591a\u304f\u306e\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u3001\u30e1\u30e2\u30ea\u3067\u306f\u306a\u304f\u30c7\u30a3\u30b9\u30af\u4e0a\u306b\u5c55\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=max_heap_table_size&amp;lang=ja\">max_heap_table_size<\/a> \u3068 <a href=\"server_variables.php?filter=tmp_table_size&amp;lang=ja\">tmp_table_size<\/a> \u3092\u5897\u52a0\u3055\u305b\u308b\u3053\u3068\u3067\u6539\u5584\u3055\u308c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u306a\u304c\u3089\u3001\u3053\u308c\u3089\u306e\u5909\u6570\u5024\u306b\u95a2\u308f\u308a\u306a\u304f\u3001\u5e38\u306b\u30c7\u30a3\u30b9\u30af\u306b\u5c55\u958b\u3055\u308c\u308b\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306f\u5b58\u5728\u3057\u307e\u3059\u3002\u3053\u306e\u72b6\u6cc1\u3092\u3082\u6539\u5584\u3057\u305f\u3044\u306e\u3067\u3042\u308c\u3070\u3001BLOB \u3084 TEXT \u306e\u30ab\u30e9\u30e0\u3082\u3057\u304f\u306f 512 \u30d0\u30a4\u30c8\u3092\u8d85\u3048\u308b\u30ab\u30e9\u30e0\u3092\u4f7f\u308f\u306a\u3044\u3088\u3046\u306b\u3001\u30af\u30a8\u30ea\u3092\u66f8\u304d\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308b\u3067\u3057\u3087\u3046\u3002\u3053\u306e\u3053\u3068\u306f\u3001<a href=\".\/url.php?url=https%3A%2F%2Fwww.facebook.com%2Fnote.php%3Fnote_id%3D10150111255065841%26comments\" target=\"_blank\" rel=\"noopener noreferrer\">The Pythian Group \u306e\u8a18\u4e8b (\u82f1\u8a9e)<\/a>\u306b\u8a73\u3057\u304f\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059","justification":"\u5168\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u5185 12% \u304c\u30c7\u30a3\u30b9\u30af\u4e0a\u306b\u5c55\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u300125% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Percentage of temp tables on disk"},{"name":"MyISAM \u30ad\u30fc\u30d0\u30c3\u30d5\u30a1\u306e\u30b5\u30a4\u30ba","formula":"key_buffer_size","test":"value == 0","issue":"\u30ad\u30fc\u30d0\u30c3\u30d5\u30a1\u304c\u521d\u671f\u5316\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\u304a\u305d\u3089\u304f\u3001MyISAM \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u30ad\u30e3\u30c3\u30b7\u30e5\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002","recommendation":"\u304a\u4f7f\u3044\u306e MyISAM \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u30b5\u30a4\u30ba\u306b\u5408\u308f\u305b\u305f <a href=\"server_variables.php?filter=key_buffer_size&amp;lang=ja\">key_buffer_size<\/a> \u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u6700\u521d\u306e\u8a2d\u5b9a\u3068\u3057\u3066\u306f\u300164M \u304b\u3089\u304c\u3044\u3044\u3067\u3057\u3087\u3046\u3002","justification":"key_buffer_size \u306f 0 \u3067\u3059","id":"MyISAM key buffer size"},{"name":"\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304f\u5272\u5408","formula":"Opened_tables \/ Uptime","test":"value*60*60 > 10","issue":"\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304f\u5272\u5408\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304f\u3068\u3044\u3046\u306e\u306f\u3001\u8ca0\u8377\u304c\u304b\u304b\u308b\u30c7\u30a3\u30b9\u30af\u3078\u306e\u5165\u51fa\u529b\u3092\u884c\u3046\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002<a href=\"server_variables.php?filter=table_open_cache&amp;lang=ja\">table_open_cache<\/a> \u3092\u5927\u304d\u304f\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u308c\u3092\u7de9\u548c\u3067\u304d\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002","justification":"\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304f\u5272\u5408\uff1a12.7 \/ \u65e5 \u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 10 \u672a\u6e80\u304c\u826f\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of table open"},{"name":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u4e0a\u9650\u306b\u5bfe\u3059\u308b\u6bd4\u7387","formula":"Open_files \/ open_files_limit * 100","test":"value > 85","issue":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u6570\u304c\u6700\u5927\u306b\u306a\u308a\u3064\u3064\u3042\u308a\u307e\u3059\u3002\u30a8\u30e9\u30fc\u300c\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u304c\u591a\u3059\u304e\u307e\u3059\u300d\u306b\u306a\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002","recommendation":"<a href=\"server_variables.php?filter=open_files_limit&amp;lang=ja\">open_files_limit<\/a> \u5897\u3084\u3059\u3053\u3068\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<a href=\"server_variables.php?filter=open_files_limit&amp;lang=ja\">open_files_limit<\/a> \u3092\u5909\u66f4\u3057\u3066\u518d\u8d77\u52d5\u3057\u305f\u5834\u5408\u306f\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u6570\u306f\u4e0a\u9650\u306b\u5bfe\u3057\u3066 0% \u3067\u3059\u3002\u3053\u306e\u5024\u306f\u300185% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Percentage of used open files limit"},{"name":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u5272\u5408","formula":"Open_files \/ Uptime","test":"value * 60 * 60 > 5","issue":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u5272\u5408\u304c\u9ad8\u3044\u3067\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=open_files_limit&amp;lang=ja\">open_files_limit<\/a> \u5897\u3084\u3059\u3053\u3068\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<a href=\"server_variables.php?filter=open_files_limit&amp;lang=ja\">open_files_limit<\/a> \u3092\u5909\u66f4\u3057\u3066\u518d\u8d77\u52d5\u3057\u305f\u5834\u5408\u306f\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u958b\u3044\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u5272\u5408\uff1a5.37 \/ \u65e5\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 5 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of open files"},{"name":"\u901f\u3084\u304b\u306b\u884c\u308f\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af%\u306e\u6bd4\u7387","precondition":"Table_locks_waited + Table_locks_immediate > 0","formula":"Table_locks_immediate \/ (Table_locks_waited + Table_locks_immediate) * 100","test":"value < 95","issue":"\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u8981\u6c42\u306b\u5bfe\u3057\u3066\u901f\u3084\u304b\u306b\u53d6\u5f97\u3067\u304d\u306a\u3044\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u9069\u5316\u3082\u3057\u304f\u306f InnoDB \u306e\u30ed\u30c3\u30af\u5f85\u3061\u6642\u9593\u306e\u6e1b\u5c11\u3001\u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u4e21\u65b9\u3092\u884c\u3063\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u901f\u3084\u304b\u306b\u884c\u308f\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af: 100%\u3002\u3053\u306e\u5024\u306f\u300195% \u4ee5\u4e0a\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Immediate table locks %"},{"name":"\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u306e\u5f85\u3064\u5272\u5408","formula":"Table_locks_waited \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u8981\u6c42\u306b\u5bfe\u3057\u3066\u901f\u3084\u304b\u306b\u53d6\u5f97\u3067\u304d\u306a\u3044\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u30c6\u30fc\u30d6\u30eb\u306e\u6700\u9069\u5316\u3082\u3057\u304f\u306f InnoDB \u306e\u30ed\u30c3\u30af\u5f85\u3061\u6642\u9593\u306e\u6e1b\u5c11\u3001\u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u4e21\u65b9\u3092\u884c\u3063\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u306e\u5f85\u3064\u5272\u5408: <0.01 \/ \u65e5\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Table lock wait rate"},{"name":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5","formula":"thread_cache_size","test":"value < 1","issue":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3001MySQL \u3078\u306e\u65b0\u305f\u306a\u63a5\u7d9a\u306b\u5bfe\u3057\u3066\u306e\u30aa\u30fc\u30d0\u30d8\u30c3\u30c9\u304c\u5927\u304d\u304f\u306a\u308a\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=thread_cache_size&amp;lang=ja\">thread_cache_size<\/a> \u306b 0 \u3088\u308a\u5927\u304d\u306a\u5024\u3092\u8a2d\u5b9a\u3057\u3066\u3001\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6709\u52b9\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u306f 0 \u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059","id":"Thread cache"},{"name":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u30d2\u30c3\u30c8\u7387%","precondition":"thread_cache_size > 0","formula":"100 - Threads_created \/ Connections","test":"value < 80","issue":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u304c\u52b9\u679c\u7684\u306b\u6a5f\u80fd\u3057\u3066\u3044\u307e\u305b\u3093\u3002","recommendation":"<a href=\"server_variables.php?filter=thread_cache_size&amp;lang=ja\">thread_cache_size<\/a> \u3092\u5897\u3084\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u30b9\u30ec\u30c3\u30c9\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u30d2\u30c3\u30c8\u7387: 100%\u3002\u3053\u306e\u5024\u306f\u300180% \u4ee5\u4e0a\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Thread cache hit rate %"},{"name":"\u8d77\u52d5\u304c\u9045\u3044\u30b9\u30ec\u30c3\u30c9","precondition":"slow_launch_time > 0","formula":"Slow_launch_threads","test":"value > 0","issue":"\u8d77\u52d5\u304c\u9045\u3044\u30b9\u30ec\u30c3\u30c9\u304c\u591a\u304f\u5b58\u5728\u3057\u307e\u3059\u3002","recommendation":"\u4e00\u822c\u7684\u306b\u3001\u6bd4\u8f03\u7684\u5358\u7d14\u306a\u64cd\u4f5c\u306a\u308f\u308a\u306b\u306f\u3001\u30b7\u30b9\u30c6\u30e0\u5168\u4f53\u306b\u8ca0\u8377\u304c\u304b\u304b\u3063\u3066\u3044\u308b\u72b6\u614b\u3067\u3059\u3002\u304a\u4f7f\u3044\u306e\u30b7\u30b9\u30c6\u30e0\u306e\u8ca0\u8377\u3092\u5165\u5ff5\u306b\u30e2\u30cb\u30bf\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002","justification":"0 \u30b9\u30ec\u30c3\u30c9\u306e\u958b\u59cb\u306b 2 \u79d2\u4ee5\u4e0a\u304b\u304b\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u30010 \u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Threads that are slow to launch"},{"name":"\u9045\u3044\u8d77\u52d5\u6642\u9593","formula":"slow_launch_time","test":"value > 2","issue":"Slow_launch_time \u304c 2 \u79d2\u3092\u8d85\u3048\u3066\u3044\u307e\u3059\u3002","recommendation":"\u8d77\u52d5\u304c\u9045\u3044\u30b9\u30ec\u30c3\u30c9\u306a\u304f\u306a\u308b\u3088\u3046\u306b\u3001<a href=\"server_variables.php?filter=slow_launch_time&amp;lang=ja\">slow_launch_time<\/a> \u3092 1 \u79d2\u304b 2 \u79d2\u306b\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"slow_launch_time \u306f 2 \u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059","id":"Slow launch time"},{"name":"\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u63a5\u7d9a\u306e\u6bd4\u7387","formula":"Max_used_connections \/ max_connections * 100","test":"value > 80","issue":"\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u63a5\u7d9a\u6570\u304c {max_connections} \u306e\u5024\u306b\u9054\u3059\u308b\u3068\u3001\u9589\u3058\u3089\u308c\u3066\u3057\u307e\u3046\u63a5\u7d9a\u304c\u767a\u751f\u3057\u307e\u3059\u3002","recommendation":"<a href=\"server_variables.php?filter=max_connections&amp;lang=ja\">max_connections<\/a>\u3092\u5897\u3084\u3059\u304b <a href=\"server_variables.php?filter=wait_timeout&amp;lang=ja\">wait_timeout<\/a> \u3092\u6e1b\u3089\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u51e6\u7406\u306b\u304a\u3044\u3066\u63a5\u7d9a\u304c\u3059\u3050\u306b\u5207\u3089\u308c\u308b\u3053\u3068\u306f\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u5ff5\u306e\u305f\u3081\u3001\u30b3\u30fc\u30c9\u4e0a\u306b\u304a\u3044\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u9069\u5207\u306b\u9589\u3058\u3089\u308c\u3066\u3044\u308b\u304b\u3082\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002","justification":"Max_used_connections \u306f max_connections \u306e 15% \u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u300180% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Percentage of used connections"},{"name":"\u4e2d\u65ad\u3055\u308c\u305f\u63a5\u7d9a\u306e\u5272\u5408","formula":"Aborted_connects \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u4e2d\u65ad\u3055\u308c\u305f\u63a5\u7d9a\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u63a5\u7d9a\u306f\u4e2d\u65ad\u3055\u308c\u305f\u3068\u3044\u3046\u306e\u306f\u3001\u4e00\u822c\u7684\u306b\u3001\u8a8d\u8a3c\u3067\u304d\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u3053\u3068\u3067\u3059\u3002<a href=\".\/url.php?url=https%3A%2F%2Fwww.percona.com%2Fblog%2F2008%2F08%2F23%2Fhow-to-track-down-the-source-of-aborted_connects%2F\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u306e\u8a18\u4e8b (\u82f1\u8a9e)<\/a> \u306f\u3001\u539f\u56e0\u3092\u7a81\u304d\u6b62\u3081\u308b\u306e\u306b\u53c2\u8003\u306b\u306a\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002","justification":"\u4e2d\u65ad\u3055\u308c\u305f\u63a5\u7d9a\u306e\u5272\u5408\u306f 20.03 \/ \u65e5 \u3067\u3059\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of aborted connections"},{"name":"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b\u3088\u3063\u3066\u4e2d\u65ad\u3055\u308c\u305f\u6bd4\u7387","formula":"Aborted_clients \/ Connections * 100","test":"value > 2","issue":"\u4e2d\u65ad\u3055\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b\u3088\u3063\u3066\u4e2d\u65ad\u3055\u308c\u305f\u3068\u3044\u3046\u306e\u306f\u3001\u4e00\u822c\u7684\u306b\u3001MySQL \u3078\u306e\u63a5\u7d9a\u304c\u9069\u5207\u306b\u9589\u3058\u3089\u308c\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u3053\u3068\u3067\u3059\u3002\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u554f\u984c\u3082\u3057\u304f\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u9069\u5207\u306b\u9589\u3058\u3066\u3044\u306a\u3044\u30b3\u30fc\u30c9\u304c\u539f\u56e0\u3068\u8003\u3048\u3089\u308c\u307e\u3059\u3002\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u3068\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u5168\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u5185 0% \u304c\u4e2d\u65ad\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5024\u306f\u30012% \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Percentage of aborted clients"},{"name":"\u4e2d\u65ad\u3055\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u5272\u5408","formula":"Aborted_clients \/ Uptime","test":"value * 60 * 60 > 1","issue":"\u4e2d\u65ad\u3055\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u591a\u3044\u3067\u3059\u3002","recommendation":"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b\u3088\u3063\u3066\u4e2d\u65ad\u3055\u308c\u305f\u3068\u3044\u3046\u306e\u306f\u3001\u4e00\u822c\u7684\u306b\u3001MySQL \u3078\u306e\u63a5\u7d9a\u304c\u9069\u5207\u306b\u9589\u3058\u3089\u308c\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u3053\u3068\u3067\u3059\u3002\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u554f\u984c\u3082\u3057\u304f\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u9069\u5207\u306b\u9589\u3058\u3066\u3044\u306a\u3044\u30b3\u30fc\u30c9\u304c\u539f\u56e0\u3068\u8003\u3048\u3089\u308c\u307e\u3059\u3002\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u3068\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002","justification":"\u4e2d\u65ad\u3055\u308c\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u5272\u5408: <0.01 \/ \u65e5\u3002\u3053\u306e\u5024\u306f\u30011 \u6642\u9593\u5f53\u305f\u308a 1 \u672a\u6e80\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"Rate of aborted clients"},{"name":"InnoDB \u306e\u30ed\u30b0\u30b5\u30a4\u30ba","precondition":"innodb_buffer_pool_size > 0","formula":"(innodb_log_file_size * innodb_log_files_in_group)\/ innodb_buffer_pool_size * 100","test":"value < 20 && innodb_log_file_size \/ (1024 * 1024) < 256","issue":"InnoDB \u306e\u30ed\u30b0\u30b5\u30a4\u30ba\u304c\u9069\u5207\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u306e\u5024\u306f InnoDB \u30d0\u30c3\u30d5\u30a1\u30d7\u30fc\u30eb\u3068\u95a2\u9023\u304c\u3042\u308a\u307e\u3059\u3002","recommendation":"\u7279\u306b\u3001InnoDB \u306e\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u66f8\u304d\u8fbc\u307f\u304c\u591a\u3044\u30b7\u30b9\u30c6\u30e0\u306e\u5834\u5408\u306b\u306f\u3001<a href=\"server_variables.php?filter=innodb_log_file_size&amp;lang=ja\">innodb_log_file_size<\/a> \u306f <a href=\"server_variables.php?filter=innodb_buffer_pool_size&amp;lang=ja\">innodb_buffer_pool_size<\/a> \u306e 25% \u306b\u8a2d\u5b9a\u3059\u308b\u3068\u3044\u3044\u3067\u3057\u3087\u3046\u3002\u3057\u304b\u3057\u306a\u304c\u3089\u3001\u3053\u306e\u5024\u304c\u5927\u304d\u304f\u306a\u308b\u3068\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u58ca\u308c\u305f\u3068\u304d\u306e\u4fee\u5fa9\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u3053\u306e\u5024\u306f 256 MiB \u3092\u8d85\u3048\u306a\u3044\u307b\u3046\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002\u306a\u304a\u3001\u3053\u306e\u5909\u6570\u306f\u7c21\u5358\u306b\u306f\u5909\u66f4\u3067\u304d\u306a\u3044\u306e\u3067\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30b5\u30fc\u30d0\u3092\u505c\u6b62\u3055\u305b\u3001InnoDB \u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u3001my.cnf \u306b\u65b0\u3057\u3044\u5024\u3092\u8a2d\u5b9a\u3057\u3066\u3001\u305d\u3046\u3057\u305f\u5f8c\u306b\u30b5\u30fc\u30d0\u306f\u8d77\u52d5\u3057\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u3057\u3066\u3001\u5168\u3066\u306e\u8a2d\u5b9a\u304c\u6b63\u3057\u304f\u8a2d\u5b9a\u3067\u304d\u3066\u3044\u308b\u306e\u304b\u3092\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u3067\u78ba\u8a8d\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002<a href=\".\/url.php?url=https%3A%2F%2Fmysqldatabaseadministration.blogspot.com%2F2007%2F01%2Fincrease-innodblogfilesize-proper-way.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089\u306e\u30d6\u30ed\u30b0\u8a18\u4e8b (\u82f1\u8a9e)<\/a> \u3082\u3054\u89a7\u306b\u306a\u3063\u3066\u304f\u3060\u3055\u3044","justification":"\u3054\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b InnoDB \u306e\u30ed\u30b0\u30b5\u30a4\u30ba\u306f\u3001\u95a2\u9023\u306e\u3042\u308b InnoDB \u30d0\u30c3\u30d5\u30a1\u30d7\u30fc\u30eb\u306e\u5927\u304d\u3055\u306b\u5bfe\u3057\u3066 63% \u3067\u3059\u3002\u3053\u306e\u5024\u306f\u300120% \u672a\u6e80\u306b\u3057\u306a\u3044\u307b\u3046\u304c\u3044\u3044\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059","id":"InnoDB log size"},{"name":"MyISAM \u306b\u304a\u3051\u308b\u540c\u6642\u633f\u5165","formula":"concurrent_insert","test":"value === 0 || value === 'NEVER'","issue":"{concurrent_insert} \u306b 1 \u3092\u8a2d\u5b9a\u3057\u3066\u3001\u540c\u6642\u633f\u5165\u3092\u6709\u52b9\u306b\u3057\u3066\u304f\u3060\u3055\u3044","recommendation":"<a href=\"server_variables.php?filter=concurrent_insert&amp;lang=ja\">concurrent_insert<\/a> \u3092 1 \u306b\u8a2d\u5b9a\u3059\u308b\u3068\u3001\u4e00\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u5185\u306b\u304a\u3051\u308b\u8aad\u307f\u66f8\u304d\u306e\u885d\u7a81\u3092\u6e1b\u3089\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<a href=\".\/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fja%2Fconcurrent-inserts.html\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a>\u3082\u3054\u89a7\u306b\u306a\u3063\u3066\u304f\u3060\u3055\u3044","justification":"concurrent_insert \u306f 0 \u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059","id":"MyISAM concurrent inserts"}],"unchecked":[{"name":"Slow query logging","precondition":"PMA_MYSQL_INT_VERSION < 50600","formula":"log_slow_queries","test":"value == 'OFF'","issue":"The slow query log is disabled.","recommendation":"Enable slow query logging by setting {log_slow_queries} to 'ON'. This will help troubleshooting badly performing queries.","justification":"log_slow_queries is set to 'OFF'"},{"name":"Percentage of MyISAM key buffer used","precondition":"key_buffer_size > 0 && !fired('Max % MyISAM key buffer ever used')","formula":"( 1 - Key_blocks_unused * key_cache_block_size \/ key_buffer_size) * 100","test":"value < 95","issue":"MyISAM key buffer (index cache) % used is low.","recommendation":"You may need to decrease the size of {key_buffer_size}, re-examine your tables to see if indexes have been removed, or examine queries and expectations about what indexes are being used.","justification":"% MyISAM key buffer used: %s%, this value should be above 95% | round(value,1)"},{"name":"Percentage of index reads from memory","precondition":"Key_read_requests > 0","formula":"100 - (Key_reads \/ Key_read_requests * 100)","test":"value < 95","issue":"The % of indexes that use the MyISAM key buffer is low.","recommendation":"You may need to increase {key_buffer_size}.","justification":"Index reads from memory: %s%, this value should be above 95% | round(value,1)"},{"name":"Is InnoDB disabled?","precondition":"PMA_MYSQL_INT_VERSION < 50600","formula":"have_innodb","test":"value != \"YES\"","issue":"You do not have InnoDB enabled.","recommendation":"InnoDB is usually the better choice for table engines.","justification":"have_innodb is set to 'value'"},{"name":"Max InnoDB log size","precondition":"innodb_buffer_pool_size > 0 && innodb_log_file_size \/ innodb_buffer_pool_size * 100 < 30","formula":"innodb_log_file_size \/ (1024 * 1024)","test":"value > 256","issue":"The InnoDB log file size is inadequately large.","recommendation":"It is usually sufficient to set {innodb_log_file_size} to 25% of the size of {innodb_buffer_pool_size}. A very big {innodb_log_file_size} slows down the recovery time after a database crash considerably. See also <a href=\"https:\/\/www.percona.com\/blog\/2006\/07\/03\/choosing-proper-innodb_log_file_size\/\">this Article<\/a>. You need to shutdown the server, remove the InnoDB log files, set the new value in my.cnf, start the server, then check the error logs if everything went fine. See also <a href=\"https:\/\/mysqldatabaseadministration.blogspot.com\/2007\/01\/increase-innodblogfilesize-proper-way.html\">this blog entry<\/a>","justification":"Your absolute InnoDB log size is %s MiB | round(value,1)"},{"name":"InnoDB buffer pool size","precondition":"system_memory > 0","formula":"innodb_buffer_pool_size \/ system_memory * 100","test":"value < 60","issue":"Your InnoDB buffer pool is fairly small.","recommendation":"The InnoDB buffer pool has a profound impact on performance for InnoDB tables. Assign all your remaining memory to this buffer. For database servers that use solely InnoDB as storage engine and have no other services (e.g. a web server) running, you may set this as high as 80% of your available memory. If that is not the case, you need to carefully assess the memory consumption of your other services and non-InnoDB-Tables and set this variable accordingly. If it is set too high, your system will start swapping, which decreases performance significantly. See also <a href=\"https:\/\/www.percona.com\/blog\/2007\/11\/03\/choosing-innodb_buffer_pool_size\/\">this article<\/a>","justification":"You are currently using %s% of your memory for the InnoDB buffer pool. This rule fires if you are assigning less than 60%, however this might be perfectly adequate for your system if you don't have much InnoDB tables or other services running on the same machine. | value"},{"name":"Query cache efficiency (%)","precondition":"Com_select + Qcache_hits > 0 && !fired('Query cache disabled')","formula":"Qcache_hits \/ (Com_select + Qcache_hits) * 100","test":"value < 20","issue":"Query cache not running efficiently, it has a low hit rate.","recommendation":"Consider increasing {query_cache_limit}.","justification":"The current query cache hit rate of %s% is below 20% | round(value,1)"},{"name":"Query Cache usage","precondition":"!fired('Query cache disabled')","formula":"100 - Qcache_free_memory \/ query_cache_size * 100","test":"value < 80","issue":"Less than 80% of the query cache is being utilized.","recommendation":"This might be caused by {query_cache_limit} being too low. Flushing the query cache might help as well.","justification":"The current ratio of free query cache memory to total query cache size is %s%. It should be above 80% | round(value,1)"},{"name":"Query cache fragmentation","precondition":"!fired('Query cache disabled')","formula":"Qcache_free_blocks \/ (Qcache_total_blocks \/ 2) * 100","test":"value > 20","issue":"The query cache is considerably fragmented.","recommendation":"Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a immediate but short lived fix you can flush the query cache (might lock the query cache for a long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too, e.g. you can set it to the average size of your queries in the cache using this formula: (query_cache_size - qcache_free_memory) \/ qcache_queries_in_cache","justification":"The cache is currently fragmented by %s% , with 100% fragmentation meaning that the query cache is an alternating pattern of free and used blocks. This value should be below 20%. | round(value,1)"},{"name":"Query cache low memory prunes","precondition":"Qcache_inserts > 0 && !fired('Query cache disabled')","formula":"Qcache_lowmem_prunes \/ Qcache_inserts * 100","test":"value > 0.1","issue":"Cached queries are removed due to low query cache memory from the query cache.","recommendation":"You might want to increase {query_cache_size}, however keep in mind that the overhead of maintaining the cache is likely to increase with its size, so do this in small increments and monitor the results.","justification":"The ratio of removed queries to inserted queries is %s%. The lower this value is, the better (This rules firing limit: 0.1%) | round(value,1)"},{"name":"Query cache max size","precondition":"!fired('Query cache disabled')","formula":"query_cache_size","test":"value > 1024 * 1024 * 128","issue":"The query cache size is above 128 MiB. Big query caches may cause significant overhead that is required to maintain the cache.","recommendation":"Depending on your environment, it might be performance increasing to reduce this value.","justification":"Current query cache size: %s | ADVISOR_formatByteDown(value, 2, 2)"},{"name":"Query cache min result size","precondition":"!fired('Query cache disabled')","formula":"query_cache_limit","test":"value == 1024*1024","issue":"The max size of the result set in the query cache is the default of 1 MiB.","recommendation":"Changing {query_cache_limit} (usually by increasing) may increase efficiency. This variable determines the maximum size a query result may have to be inserted into the query cache. If there are many query results above 1 MiB that are well cacheable (many reads, little writes) then increasing {query_cache_limit} will increase efficiency. Whereas in the case of many query results being above 1 MiB that are not very well cacheable (often invalidated due to table updates) increasing {query_cache_limit} might reduce efficiency.","justification":"query_cache_limit is set to 1 MiB"}],"errors":[]}}