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

kamawada id:kamawada

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

${{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}}

ãªãœTwitterã¯ä½Žé…å»¶ã®ã¾ã¾ã‚¹ã‚±ãƒ¼ãƒ«ã§ããŸã®ã‹ ç§’é–“120ä¸‡ã¤ã¶ã‚„ãã‚’å‡¦ç†ã€Twitterã‚·ã‚¹ãƒ†ãƒ ã®â€œä»Šâ€ âˆ’ ï¼ IT
ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’å…ƒã«æ™‚ç³»åˆ—ã«140æ–‡å—ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’20å€‹ã»ã©è¡¨ç¤ºã™ã‚‹â€•â€•ã€‚Twitterã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€æ–‡å—ã«ã—ã¦ã—ã¾ã†ã¨å®Ÿã«ã‚·ãƒ³ãƒ—ãƒ«ã ãŒã€èƒŒå¾Œã«ã¯éžå¸¸ã«å¤§ããªæŠ€è¡“çš„ãƒãƒ£ãƒ¬ãƒ³ã‚¸ãŒæ¨ªãŸã‚ã£ã¦ã„ã‚‹ã€‚ã¤ã¶ã‚„ãæ•°ã¯æœˆé–“10å„„ä»¶ã‚’çªç ´ã€Twitterã‚’æµã‚Œã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸æ•°ã¯ç§’é–“120ä¸‡ã«ã‚‚é”ã—ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼åŒå£«ã®ã¤ãªãŒã‚Šã‚’è¡¨ã™ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ã‚°ãƒ©ãƒ•ã§ã™ã‚‰ãƒ¡ãƒ¢ãƒªã«è¼‰ã‚‹é‡ã‚’è¶…ãˆã¦ã„ã‚‹ã€‚é€”æ–¹ã‚‚ãªã„ã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¤ãªã„ã§ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€0.1ç§’ä»¥ä¸‹ã§Webãƒšãƒ¼ã‚¸ã®è¡¨ç¤ºã‚’å®Œäº†ã•ã›ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ãã®ãŸã‚ã«å„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯1ï½ž5msç¨‹åº¦ã§å¿œç”ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ Twitterã®ãƒªã‚¹ãƒˆæ©Ÿèƒ½ã®å®Ÿè£…ã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒªãƒ¼ãƒ€ãƒ¼ã‚’å‹™ã‚ãŸã“ã¨ã‚‚ã‚ã‚‹Nick Kallenæ°ãŒæ¥æ—¥ã—ã€2010å¹´4æœˆ19æ—¥ã‹ã‚‰2æ—¥é–“ã®äºˆå®šã§é–‹å‚¬ä¸ã®ã€ŒQCon Tokyo 2010ã€ã§åŸºèª¿è¬›æ¼”ã‚’è¡Œã£ãŸã€‚ã€ŒData Architecture
kamawada 2010/04/21
tuning

sharding
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
kamawada 2010/04/07
mysql

tuning

sharding
ãƒªãƒ³ã‚¯
MySQLã®LIMITå¥ã«ã¤ã„ã¦ã®è³ªå•ã§ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0.22ã§ã™ã€‚â€¦
MySQLã®LIMITå¥ã«ã¤ã„ã¦ã®è³ªå•ã§ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0.22ã§ã™ã€‚ ç¾åœ¨DBã«1000ä¸‡ä»¶ã»ã©ã®ç°¡å˜ãªãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œè‰²ã€…ã¨ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ™‚ã€ã©ã†ã—ã¦ã‚‚å‡¦ç†ãŒé…ããªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯ã€ŒLIMITã€ã®ä»•æ§˜ã§ã—ã‚‡ã†ã‹ã€‚ã€Œidã€ã¯ä¸»ã‚ãƒ¼ã§ã€Œhogeã€ã¯ãƒ†ãƒ¼ãƒ–ãƒ«åã§ã™ã€‚ mysql> SELECT * FROM hoge ORDER BY id DESC LIMIT 9000,10; 10 rows in set (8.30 sec) ãªãŠã€ã‚ªãƒ•ã‚»ãƒƒãƒˆã®éƒ¨åˆ†ãŒ0ã€œ1000ãã‚‰ã„ã§ã—ãŸã‚‰å•é¡Œãªã„é€Ÿåº¦ã§ã™ã€‚ mysql> SELECT * FROM hoge ORDER BY id DESC LIMIT 0,10; 10 rows in set (0.00 sec) mysql> SELECT * FROM hoge ORDER BY id DESC LIMIT 100
kamawada 2010/01/19
mysql

