[B! DB][æœ€é©åŒ–] restartrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

restartr id:restartr

DBã¨æœ€é©åŒ–ã«é–¢ã™ã‚‹restartrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

Top 20+ MySQL Best Practices | Envato Tuts+
Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. In this article, I'll list some MySQL optimization techniques for programmers. Before we start,
restartr 2009/11/26
*é–‹ç™º

mysql

æœ€é©åŒ–

db

sql

tips
ãƒªãƒ³ã‚¯
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(),
restartr 2009/09/30
*ã‚µãƒ¼ãƒãƒ¼

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

æœ€é©åŒ–

é«˜é€ŸåŒ–

sql

DB
ãƒªãƒ³ã‚¯
ç±³å¤§çµ±é ˜é¸ã§MySQLã¯ã©ã®ã‚ˆã†ã«ä½¿ã‚ã‚ŒãŸã®ã‹
æ—¥æœ¬ã®è¡†è°é™¢é¸æŒ™ãŒé–“è¿‘ã«è¿«ã£ã¦ã„ã¾ã™ãŒã€æ˜¨å¹´ç±³å›½ã§è¡Œã‚ã‚ŒãŸå¤§çµ±é ˜é¸ã«ãŠã„ã¦ã€ã‚ªãƒãƒžé™£å–¶ãŒIT æŠ€è¡“ã‚’é§†ä½¿ã—ãŸã¨ã„ã†è©±ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚MySQLã‚‚ã‚‚ã¡ã‚ã‚“ä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šå¹´4æœˆã«ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹å‚¬ã•ã‚ŒãŸMySQL Conference & Expo 2009ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€æœ€çµ‚æ—¥ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ã€Obama Tech Teamã®æ–¹ã€…ã‚ˆã‚Šã€å¤§çµ±é ˜é¸ã«ãŠã„ã¦MySQLãŒã„ã‹ã«ä½¿ã‚ã‚ŒãŸã‹ã¨ã„ã†ç™ºè¡¨ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ æœ¬å½“ã¯ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹çµ‚äº†å¾Œã«ã™ãã¡ã‚ƒã‚“ã¨ã—ãŸãƒ¬ãƒãƒ¼ãƒˆã‚’æ›¸ã„ã¦å…¬é–‹ã™ã‚‹äºˆå®šã ã£ãŸã®ã§ã™ãŒã€ãã®é€±ã«èµ·ã“ã£ãŸè‰ãªãŽå‰›é€®æ•ã¨ã‹ã€ãã®ã»ã‹ã®å‡ºæ¥äº‹ã«ã™ã£ã‹ã‚Šæ°—ã‚’å–ã‚‰ã‚Œã¦æ”¾ç½®ã—ã¦ã„ã¾ã—ãŸã€‚Blogã‚’å§‹ã‚ãŸå¥‘æ©Ÿã«Twitterã®ä¸ã§èˆˆå‘³ã‚’æŒã£ã¦ã„ã‚‹æ–¹ãŒã„ã‚‹ã‹ã©ã†ã‹èžã„ãŸã¨ã“ã‚ã€ãã“ãã“ã®æ–¹ãŒèˆˆå‘³ã‚’ç¤ºã—ãŸã®ã§ã€ã“ã“ã§ç°¡å˜ã«ã¾ã¨ã‚ãŸãƒ¡ãƒ¢ã‚’å…¬é–‹ã™ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ â—ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ ç™ºè¡¨è€…ã¯
restartr 2009/08/28
*ã‚µãƒ¼ãƒãƒ¼

mysql

db

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

æœ€é©åŒ–

sql

tips
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
restartr 2009/08/01
*é–‹ç™º

db

