{"provider_name":"Hatena Blog","height":"190","published":"2021-12-16 08:20:24","title":"\u4eca\u65e5\u306f\u3001mysqldumpslow\u3068\u3044\u3046\u3082\u306e\u304c\u3042\u308b\u306e\u3092\u6700\u8fd1\u77e5\u308a\u307e\u3057\u305f\u306e\u65e5\u3002","author_name":"Updraft","version":"1.0","url":"https://updraft.hatenadiary.com/entry/2021/12/16/082024","type":"rich","categories":["\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9","SQL","MySQL"],"image_url":null,"description":"\u76ee\u6b21 \u76ee\u6b21 \u3068\u3042\u308b\u65e5 mysqldumpslow \u2014 \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u8981\u7d04 \u691c\u8a3c tmp/slow.log mysqldumpslow\u5b9f\u884c \u30aa\u30d7\u30b7\u30e7\u30f3 -a -s -t \u3006 \u3068\u3042\u308b\u65e5 MySQL\u306eslow query\u3092\u5206\u6790\u3059\u308b\u306e\u306bmysqldumpslow\u304c\u3042\u308b\u306e\u3092\u3057\u3063\u305f\u306e\u3067\u8abf\u3079\u307e\u3057\u305f\u3002 mysqldumpslow \u2014 \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u8981\u7d04 MySQL \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u306b\u306f\u3001\u5b9f\u884c\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u30af\u30a8\u30ea\u30fc\u306b\u95a2\u3059\u308b\u60c5\u5831\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059 (\u30bb\u30af\u30b7\u30e7\u30f35.4.5\u300c\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u300d \u3092\u53c2\u7167)\u3002mysqldumpslow \u306f\u3001MySQL \u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30fc\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u89e3\u6790\u3057\u3001\u305d\u306e\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fupdraft.hatenadiary.com%2Fentry%2F2021%2F12%2F16%2F082024\" title=\"\u4eca\u65e5\u306f\u3001mysqldumpslow\u3068\u3044\u3046\u3082\u306e\u304c\u3042\u308b\u306e\u3092\u6700\u8fd1\u77e5\u308a\u307e\u3057\u305f\u306e\u65e5\u3002 - \u4eca\u65e5\u306f\u306a\u306b\u306e\u65e5\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://updraft.hatenadiary.com/","width":"100%","author_url":"https://blog.hatena.ne.jp/Updraft/","blog_title":"\u4eca\u65e5\u306f\u306a\u306b\u306e\u65e5\u3002","provider_url":"https://hatena.blog"}