tuning
ãƒªãƒ³ã‚¯
livedoor Techãƒ–ãƒã‚° : ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚µãƒ¼ãƒå¢—è¨ã®åŸºæœ¬ï¼ˆ1å°æ§‹æˆã‹ã‚‰ä»®æƒ³åŒ–ã¾ã§ï¼‰
ãŠç–²ã‚Œæ§˜ã§ã™ã€ã‚¹ã‚¨ãƒ’ãƒã§ã™ã€‚ å…ˆæ—¥ç™ºå£²ã•ã‚Œã¾ã—ãŸã€å¼Šç¤¾æŠ€è¡“é™£ãŒåŸ·ç†ã—ãŸã€Œ4Gbpsã‚’è¶…ãˆã‚‹Webã‚µãƒ¼ãƒ“ã‚¹æ§‹ç¯‰è¡“ã€ã€ãŠæ‰‹ã«å–ã£ã¦é ‚ã‘ãŸã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã®è² è·å¯¾ç–ã€åˆ†æ•£æŠ€è¡“ãªã©ã€å®Ÿç”¨çš„ãªè©±ãŒç››ã‚Šã ãã•ã‚“ã®æœ¬æ›¸ã§ã™ãŒã€æœ¬æ—¥ã¯å®Ÿéš›ã«ç¨¼åƒã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚µãƒ¼ãƒã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆæ–¹æ³•ã‚’ã€å¼Šç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã€Œlivedoor ãƒ‹ãƒ¥ãƒ¼ã‚¹ã€ã‚’ä¾‹ã«ã—ã¦ã”ç´¹ä»‹ã—ãŸã„ã¨ãŠã‚‚ã„ã¾ã™ã€‚ 0. å•é¡Œç‚¹ã®æŠŠæ¡ 2003å¹´ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã—ãŸã€Œlivedoor ãƒ‹ãƒ¥ãƒ¼ã‚¹ã€ã§ã™ãŒã€å½“æ™‚ã¯ã‚¢ã‚¯ã‚»ã‚¹æ•°ã€ãƒ‡ãƒ¼ã‚¿é‡ã‚‚å°‘ãªã‹ã£ãŸãŸã‚ã€ã‚µãƒ¼ãƒ1å°ã§é‹ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚ é™çš„ãªç”»åƒã‚„cssã€javascriptã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã™ã‚‹apacheï¼ˆ80ãƒãƒ¼ãƒˆï¼‰ã¨ã€å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã™ã‚‹modperlçµ„ã¿è¾¼ã¿ã®apacheï¼ˆ8080ãƒãƒ¼ãƒˆï¼‰ã‚’åˆ‡ã‚Šåˆ†ã‘ã€mod_rewriteã§ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ã—ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’ãªãŒã—ã¦ã„ã¾ã™ã€‚ãƒªãƒ
kamawada 2009/09/16
tuning
ãƒªãƒ³ã‚¯
ã€ŒYahoo!ãƒ‹ãƒ¥ãƒ¼ã‚¹ã€ã®è¡¨ç¤ºé€Ÿåº¦ãŒ3ï½ž5å€ã«ã€ãã®ã‹ã‚‰ãã‚Šã¯â€¦â€¦ï¼šè¨˜äº‹ã®èŠ½
Pythonã§å®Ÿæ„Ÿã€ã€ŒéŸ³å£°èªè˜ã€ã®ä»•çµ„ã¿ã‚’çŸ¥ã‚‹ Pythonã§éŸ³å£°ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€€æ³¢å½¢è¡¨ç¤ºã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ã”ã¨ã®ç‰¹å¾´é‡è¨ˆç®—ã‚’è©¦ã™ 2024.12.19
kamawada 2009/05/29
tuning
ãƒªãƒ³ã‚¯
javascriptã‚’å¤šç”¨ã—ãŸãƒšãƒ¼ã‚¸ã‚’æ—©ãè¡¨ç¤ºã™ã‚‹ã«ã¯ Â« ku
diggã«ã®ã£ã¦ãŸ Vitamin Features Â» Serving JavaScript Fast ã£ã¦ã„ã†ã€Flickrã® Cal Henderson ã¨ã„ã†ã²ã¨ãŒæ›¸ã„ã¦ãŸè¨˜äº‹ã«ã€æœ€è¿‘ãªã‚“ã¨ã‹ãªã‚“ãªã„ã®ã‹ã¨æ€ã£ã¦ãŸã“ã¨ãŒæ›¸ã‹ã‚Œã¦ã„ã¦ã€ã™ã‚“ã’ãƒ¼ï¼ã¨ã„ã†ã‚ã‘ã§ã™ãè©¦ã—ã¦ã¿ãŸã‚‰ç¢ºã‹ã«ãã®é€šã‚Šã«ãªã£ã¦æœ€é«˜ã§ã—ãŸã€‚ Serving JavaScript Fast ã£ã¦ãªã‚“ã®ã“ã¨ï¼Ÿã¨ã„ã†ã‹ã‚“ã˜ã ã‘ã©ã€è¦ã™ã‚‹ã«ã„ã¾ã©ããªWEBãƒšãƒ¼ã‚¸ã¯CSSã¨ã‹javascriptã¨ã‹ãŸãã•ã‚“ä½¿ã£ã¦ã„ã¦ã€ãƒšãƒ¼ã‚¸ã®ãƒãƒ¼ãƒ‰ãŒå®Œäº†ã™ã‚‹ã¾ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã‹ã‚‰ãªã‚“ã¨ã‹ã—ãŸã„ã‚ˆãã€ã¨ã„ã†è©±ã€‚ CSSã‚‚javascriptã‚‚ä¸€åº¦èªã¿è¾¼ã‚ã°ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã‚Œã‚‹ã‹ã‚‰ã„ã„ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿ ãŸã—ã‹ã«ã€‚ã—ã‹ã—ãƒ–ãƒ©ã‚¦ã‚¶ã¯æ¯Žå›žæ›´æ–°ã•ã‚ŒãŸã‹ã©ã†ã‹ã‚’ç¢ºèªã—ã«è¡Œã£ã¦ã€æ›´æ–°ã•ã‚Œã¦ãªã„ã€ã¨ã„ã†ç”ãˆã‚’ã‚‚ã‚‰ã£ã¦ã‹ã‚‰è‡ªåˆ†ãŒæŒã£ã¦ã„ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã™
kamawada 2009/04/26
tuning
ãƒªãƒ³ã‚¯
WindowsXPé«˜é€ŸåŒ–ã®ãŸã‚ã®è¨å®šãªã©ã‚’å…¬é–‹ã—ã¦ã¿ã‚‹ - GeekãªNooblog
WindowsXPã®é«˜é€ŸåŒ–ã®ãŸã‚ã®è¨å®šã‚’ä¸è¦ªåˆ‡ã«ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ ä»¥ä¸‹ã®å€¤ãŒå˜åœ¨ã—ãªã„å ´åˆã¯å³ã‚¯ãƒªãƒƒã‚¯ã‹ã‚‰æ–°è¦ä½œæˆã‚’ã—ã¦ãã ã•ã„ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šã—ã¦å®Ÿè¡Œ regedit ã§ãƒ¬ã‚¸ã‚¹ãƒˆãƒªã‚¨ãƒ‡ã‚£ã‚¿ã‚’èµ·å‹• ã©ã†ã‚„ã‚‰IoPageLockLimitã®è¨å®šã¯æ„å‘³ãŒãªã„ã‚ˆã†ã§ã™ã€‚ è©³ã—ãã¯ã“ã¡ã‚‰ é»’ç¿¼çŒ«ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿æ—¥è¨˜ 2nd Edition:é–“é•ã„ã ã‚‰ã‘ã® Windows ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ãã®ï¼’ (IoPageLockLimit) - Windows 2000 Blog http://w2k.livedoor.biz/archives/880676.html ãƒ¡ãƒ¢ãƒªé–¢é€£ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Managementã‚’é–‹ã ã‚«ãƒ¼ãƒãƒ«ãƒ¡ãƒ¢ãƒªã‚’ç‰©ç†ãƒ¡ãƒ¢ãƒªã«ç½®ã DisablePagi
kamawada 2009/02/26
windows