mysql

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
BKCon 2006 - ã«ã½ãŸã‚“ç ”ç©¶æ‰€
æ˜¨æ—¥ã¯ BKCon 2006 ã«è¡Œã£ã¦ããŸã€‚ BK ã¨ã„ã†ã®ã¯ã€Œä¸€èˆ¬çš„ã«ã¯ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ã®äº‹ã€ãªã‚“ã§ã™ãŒã€æ˜¨æ—¥ã®ã¯ã€BKCon ã¨è¨€ã£ã¦ã‚‚ã€ã‹ã¤ã¦é–‹å‚¬ã•ã‚ŒãŸ Bad Knowhow Conference 2004 ã®ç¶šç·¨ã¨ã‹ã§ã¯ãªãã€"B"atara "K"esuma "Con"ference 2006 ã§ã™ã€‚ â€»æ£ã—ãã¯æ¨ªæµœ Linux ãƒ¦ãƒ¼ã‚¶ã‚°ãƒ«ãƒ¼ãƒ—ä¸»å‚¬ã®ã€Œç¬¬ 65 å›žã‚«ãƒ¼ãƒãƒ«èªæ›¸ä¼šã€ã®ãƒ†ãƒ¼ãƒž "mixi.jp: Scaling Out With Open Source" ã§ã™ã€‚ ã¡ãªã¿ã«ã€Batara Kesuma ã•ã‚“ã¨ã„ã†ã®ã¯ã€æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ã®å–ç· å½¹ã€‚ mixi ã®è£å´ã‚’è¦‹ã›ã¾ã™ã¨ã„ã†ã‹ã€ã¡ã‚‡ã£ã¨ hip ãªè¨€ã„ã‹ãŸã‚’ã™ã‚Œã° "Inside mixi's backend" ã£ã¦ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ãƒ—ãƒ¬ã‚¼ãƒ³å†…å®¹ã¯ YAPC::Asia ã®æ™‚ã¨å¤§å‡¡åŒã˜ã§ã—ãŸãŒã€ãƒ—ãƒ¬ã‚¼ãƒ³ã®æŒã¡
restartr 2009/08/01
*ã‚µãƒ¼ãƒãƒ¼

db

mysql

perl

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
ç¬¬2å›žã€€ä¸€ç•ªã®åŸºæœ¬ã€ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ | gihyo.jp
ã•ã¦ã€å‰å›žã®å¤§ã¾ã‹ãªåœ°å›³ã‚’å…ƒã«ã€ç¬¬2å›žã§ã¯å®Ÿéš›ã«å•ã„åˆã‚ã›æ‰‹æ³•ã®è©³ç´°ã«ã¤ã„ã¦è¦‹ã¦ã„ãã¾ã™ã€‚æœ€åˆã«å–ã‚Šä¸Šã’ã‚‹ã®ã¯ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã¨ã„ã†ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¤œç´¢ã®æœ€ã‚‚åŸºæœ¬ã«ãªã‚‹ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ³•ã§ã™ã€‚ ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã¨ã¯ ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã¯ã€æ—¥æœ¬èªžã«ç›´è¨³ã™ã‚‹ã¨ã€Œé †æ¬¡æ¤œç´¢ã€ã¨ã„ã†å½¢ã«ãªã‚Šã¾ã™ã€‚ç«¯çš„ã«è¨€ã£ã¦ã—ã¾ãˆã°ã€Œã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’é †ã«æ¤œç´¢ã™ã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã€çµæžœã¨ã—ã¦é€šå¸¸ã¯ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚“ã§è¿”ã—ã¾ã™ã€‚ãã®å¾Œã€æ¤œç´¢æ¡ä»¶ã‚„å–å¾—ä»¶æ•°ãªã©ã®å¿…è¦ã«å¿œã˜ã¦ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°ãŒè¡Œã‚ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ã“ã®æ–¹æ³•ã¯ã€ã™ã¹ã¦ã®ä»¶æ•°ã‚’å¯¾è±¡ã¨ã—ã¦æ¤œè¨Žã™ã‚‹ãŸã‚ã€æ¡ä»¶ã‚’é¸ã°ãšä½¿ãˆã¾ã™ã€‚ãã®ã»ã‹ã€ã©ã‚“ãªè¤‡é›‘ãªSQLãŒæ¥ã¦ã‚‚ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãªã‚‰å–ã‚Šã“ã¼ã—ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãŸã¨ãˆã°ãªã‚“ã®å¤‰å“²ã‚‚ãªã„ ã¨ã„ã£ãŸSQLã‚’å®Ÿè¡Œã™ã‚‹ã«å½“ãŸã£ã¦ã¯ã€ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã‚’ä½¿ã„ã¾ã™ã€‚ å›³1ã€€ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã®å®Ÿè¡Œå½¢ ã‚·ãƒ¼ã‚±
restartr 2007/04/04
DB

SQL

æœ€é©åŒ–

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1