[B! tuning] kazukichopã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kazukichop id:kazukichop

tuningã«é–¢ã™ã‚‹kazukichopã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

å®ŸéŒ²MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ˜¥ã®é™£ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
long_query_time = 0.5 ã¨ã‹é–¾å€¤ã‚’å°ã•ã‚ã«ã—ã¦ã‚‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒå‡ºãªããªã£ãŸã‘ã©ã€CPU(user)ä½¿ç”¨çŽ‡é«˜ã„ã¨ã‹ã€ãªã‚“ã‹è¶³å¼•ã£å¼µã£ã¦ã‚‹ã‚¯ã‚¨ãƒªãŒã‚ã‚‹ã£ã½ã„ãªãã¨ã„ã†å ´åˆã®ãŠè©±ã§ã™ã€‚ ã€Œå®ŸéŒ²ã€ã®é€šã‚Šã€ç¾åœ¨çµ¶è³›é€²è¡Œä¸ã§ã™ã®ã§ã€é€æ¬¡å‹•ããŒã‚ã£ãŸã‚‰æ›¸ãè¶³ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ã€‚ ã€Œã‚ã‚Œã‚’è¦‹ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã€Œã“ã‚Œã‚’ã‚ãƒ¼ã—ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã‚ã‚Œã°ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹Twitterã§ @hirose31 ã¾ã§ãŠçŸ¥ã‚‰ã›ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ï¼ ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã¯ã€MySQL 5.1.41 ã§ã™ã€‚ å‰æ: ã‚µãƒ¼ãƒãƒ¼ãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ• Gangliaã§ã‚‚Cactiã§ã‚‚Muninã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ•åŒ–ã¯å¿…é ˆã§ã™ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸéš›ã®åŠ¹æžœæ¸¬å®šã‚„ã€ãã‚ãã‚ãƒªã‚½ãƒ¼ã‚¹é£Ÿã„æ½°ã—ã¦ã‚„ã°ã„ã¨ã‹ã®äºˆæ¸¬ã«ã‚‚ä½¿ãˆã¾ã™ã€‚ è‡ªåˆ†ã¯DBã‚µãƒ¼ãƒã®å ´åˆã“ã®ã‚ãŸã‚Šã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã¾ã™ã€‚ CPUä½¿ç”¨çŽ‡ (user,
kazukichop 2010/05/18
mysql

tuning
ãƒªãƒ³ã‚¯
ç¬¬2éƒ¨ç¬¬3å›žã€€ãƒãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ã‚¹ã‚¯ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆãã®1ï¼‰
IAã‚µãƒ¼ãƒãƒ¼ã«é™ã‚‰ãšï¼Œä¸€èˆ¬çš„ã«ï¼Œæœ€ã‚‚ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚Šã‚„ã™ã„ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã¨ã—ã¦ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ï¼ˆãƒãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ãƒ‰ãƒ©ã‚¤ãƒ–ã‚’å«ã‚€ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼‰ãŒã‚ã‚‹ã€‚ãƒãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ãƒ‰ãƒ©ã‚¤ãƒ–ã¯ã‚µãƒ¼ãƒãƒ¼ã®ä¸ã§æ•°å°‘ãªã„æ©Ÿæ¢°ä»•æŽ›ã‘ã§å‹•ä½œã™ã‚‹ï¼Œæœ€ã‚‚ä½Žé€Ÿãªã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚‹ã€‚ãã®ãŸã‚ï¼Œé©åˆ‡ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ãªã„ã¨ï¼Œãƒ‡ãƒ¼ã‚¿ã®å‡¦ç†ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒé…ããªã£ã¦ã—ã¾ã†ã€‚é€†ã«ï¼Œé©åˆ‡ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ–½ã—ã¦ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼ŒåŠ‡çš„ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã‚’å›³ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã€‚ãƒãƒ¼ãƒ‰ã‚¦ã‚¨ã‚¢ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦ã¯æœ€ã‚‚æ³¨æ„ã‚’æ‰•ã†ã«å€¤ã™ã‚‹ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã ã€‚ ã“ã“ã§ï¼Œã“ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã ã‘ãƒ‡ã‚£ã‚¹ã‚¯â€œã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ â€ã¨è¨˜è¿°ã—ã¦ã„ã‚‹ç†ç”±ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ãŠãã€‚ã‚µãƒ¼ãƒãƒ¼ã§ã¯ï¼ŒATAãƒãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ãƒ‰ãƒ©ã‚¤ãƒ–ã‚„ SCSIãƒãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ãƒ‰ãƒ©ã‚¤ãƒ–ã‚’å˜ä½“ã§ä½¿ç”¨ã™ã‚‹ã®ã§ã¯ãªãï¼Œå¾Œè¿°ã™ã‚‹RAIDã‚’ç”¨ã„ã¦è¤‡æ•°ã®ç‰©ç†ãƒ‡ã‚£ã‚¹ã‚¯ã‚’1
kazukichop 2008/06/19
linux

tuning
ãƒªãƒ³ã‚¯
ç¬¬1éƒ¨ç¬¬2å›žã€€ãƒ—ãƒã‚°ãƒ©ãƒ ã®å®Ÿè¡Œé€Ÿåº¦ã‚’é€Ÿã‚ã‚‹
ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãã®ã‚‚ã®ã®å®Ÿè¡Œã‚’é«˜é€ŸåŒ–ã™ã‚‹ã“ã¨ã§ã‚‚ã‚·ã‚¹ãƒ†ãƒ ãƒ»ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã§ãã‚‹ã€‚ã—ã‹ã—ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãæ›ãˆã¦é«˜é€ŸåŒ–ã‚’è¡Œã†ã«ã¯ï¼Œé«˜åº¦ãªçŸ¥è˜ãŒå¿…è¦ã«ãªã‚Šé›£ã—ã„ã€‚æ‰‹é–“ã‚‚å¿…è¦ã«ãªã‚‹ã€‚ã“ã“ã§ã¯ï¼Œã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ™‚ã«ä½¿ç”¨ãƒ—ãƒã‚»ãƒƒã‚µç‰ã«åˆã‚ã›ãŸæœ€é©åŒ–å‡¦ç†ã‚’æ–½ã™æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ã¾ãŸï¼Œå®Ÿè¡Œãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’ç¸®å°ã—ã¦ï¼Œä¸»ã«èµ·å‹•æ™‚é–“ã‚’é«˜é€Ÿã«ã™ã‚‹æ‰‹æ³•ã‚‚è§£èª¬ã™ã‚‹ã€‚ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã«ã‚ˆã‚‹æœ€é©åŒ–ã§ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’é«˜é€ŸåŒ– ãƒãƒ¼ãƒ‰ã‚¦ã‚¨ã‚¢ã‚’å¤‰æ›´ã›ãšã«ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã®å®Ÿè¡Œé€Ÿåº¦ã‚’å¤§ããæ”¹å–„ã™ã‚‹ã«ã¯ï¼Œãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãæ›ãˆã‚‹æ–¹æ³•ãŒã‚ã‚‹ã€‚ãƒ—ãƒã‚°ãƒ©ãƒ ã§æŽ¡ç”¨ã™ã‚‹ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’ã‚ˆã‚Šé«˜é€Ÿãªã‚‚ã®ã«ã™ã‚‹ãªã©ã®æ”¹è‰¯ãŒåŠ¹æžœçš„ã§ã‚ã‚‹ãŒï¼Œã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æŠ€æ³•ã«ç²¾é€šã—ã¦ã„ãªã‘ã‚Œã°ã“ã†ã—ãŸæ›¸ãæ›ãˆã¯é›£ã—ã„ã“ã¨ãŒå¤šã„ã€‚ ãã“ã§ï¼Œãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãæ›ãˆãšã«æ‰‹è»½ã«é«˜é€ŸåŒ–ã‚’å®Ÿç¾ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ï¼Œã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã®æœ€é©åŒ–æ©Ÿèƒ½ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ ãŒï¼Œã‚ˆã‚Šé«˜é€Ÿã«å‹•ä½œã™ã‚‹ã‚ˆã†ã«ï¼Œ
kazukichop 2008/06/05
linux

tips

tuning
ãƒªãƒ³ã‚¯
Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€€ç¬¬1éƒ¨ç¬¬1å›žã€€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’é«˜é€ŸåŒ–ï¼šITpro
ãƒ•ã‚¡ã‚¤ãƒ«ã®å…¥å‡ºåŠ›æ€§èƒ½ã®æ”¹å–„ã¯ï¼Œã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®å‡¦ç†é€Ÿåº¦å‘ä¸Šã«å¤§ããè²¢çŒ®ã™ã‚‹ã€‚é«˜é€Ÿãªãƒ—ãƒã‚»ãƒƒã‚µã‚’æè¼‰ã™ã‚‹ç¾åœ¨ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã§ã¯ï¼Œãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¢ã‚¯ã‚»ã‚¹é€Ÿåº¦ãŒã‚·ã‚¹ãƒ†ãƒ ãƒ»ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„ã‚‹ãŸã‚ã§ã‚ã‚‹ã€‚ä¸è¦ãªãƒ‡ã‚£ã‚¹ã‚¯ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã®å‰Šæ¸›ã¨ã‚¢ã‚¯ã‚»ã‚¹é€Ÿåº¦ãã®ã‚‚ã®ã®å‘ä¸ŠãŒï¼Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã¨ãªã‚‹ã€‚ ã‚¢ã‚¯ã‚»ã‚¹æ™‚åˆ»ã®è¨˜éŒ²ã‚’çœç•¥ã—ãƒ•ã‚¡ã‚¤ãƒ«èªã¿è¾¼ã¿ã‚’é«˜é€ŸåŒ– ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸã¨ãã«ã¯ï¼Œæœ€çµ‚ã‚¢ã‚¯ã‚»ã‚¹æ™‚åˆ»ãŒå±žæ€§æƒ…å ±ã¨ã—ã¦è¨˜éŒ²ã•ã‚Œã‚‹ã€‚ã“ã®æƒ…å ±ã‚’è¨˜éŒ²ã—ãªã„ã‚ˆã†ã«è¨å®šã™ã‚‹ã“ã¨ã§ï¼Œãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿é€Ÿåº¦ã‚’å‘ä¸Šã§ãã‚‹ã€‚æœ€çµ‚ã‚¢ã‚¯ã‚»ã‚¹æ™‚åˆ»ã®è¨˜éŒ²ã‚’æ¢ã‚ã‚‹ã«ã¯ï¼Œãƒ•ã‚¡ã‚¤ãƒ«ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®ãƒžã‚¦ãƒ³ãƒˆæ™‚ã«ï¼Œnoatimeã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹ã€‚ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ã¯ï¼Œèªã¿è¾¼ã¿é€Ÿåº¦ãŒ2å€å¼·ã«æ”¹å–„ã§ããŸã€‚ atimeã¯ç„¡é§„ Linuxãªã©ã®UNIXç³»OSã§ã¯ï¼Œstatã‚„fstatï¼Œlstatã¨ã„ã†ã‚·ã‚¹ãƒ†ãƒ ãƒ»ã‚³ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ï¼Œãƒ•ã‚¡ã‚¤ãƒ«ã®å±žæ€§æƒ…å ±
kazukichop 2008/06/05
linux

tuning

tips
ãƒªãƒ³ã‚¯
PHP ã‚³ãƒ¼ãƒ‰æœ€é©åŒ– Best Practices 63+ - ã‚«ã‚¿ã‚³ãƒˆæ—¥è¨˜
ã¿ãŸã„ãªã‚¿ã‚¤ãƒˆãƒ«ã®è¨˜äº‹ã‚’ Digg çµŒç”±ã§ç™ºè¦‹ã€‚ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆä»£ã‚ã‚Šã«ã¨æ€ã„è¶…è¨³ã€‚*1 A Software Architect PHP æœ€é©åŒ– ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ï¼ 01. static ã«ã§ãã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã¯ static ã¨ã—ã¦å®£è¨€ã—ã‚ˆã†ã€‚ï¼ˆ4å€é€Ÿã„ï¼‰ 02. echo ã®æ–¹ãŒ print ã‚ˆã‚Šé€Ÿã„ã€‚ 03. echo 'æ–‡','å—'; ï¼ˆã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šï¼‰ã®æ–¹ãŒã€'æ–‡'.'å—' ï¼ˆãƒ‰ãƒƒãƒˆé€£çµï¼‰ã‚ˆã‚Šé€Ÿã„ã€‚ 04. ãƒ«ãƒ¼ãƒ—ã®æœ€å¤§å€¤ã¯ã€ãƒ«ãƒ¼ãƒ—ã€Œå†…ã€ã§ã¯ãªãã€Œå‰ã€ã«ã‚»ãƒƒãƒˆã—ã¦ãŠã“ã†ã€‚ 05. å¤§ãã„é…åˆ—ã®ã‚ˆã†ãªå¤‰æ•°ã¯ unset() ã—ã¦ãƒ¡ãƒ¢ãƒªã‚’è§£æ”¾ã—ã‚ˆã†ã€‚ 06. ãƒžã‚¸ãƒƒã‚¯ãƒ¡ã‚½ãƒƒãƒ‰ï¼ˆä¾‹ï¼š __get, __set, __autoloadï¼‰ã¯ä½¿ç”¨ã‚’é¿ã‘ã‚ˆã†ã€‚ 07. require_once ã¯ãƒã‚¤ã‚³ã‚¹ãƒˆãªã®ã§ã™ã€‚ 08. include ã‚„ require ã§ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒ•ãƒ«ãƒ‘ã‚¹ã§æŒ‡å®šã—ã‚ˆã†ã€‚ 09
kazukichop 2008/05/26
php

tuning

performance
ãƒªãƒ³ã‚¯
InnoDB Performance Optimization Basics
This blog is in reference to our previous ones for â€˜Innodb Performance Optimizations Basicsâ€™ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7 and 8.0 have been released since then with some major changes. These guidelines work well for
kazukichop 2007/11/02
mysql

innodb

performance

tuning
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
kazukichop 2007/09/15
mysql

innodb

performance

tuning
ãƒªãƒ³ã‚¯
1