tuning
ãƒªãƒ³ã‚¯
Linux ã®ãƒ—ãƒã‚»ã‚¹ãŒ Copy on Write ã§å…±æœ‰ã—ã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®ã‚µã‚¤ã‚ºã‚’èª¿ã¹ã‚‹
Linux ã¯ fork ã§åãƒ—ãƒã‚»ã‚¹ã‚’ä½œæˆã—ãŸå ´åˆã€è¦ªã®ä»®æƒ³ãƒ¡ãƒ¢ãƒªç©ºé–“ã®å†…å®¹ã‚’åã¸ã‚³ãƒ”ãƒ¼ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã—ã‹ã—ã¾ã¨ã‚‚ã«å…¨ç©ºé–“ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã„ãŸã®ã§ã¯ fork ã®ã‚³ã‚¹ãƒˆãŒé«˜ããªã£ã¦ã—ã¾ã„ã¾ã™ã—ã€åãŒè¦ªã¨åŒã˜ã‚ˆã†ãªãƒ—ãƒã‚»ã‚¹ã¨ã—ã¦å‹•ä½œã—ç¶šã‘ã‚‹å ´åˆã¯ã€å†…å®¹ã®é‡è¤‡ã—ãŸãƒšãƒ¼ã‚¸ãŒå¤šæ•°ã§ãã¦ã—ã¾ã„ã€åŠ¹çŽ‡ãŒã‚ˆãã‚ã‚Šã¾ã›ã‚“ã€‚ ãã“ã§ã€Linux ã®ä»®æƒ³ãƒ¡ãƒ¢ãƒªã¯ã€ãƒ¡ãƒ¢ãƒªç©ºé–“ã‚’èˆã‚ã¦ã‚³ãƒ”ãƒ¼ã™ã‚‹ã®ã§ã¯ãªãã€ã¯ã˜ã‚ã¯è¦ªåã§ãƒ¡ãƒ¢ãƒªé ˜åŸŸã‚’å…±æœ‰ã—ã¦ãŠã„ã¦ã€æ›¸ãè¾¼ã¿ãŒã‚ã£ãŸæ™‚ç‚¹ã§ã€ãã®æ›¸ãè¾¼ã¿ã®ã‚ã£ãŸãƒšãƒ¼ã‚¸ã ã‘ã‚’è¦ªåã§å€‹åˆ¥ã«æŒã¤ã¨ã„ã†ä»•çµ„ã¿ã§ã“ã®å•é¡Œã‚’å›žé¿ã—ã¾ã™ã€‚Copy-On-Write (CoW) ã¨å‘¼ã°ã‚Œã‚‹æˆ¦ç•¥ã§ã™ã€‚å…±æœ‰ãƒ¡ãƒ¢ãƒªãƒšãƒ¼ã‚¸ã¯ã€è¦ªåãã‚Œãžã‚Œã®ä»®æƒ³ãƒ¡ãƒ¢ãƒªç©ºé–“ã‚’åŒä¸€ã®ç‰©ç†ãƒ¡ãƒ¢ãƒªã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹ã“ã¨ã§å®Ÿç¾ã•ã‚Œã¾ã™ã€‚ã‚ˆã‚Šè©³ã—ãã¯ ã‚³ãƒ”ãƒ¼ã‚ªãƒ³ãƒ©ã‚¤ãƒˆ - Wikipedia ãªã©ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã“ã® CoW ã«
kamawada 2009/02/25
apache

