{"description":"MySQL \u3067 log_queries_not_using_indexes \u3092 1 \u306b\u8a2d\u5b9a\u3059\u308b\u3068\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u30ed\u30b0\u304c\u51fa\u529b\u3055\u308c\u308b\uff08\u30c7\u30d5\u30a9\u30eb\u30c8\u306f 0 \u3067\u7121\u52b9\uff09\u3002 \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u306f\u3001\u5b9f\u884c\u306b\u8981\u3057\u305f\u6642\u9593\u304c long_query_time \u79d2\u3092\u8d85\u3048\u3001 \u5c11\u306a\u304f\u3068\u3082 min_examined_row_limit \u884c\u3092\u691c\u67fb\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u69cb\u6210\u3055\u308c\u307e\u3059\u3002 long_query_time \u306e\u6700\u5c0f\u5024\u304a\u3088\u3073\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u306f\u3001\u305d\u308c\u305e\u308c 0 \u304a\u3088\u3073 10 \u3067\u3059\u3002 \uff08\u4e2d\u7565\uff09 \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u306b\u66f8\u304d\u8fbc\u307e\u308c\u308b\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u3001 \u884c\u53c2\u7167\u306b\u3064\u3044\u3066\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u30af\u30a8\u30ea\u30fc\u3092\u542b\u3081\u308b\u306b\u306f\u3001\u2026","blog_title":"ablog","title":"MySQL \u306e log_queries_not_using_indexes \u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u672a\u4f7f\u7528\u306e\u30af\u30a8\u30ea\u3092\u30ed\u30b0\u51fa\u529b\u3059\u308b","blog_url":"https://yohei-a.hatenablog.jp/","version":"1.0","author_url":"https://blog.hatena.ne.jp/yohei-a/","image_url":null,"categories":["MySQL"],"type":"rich","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20201014%2F1602651344\" title=\"MySQL \u306e log_queries_not_using_indexes \u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u672a\u4f7f\u7528\u306e\u30af\u30a8\u30ea\u3092\u30ed\u30b0\u51fa\u529b\u3059\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://yohei-a.hatenablog.jp/entry/20201014/1602651344","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","published":"2020-10-14 13:55:44","author_name":"yohei-a","width":"100%"}