[ThinkIT] ã¯ã˜ã‚ã¦ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° 第3回：max_connectionsã¨thread_cacheã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’行ㆠ(1/3)å‰å›žã€Œç¬¬2å›žï¼šè² è·ã«ã‚ˆã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’試ã™ã€ã®æ¸¬å®šçµæžœã§ã¯ã€æ¸¬å®šé€”ä¸ã§max_connectionsã«é”ã—ã¦ã—ã¾ã„ã€è¨ˆç”»ã—ã¦ã„ãŸæ¸¬å®šã‚’完了ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ãã“ã§max_connectionsを増やã—ã¦ã€å†åº¦æ¸¬å®šã—ã¦ã¿ã¾ã—ょã†ã€‚ max_connectionsを増やã™ã«ã¯2通りã®æ‰‹æ®µãŒã‚ã‚Šã¾ã™ã€‚ã¾ãšã€Œ/etc/my.cnfã€ã«è¨å®šã‚’追記ã™ã‚‹æ–¹æ³•ã§ã™ã€‚è¨å®šå€¤ã¯450ã«å¤‰æ›´ã—ã¾ã™ã€‚
{{#tags}}- {{label}}
{{/tags}}