tuning
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
kamawada 2009/02/18
mysql

tuning
ãƒªãƒ³ã‚¯
Adobe: Creative, marketing and document management solutions
kamawada 2008/06/13
flashlite

tuning
ãƒªãƒ³ã‚¯
Adobe - ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚»ãƒ³ã‚¿ãƒ¼ : Flash Liteã®ãƒ¡ãƒ¢ãƒªç®¡ç†ã¨æœ€é©åŒ–
ãƒ¡ãƒ¢ãƒªã‚’åŠ¹çŽ‡ã‚ˆãä½¿ç”¨ã™ã‚‹ãŸã‚ã®æœ€é©åŒ– ç”»åƒã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŠã‚ˆã³å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒ¼ãƒ‰ã¨ã‚¢ãƒ³ãƒãƒ¼ãƒ‰ã‚’é€£ç¶šã—ã¦å®Ÿè¡Œã—ãªã„ã§ãã ã•ã„ã€‚ç¶šã‘ã¦å®Ÿè¡Œã™ã‚‹ã¨ã€ã‚¬ãƒ™ãƒ¼ã‚¸ã‚³ãƒ¬ã‚¯ã‚¿ã‚µã‚¤ã‚¯ãƒ«ãŒäºˆå®šé€šã‚Šã«å®Œäº†ã•ã‚Œãšã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€æ¬¡ã®ã‚ˆã†ã«ï¼“ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒåŒã˜ã‚µã‚¤ã‚ºã§ã‚‚ã€ï¼’ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã—ã‹ãƒ¡ãƒ¢ãƒªã‚’ä½¿ç”¨ã§ããªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ï¼‘ã‚’ãƒãƒ¼ãƒ‰ ãƒ•ã‚¡ã‚¤ãƒ«ï¼‘ã‚’å‰Šé™¤ ãƒ•ã‚¡ã‚¤ãƒ«ï¼’ã‚’ãƒãƒ¼ãƒ‰ ãƒ•ã‚¡ã‚¤ãƒ«ï¼’ã‚’å‰Šé™¤ ãƒ•ã‚¡ã‚¤ãƒ«ï¼“ã‚’ãƒãƒ¼ãƒ‰ ãƒãƒ¼ãƒ‰ãŒå¤±æ•—ã™ã‚‹å¯èƒ½æ€§ã‚ã‚Š ä¸Šã®ã‚·ãƒŠãƒªã‚ªã¯ãŠå‹§ã‚ã§ãã¾ã›ã‚“ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ï¼‘ã‚’ãƒãƒ¼ãƒ‰ ãƒ•ã‚¡ã‚¤ãƒ«ï¼‘ã‚’å‰Šé™¤ 60ç§’å¾…ã¤ï¼ˆsetintervalã‚’ä½¿ç”¨ï¼‰ ãƒ•ã‚¡ã‚¤ãƒ«ï¼’ã‚’ãƒãƒ¼ãƒ‰ ãƒ•ã‚¡ã‚¤ãƒ«ï¼’ã‚’å‰Šé™¤ ãƒ•ã‚¡ã‚¤ãƒ«ï¼“ã‚’ãƒãƒ¼ãƒ‰ ãƒãƒ¼ãƒ‰ãŒæˆåŠŸã™ã‚‹å¯èƒ½æ€§ãŒé«˜ã„ ã“ã®å ´åˆã¯ã€ã‚¬ãƒ™ãƒ¼ã‚¸ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ãŒæ‰‹é †ã€Œbã€ã¨ã€Œdã€ã®é–“ã§è¡Œã‚ã‚Œã€ãƒ¡ãƒ¢ãƒªãŒå†ä½¿ç”¨ã•ã‚Œã¾ã™ã€‚ å¿…è¦ã®ãªããªã£ãŸå¤‰æ•°ã¯å‰Šé™¤ã™ã‚‹
kamawada 2008/06/12
actionscript

