[MySQL]インデックスã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€œãƒã‚°å‡ºåŠ›ã€EXPLAINã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€œ - Qiita[mysqld] slow_query_log = 1 #スãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°å‡ºåŠ›æœ‰åŠ¹åŒ– slow_query_log_file = mysql-slow.log #スãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«å long_query_time = 2 #スãƒãƒ¼ã‚¯ã‚¨ãƒªã¨ã—ã¦èªè˜ã•ã›ã‚‹æ™‚é–“[秒] log-long-format #インデックスを使用ã—ã¦ã„ãªã„クエリをãƒã‚°ã«æ®‹ã™ 上記ã®è¨å®šã¯[mysqld]ã®ã¨ã“ã‚ã«æ›¸ã‹ãªã‘ã‚Œã°æ£ã—ã変数åを解決ã—ã¦ãã‚Œãªã„ã®ã§æ³¨æ„。 slow_query_logã¯ONã§ã¯ãªã1ã¨ã—ãªã‘ã‚Œã°ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°å‡ºåŠ›ãŒæœ‰åŠ¹åŒ–ã•ã‚Œãªã„ã®ã§æ³¨æ„。 slow_query_log_fileã®å ´æ‰€ã¯find パスå -name mysql-slow.logã§æ¤œç´¢ã™ã‚Œã°ã‚ã‹ã‚‹ã€‚　→　/var/lib/mysql/mysql-slow.logã«ç”Ÿæˆã•ã‚ŒãŸã€‚ long_query_timeã§è¨å®šã—ãŸç§’数以
![[MySQL]インデックスã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€œãƒã‚°å‡ºåŠ›ã€EXPLAINã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€œ - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/71f740f6eb843f8a11c8663c7007db32f7e4fe6c/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-9f5428127621718a910c8b63951390ad.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTkxNiZoPTMzNiZ0eHQ9JTVCTXlTUUwlNUQlRTMlODIlQTQlRTMlODMlQjMlRTMlODMlODclRTMlODMlODMlRTMlODIlQUYlRTMlODIlQjklRTMlODElQUIlRTMlODIlODglRTMlODIlOEIlRTMlODMlODElRTMlODMlQTUlRTMlODMlQkMlRTMlODMlOEIlRTMlODMlQjMlRTMlODIlQjAlRTMlODAlOUMlRTMlODMlQUQlRTMlODIlQjAlRTUlODclQkElRTUlOEElOUIlRTMlODAlODFFWFBMQUlOJUUzJTgwJTgxJUUzJTgyJUE0JUUzJTgzJUIzJUUzJTgzJTg3JUUzJTgzJTgzJUUzJTgyJUFGJUUzJTgyJUI5JUUzJTgwJTlDJnR4dC1jb2xvcj0lMjMyMTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmdHh0LWNsaXA9ZWxsaXBzaXMmdHh0LWFsaWduPWxlZnQlMkN0b3Amcz02NzMyN2Y0M2UxZTA0ZWZkZjFkZjg4ZTIyYjljNTYxMg%26mark-x%3D142%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTYxNiZ0eHQ9JTQwc2h1bnRhcm9fdGFtdXJhJnR4dC1jb2xvcj0lMjMyMTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9MzYmdHh0LWFsaWduPWxlZnQlMkN0b3Amcz03NTIzZDczZGI1NzYyYzBhZWM5NjZlOGE1NGE3ODU5YQ%26blend-x%3D142%26blend-y%3D491%26blend-mode%3Dnormal%26s%3D78c0c1dac295c4a4e9ea1ab361a7e2b2)
[MySQL] EUCã‹ã‚‰â†’UTF8ã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œãƒ¡ãƒ¢_φ(・・*) - Qiita![[MySQL] EUCã‹ã‚‰â†’UTF8ã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œãƒ¡ãƒ¢_φ(・・*) - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/df1514295b4a97721e6bd507303dd9576bb2be4b/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-9f5428127621718a910c8b63951390ad.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTkxNiZoPTMzNiZ0eHQ9JTVCTXlTUUwlNUQlMjBFVUMlRTMlODElOEIlRTMlODIlODklRTIlODYlOTJVVEY4JUUzJTgxJUI4JUUzJTgzJTg3JUUzJTgzJUJDJUUzJTgyJUJGJUU3JUE3JUJCJUU4JUExJThDJUUzJTgzJUExJUUzJTgzJUEyXyVDRiU4NiUyOCVFMyU4MyVCQiVFMyU4MyVCQiUyQSUyOSZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTU2JnR4dC1jbGlwPWVsbGlwc2lzJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9N2I0OTI5YjA3NzJiMDczNjhiNzQxMGU5NDZkMmFkODU%26mark-x%3D142%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTYxNiZ0eHQ9JTQwaGl0b21pXyZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9NTI0MzRlNzk0Y2M5NzUzNWY5ZGZmMGI1NDJkNjM2MTc%26blend-x%3D142%26blend-y%3D491%26blend-mode%3Dnormal%26s%3Df7ffee6bda1dca79514e620a12cf6951)
http://nekopuni.holy./
開発ä¸ã®iPhoneアプリを自å‰ã‚µãƒ¼ãƒã§é…布ã™ã‚‹æ–¹æ³• - ku-sukeã®ãƒ–ãƒã‚°
phpMyAdminã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ããªã„大ããªãƒ•ã‚¡ã‚¤ãƒ«ã‚’一気ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãる「BigDumpã€
PHP 㨠MySQL ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã« MapReduce ã™ã‚‹
{{#tags}}- {{label}}
{{/tags}}