[B! Twitter][MySQL] HeavyFeatherã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

HeavyFeather id:HeavyFeather

Twitterã¨MySQLã«é–¢ã™ã‚‹HeavyFeatherã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

${{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ã«ãŠã‘ã‚‹å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€3ã¤ã®åŽŸå‰‡
4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸMySQL Confernce & Expo 211ã§ã¯ã€Twitterã®Jeremy Coleæ°ãŒã€ŒBig and Small Data at @Twitterã€ã¨é¡Œã—ã¦ã€åŒç¤¾ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹åŽŸå‰‡ã¨ã‚·ã‚¹ãƒ†ãƒ æ§‹æˆã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ 1æ—¥ã«1å„„5000ä¸‡ä»¥ä¸Šã®ãƒ„ã‚¤ãƒ¼ãƒˆãŒè¡Œã‚ã‚Œã¦ã„ã‚‹Twitterã®ã‚·ã‚¹ãƒ†ãƒ ã¯ã©ã®ã‚ˆã†ã«æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Twitterã«ãŠã‘ã‚‹åŽŸå‰‡ Twitterã®Jeremy Coleæ°ã€‚
HeavyFeather 2011/06/23
twitter

infrastructure

db

design

MySQL
ãƒªãƒ³ã‚¯
MySQLerã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¾ã¨ã‚ã€‚
æ¾ä¿¡æ°ã®ã€ MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹ Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãŒäººæ°—ã‚’åšã—ã¦ã„ã‚‹ãŒã€æ¾ä¿¡æ°ãŒè¨€ã†ã‚ˆã†ã«æœ€è¿‘ã¯Twitterã§MySQLé–¢é€£ã®è©±é¡Œã‚‚çµæ§‹å¢—ãˆã¦ãã¦ã„ã‚‹ã‚ˆã†ã«æ€ã†ã€‚Twitterã®æµè¡Œã®å‹¢ã„ã¯å‡„ã¾ã˜ãã€ä»Šã¯å³ã‚’å‘ã„ã¦ã‚‚å·¦ã‚’å‘ã„ã¦ã‚‚Twitterã€å¯ã¦ã‚‚è¦šã‚ã¦ã‚‚Twitterã€çŒ«ã‚‚æ“åã‚‚Twitterã¨ã„ã†é›°å›²æ°—ã§ã‚ã‚‹ã€‚å¾“ã£ã¦MySQLã‚‚Twitterã§ç››ã‚Šä¸ŠãŒã‚‹ã®ã¯å½“ç„¶ã®æˆã‚Šè¡Œãã¨ã„ã†ã‚‚ã§ã‚ã‚‹ã—ã€Twitterã‚’æ´»ç”¨ã—ãªã„æ‰‹ã¯ãªã„ã€‚ ã—ã‹ã—MySQLé–¢é€£ã®è©±ã§ç››ã‚Šä¸ŠãŒã‚‹ã¨è¨€ã£ã¦ã‚‚ã€Œã˜ã‚ƒã‚èª°ã‚’ãƒ•ã‚©ãƒãƒ¼ã™ã‚Œã°è©±ã«å…¥ã‚Œã‚‹ã‚“ã ã‚ˆï¼Ÿï¼ã€ã¨å¤šãã®çš†ã•ã‚“ã¯ç–‘å•ã«æ€ã‚ã‚Œã‚‹ã“ã¨ã ã‚ã†ã€‚ãã“ã§ã€ä»Šæ—¥ã¯MySQLé–¢é€£ã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ç‹¬æ–ã¨åè¦‹ã¨æ„›ã¨å‹‡æ°—ã¨åŠªåŠ›ã‚’ã‚‚ã£ã¦ç´¹ä»‹ã™ã‚‹ã€‚MySQLã®æƒ…å ±ãŒæ¬²ã—ã„äººã€ã‚‚ã—ãã¯è©±é¡Œã®è¼ªã«
HeavyFeather 2009/11/01
twitter

MySQL

innodb
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

Twitterã¨MySQLã«é–¢ã™ã‚‹HeavyFeatherã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

Twitterã¨MySQLã«é–¢ã™ã‚‹HeavyFeatherã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

Twitterã«ãŠã‘ã‚‹å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€3ã¤ã®åŽŸå‰‡

MySQLerã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¾ã¨ã‚ã€‚

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (5)

Twitterã¨MySQLã«é–¢ã™ã‚‹HeavyFeatherã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

Twitterã«ãŠã‘ã‚‹å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€3ã¤ã®åŽŸå‰‡

MySQLerã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¾ã¨ã‚ã€‚

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