flashlite

tuning
ãƒªãƒ³ã‚¯
http://livedocs.adobe.com/flashlite/2_jp/main/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts_wEcute&file=00000090.html
kamawada 2008/06/11
flash

todo

tuning
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/mysql_show_status.php
kamawada 2008/06/10
mysql

tuning
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸé«˜é€ŸåŒ–ã«ã¤ã„ã¦(ORDERD BYã«ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ä¾‹) - LukeSilviaâ€™s diary
ä»Šå›žã¯ã€MySQLã®é«˜é€ŸåŒ–ã®ãƒ¡ãƒ¢ - @luke_silvia.diaryã®æ–¹æ³•ã«å¾“ã£ã¦ã‚¯ã‚¨ãƒªã®é«˜é€ŸåŒ–ã‚’ã—ãŸéš›ã«ã€MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é«˜é€ŸåŒ–å¯¾è±¡ã®ã‚¯ã‚¨ãƒª ä»Šå›žé«˜é€ŸåŒ–ã—ãŸã„ã‚¯ã‚¨ãƒªã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã€‚ SELECT users.*, students.school, workers.school FROM users LEFT JOIN students ON users.id = students.user_id LEFT JOIN workers ON users.id = workers.user_id WHERE (users.status= 1 AND ((kind = 0 AND students.school = 'test') OR (kind = 1 AND workers.school = 'test'))) ORDER BY
kamawada 2008/04/20
mysql

tuning
ãƒªãƒ³ã‚¯
MySQL ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - kozy.heteml.jp
ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆæ™‚ â€ mysql> CREATE TABLE index_test_tbl1( -> id INT PRIMARY KEY AUTO_INCREMENT, -> name CHAR(50), -> INDEX idx(id) -> ); â†‘ æ—¢å˜ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ â€ CREATE INDEX ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å ON ãƒ†ãƒ¼ãƒ–ãƒ«å(ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å); mysql> CREATE TABLE index_test_tbl2( -> id INT PRIMARY KEY AUTO_INCREMENT, -> name CHAR(50) -> ); Query OK, 0 rows affected (0.01 sec) mysql> CREATE INDEX idx ON index_test_tbl2(id); Query OK, 0 rows affected (0.04
kamawada 2008/04/20
mysql

tuning
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
kamawada 2008/04/19
mysql

tuning
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬8å›ž MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šITpro
SlowLogã®è¨å®š ç’°å¢ƒè¨å®šãƒ•ã‚¡ã‚¤ãƒ«(Windowsã§ã¯my.iniï¼ŒLinuxã§ã¯my.cnf)ã«æ¬¡ã®ã‚ˆã†ãªè¨å®šã‚’åŠ ãˆã‚‹ã¨SlowLogãŒæœ‰åŠ¹ã«ãªã‚‹ã€‚ log-slow-queries SlowLogã®æœ‰åŠ¹åŒ–(ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šå¯èƒ½) long-query-time=2 SlowLogã«è¨˜éŒ²ã™ã‚‹å‡¦ç†æ™‚é–“ã®ä¸Šé™ log-long-format ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã®è¨˜éŒ² long-query-timeãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ï¼ŒSlowLogã«è¨˜éŒ²ã™ã‚‹ã—ãã„å€¤ã‚’ç§’å˜ä½ã§è¨å®šã™ã‚‹ã€‚ã“ã®å ´åˆã«ã¯ï¼Œ2ç§’è¶…ãˆã‚‹å‡¦ç†æ™‚é–“ã‚’è²»ã‚„ã—ãŸSQLæ–‡ã‚’è¨˜éŒ²ã™ã‚‹ã€‚ã¾ãŸï¼Œlog-long-formatã‚’æŒ‡å®šã™ã‚‹ã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã‚‚SlowLogã«è¨˜éŒ²ã™ã‚‹ã€‚ SlowLogã®ç¢ºèª SlowLogãŒå‹•ä½œã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã¯ï¼Œæ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã‚‹ã€‚log_slow_queriesãŒONã§ã‚ã‚Œã°æœ‰åŠ¹ã¨
kamawada 2008/04/05
mysql

tuning

todo
ãƒªãƒ³ã‚¯
Identity Manager, Reconciliation small Test #2. | WebLog about me.
Identity Manager, Reconciliation small Test #2. å‰å›žã®ãƒ†ã‚¹ãƒˆã§ã€Web Containerã¨MySQLã‚’åˆ¥ã®ãƒžã‚·ãƒ³ã«ç§»ã—ã¦ã‚‚ã€MySQLå´ã®CPUè² è·ã®é«˜ã•ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚Šèª¿æ•´æ©Ÿèƒ½ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ä¸ŠãŒã‚‰ãªã‹ã£ãŸã®ã§ã€åŒã˜çŠ¶æ³ã§ã€MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã„ã¾ã—ãŸã€‚ MySQLã®support-filesãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯ã€my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒä½•ãƒ‘ã‚¿ãƒ¼ãƒ³ã‹å«ã¾ã‚Œã¦ãŠã‚Šã€ãã®ä¸ã®ã€ my-innodb-heavy-4G.cnf ã‚’ä½¿ç”¨ã—ã¦ã€å†åº¦åŒã˜ãƒ†ã‚¹ãƒˆã‚’è¡Œã„ã¾ã—ãŸã€‚ ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸ã®ã€innodb_buffer_pool_size = 2Gï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ8Mï¼‰ ã¨query_cache_size = 64Mã¨ã„ã†è¨å®šã¯åŠ¹æžœãŒæœŸå¾…ã§ãã‚‹ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®innodb_buffer_pool_size
kamawada 2008/04/01
mysql

tuning
ãƒªãƒ³ã‚¯
bk-mysql
ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯æœ€è¿‘ãƒ¡ãƒ³ãƒ†ã•ã‚Œã¦ã„ãªã„é …ç›®ãŒæ•°å¤šãã‚ã‚Šã¾ã™ã€‚ ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ãŸã‚Šã€ç¾çŠ¶ã®mysqlã§ã¯ç›´ã£ã¦ã„ãŸã‚Šã€å¤‰æ›´ã•ã‚Œã¦ã„ã‚‹å¯èƒ½æ€§ãŒå¤šã€…ã€‚ ãã®ç‚¹ã ã‘æ³¨æ„ã—ã¦ä¸‹ã•ã„ã€‚ InnoDBã¸ç§»è¡Œã™ã‚‹éš›ã«æŠŠæ¡ã—ã¦ãŠã‹ãªãã¦ã¯ã„ã‘ãªã„äº‹affected_rowsã¯è‹±èªžã§ã€Œå½±éŸ¿ã‚’å—ã‘ãŸè¡Œæ•°ã€ã¨ã„ã†æ„å‘³ç–‘ä¼¼csvå½¢å¼ã§å‡ºåŠ›ã™ã‚‹ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã®æ§‹ç¯‰æ™‚ã®ãƒˆãƒ©ãƒ–ãƒ«ãªã‚“ã‹ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã‘ã©mysqlãŒé‡ã„æ™‚mysql_use_result()ã¨mysql_store_result()ã®é•ã„SHOW TABLE STATUS;my.cnfDBã®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨VARCHAR(n)ã®é–¢ä¿‚ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¸€è¡Œã ã‘mysqldumpã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒç ´æã—ãŸæ™‚ã«mysqlã‚’ã¨ã‚ãšã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹å ´åˆã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãªã‚“ã‹ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã‘ã©ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸæ™‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã‚’ã€CREATE TABLEãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§
kamawada 2008/04/01
mysql

tuning
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®å‚™å¿˜éŒ² | Mï½™SQL - sleepãƒ—ãƒã‚»ã‚¹ãŒæºœã¾ã‚‹2
MySQL4.0ç³»ã‚’ä½¿ã£ã¦ã„ã‚‹ã‚µãƒ¼ãƒãƒ¼ã§ã¾ãŸsleepãƒ—ãƒã‚»ã‚¹ãŒæºœã¾ã‚‹ç¾è±¡ãŒç™ºç”Ÿã—ãŸã€‚ ä»Šå›žã¯æ™‚é–“ãŒçµŒéŽã—ã¦ã„ãã¨ä¸€ã¤ä¸€ã¤ã®ãƒ—ãƒã‚»ã‚¹ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ãŒå¢—ãˆã¦ã„ãã®ãŒå•é¡Œã€‚ä»Šã¾ã§ãã‚“ãªã«é‡ããªã‹ã£ãŸã®ã«æ€¥ã«LAãŒå¹³å‡10ãã‚‰ã„ã«ãªã£ãŸã‚ˆãƒ»ãƒ»ãƒ»orz ã¾ãŸsleepã‹ã‚ˆã¨ã‹æ€ã£ã¦ã€ŒMySQL sleepã€ã§ããã£ãŸã‚‰2ç•ªç›®ã«ã“ã®ãƒ–ãƒã‚°ã§æ›¸ã„ãŸè¨˜äº‹ãŒå‡ºã¦ããŸorz ãã®æ™‚ã¨åŒã˜æ–¹æ³•ã§è§£æ±ºå‡ºæ¥ãªã•ãã†ãªã®ã§ã€ã‚‚ã†ã¡ã‚‡ã£ã¨æ·±ã„ã¨ã“ã¾ã§çªã£è¾¼ã‚“ã§ã¿ãŸã€‚ sleepãƒ—ãƒã‚»ã‚¹ãŒæºœã¾ã‚‹ã¨ã€show processlist;ã‚’å®Ÿè¡Œã—ãŸå ´åˆã‚„phpMyAdminã§ãƒ—ãƒã‚»ã‚¹ã‚’è¡¨ç¤ºã—ãŸå ´åˆã«ã™ãåˆ†ã‹ã‚‹ã€‚ ä¸‹è¨˜ã¯phpMyAdminã§ãƒ—ãƒã‚»ã‚¹ã‚’è¡¨ç¤ºã—ãŸä¾‹ sleepã°ã£ã‹ã‚Šã§ã™ã€‚ã¨ã„ã†ã‹sleepã—ã‹ã‚ã‚Šã¾ã›ã‚“orzã€‚ ã“ã†ã„ã†çŠ¶æ³ãŒç¶šãã¨ã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã£ã¦ã¯å•é¡ŒãŒèµ·ãã¾ã™ã€‚ï¼ˆä»Šå›žãŒã¾ã•ã«ãã†ï¼‰ ã˜ã‚ƒã‚ã“ã®sleepã£ã¦
kamawada 2008/04/01
mysql

tuning
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