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

HeavyFeather id:HeavyFeather

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

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

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å²
1. ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å² gussan@Drecom Co., Ltd. Copyright Â© Drecom Co., Ltd. 12å¹´2æœˆ20æ—¥æœˆæ›œæ—¥
HeavyFeather 2012/02/20
game

mysql

scalability

presentation

performance
ãƒªãƒ³ã‚¯
å¿«é©ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆç”Ÿæ´»ã¸ã®ç¬¬ä¸€æ©ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼
å…ˆæœˆã€Not Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒå‡„ã„ï¼ã¨ã„ã†è©±ã‚’æ›¸ã„ãŸã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯å‡„ã„ãƒ¤ãƒ„ã ãŒã€ãƒŽã‚¦ãƒã‚¦ãŒã‚ã¾ã‚Šã‚¦ã‚§ãƒ–ä¸Šã§è¦‹ã¤ã‹ã‚‰ãªã„ã€‚å”¯ä¸€è¦‹ã¤ã‹ã‚‹æ—¥æœ¬èªžã®è¨˜äº‹ã¯ã€ã‚¦ãƒŽã‚¦ãƒ©ãƒœã«ã‚ˆã‚‹ã€Œå›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã ã€ã ã‘ã§ã‚ã‚‹ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯æ–¯æ³¢æ°ã«ã‚ˆã‚‹å˜ç‹¬ã®ä½œå“ã§ã‚ã‚‹ãŸã‚ã€æ–¯æ³¢æ°ã¯é–‹ç™ºã ã‘ã§æ‰‹ã„ã£ã±ã„ã§ã‚ã‚Šã€ä½¿ã„æ–¹ã®ç´¹ä»‹è¨˜äº‹ã‚’æ›¸ãã“ã¨ã¾ã§ã¯æ‰‹ãŒå›žã‚‰ãªã„ã®ã§ã‚ã‚ã†ã€‚ã“ã‚“ãªå‡„ã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒè¶³ã‚Šãªã„ã›ã„ã§ä½¿ã£ã¦è²°ãˆãªã„ãªã‚“ã¦å‹¿ä½“ãªã„ï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€ä»Šæ—¥ã¯SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚å°‘ã—é•·ã„ã‚¨ãƒ³ãƒˆãƒªã§ã‚ã‚‹ãŒã€æœ€å¾Œã¾ã§ãŠä»˜ã
HeavyFeather 2010/04/21
MySQL

db

spider

scalability
ãƒªãƒ³ã‚¯
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§ å…¨ä¸–ç•Œã§3å„„äººã‚’è¶…ãˆã‚‹ä¼šå“¡ã‚’æŠ±ãˆã€ä¸–ç•Œæœ€å¤§ã®SNSã¨ãªã£ãŸFacebookã€‚åŒç¤¾ã®æŠ€è¡“æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Jeff Rothschildæ°ãŒã€10æœˆ8æ—¥ã«ç±³ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å¤§å¦ã‚µãƒ³ãƒ‡ã‚£ã‚¨ã‚´æ ¡ã§è¡Œã£ãŸã‚»ãƒŸãƒŠãƒ¼ã€ŒHigh Performance at Massive Scale-Lessons learned at Facebookã€ã®å†…å®¹ã‚’å†æ§‹æˆã—ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ï¼ˆã“ã®è¨˜äº‹ã¯ã€ŒFacebookãŒå¤§è¦æ¨¡ãªã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå‰ç·¨ï¼‰ï½ž800å„„æžšã®å†™çœŸãƒ‡ãƒ¼ã‚¿ã¨PHPã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å•é¡Œã€ã®ç¶šãã§ã™ï¼‰ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å¤§ããªå½¹å‰²ã‚’æžœãŸã—ã¦ã„ã‚‹ Facebookã®ä¸»ãªå½¹å‰²ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç°¡å˜ã«ï¼ˆå‹äººãŸã¡ã®ï¼‰æƒ…å ±ã‚’é›†ã‚ã‚‹ã“ã¨ãŒã§
HeavyFeather 2009/11/14
facebook

performance

MySQL

architecture

scalability

memcached

server
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)
å…ˆé€±é‡‘æ›œæ—¥ã€BPStudy#25ã§ã€ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization æœ€åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’äºˆæ¸¬ã—ã€ãã‚Œã‚’å…ƒã«ãƒªã‚½ãƒ¼ã‚¹é…åˆ†ã‚’è€ƒãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚
HeavyFeather 2009/10/06
db

development

architecture

memcached

MySQL

performance

scalability

server
ãƒªãƒ³ã‚¯
ãƒã‚¿ãƒ•ãƒ«ã®MTå†æ§‹ç¯‰ãŒåŠ‡çš„ã«é€Ÿããªã£ãŸãƒ¬ã‚·ãƒ”ã¯ã‚³ãƒ¬ï¼ - ãƒã‚¿ãƒ•ãƒ«
å°‚ç”¨ã‚µãƒ¼ãƒã®ã¯ãšãªã®ã«ã€å€‹åˆ¥ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®å†æ§‹ç¯‰ã ã‘ã§7æ™‚é–“ä»¥ä¸Šã‹ã‹ã‚‹ã£ã¦ã©ã†ãªã‚“ã ã‚ã†â€¥â€¥ã¨æ€ã£ã¦ã„ãŸã¨ã“ã‚ã€é”æ³•ä½¿ã„ãŒç¾ã‚Œã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãã‚Œã¾ã—ãŸï¼ ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã§æ‚²ã—ã’ã«ã¤ã¶ã‚„ã„ã¦ã„ãŸã¨ã“ã‚ã€é”æ³•ä½¿ã„ãŒç¾ã‚Œã¾ã—ãŸã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãã‚ŒãŸã®ã¯ã€@yagishitaï¼ˆSix Apartï¼‰ã§ã™ã€‚ ãƒã‚¿ãƒ•ãƒ«ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸçµæžœã¯ãƒ–ãƒã‚°ã§å…¬é–‹ã—ã¦ã€ãœã²ä»–ã®çš†ã•ã‚“ã®å½¹ã«ç«‹ã£ãŸã‚‰ã„ã„ãªã¨ã„ã†ã“ã¨ã§ã€ãŠæ‰‹ä¼ã„ã—ã¦é ‚ã„ãŸæ¬¡ç¬¬ã§ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ä»Šå›žã€å¥åŠ¹ã—ãŸãƒ¬ã‚·ãƒ”ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ ãƒ»ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’MyISAMã‹ã‚‰InnoDBã«å¤‰æ›´ã™ã‚‹ ãƒ»InnoDBã®ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥çŽ‡ã‚’é«˜ã‚ã‚‹ã‚ˆã†ã«my.cnfã®è¨å®š (innodb_buffer_pool_size) ã‚’å¤‰æ›´ã™ã‚‹ ã€Œã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’MyISAMã‹ã‚‰InnoDBã«å¤‰æ›´ã€ã—ãŸã®ãŒå¤§ãã„ã¿ãŸã„ã§ã™ãã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†ã®ã¯ã€
HeavyFeather 2009/10/03
MySQL

performance

scalability

server

tips

tuning

webdesign
ãƒªãƒ³ã‚¯
Yahoo!ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã®MySQL å†—é•·åŒ–æŠ€è¡“
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ãƒ—ãƒ©ãƒƒãƒˆãƒ›ãƒ¼ãƒ æŠ€è¡“ã®ãƒãƒ£ãƒƒã‚¯ã§ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ä¸€éƒ¨ã‚µãƒ¼ãƒ“ã‚¹ã« RDBMS ã® MySQL ã‚’ä½¿ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æä¾›ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯å¤šãã®ãŠå®¢æ§˜ã‚ˆã‚Šã‚¢ã‚¯ã‚»ã‚¹ã‚’é ‚ã„ã¦ãŠã‚Šã¾ã™ã®ã§ã€å¤§é‡ã®æ›´æ–°ã€å‚ç…§ã®å‡¦ç†é€Ÿåº¦ã«å„ªã‚ŒãŸ MySQL ã‚’é¸æŠžã—ã€ãŠå®¢æ§˜ã«ã‚¹ãƒˆãƒ¬ã‚¹ãªãã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹ã‚ˆã† æ—¥ã€…æ¥å‹™ã«å–ã‚Šçµ„ã¾ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ç²¾å¯†æ©Ÿå™¨ã«ã¯æ•…éšœãŒã¤ãã‚‚ã®ã§ã€ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨ã®è¦³ç‚¹ã‹ã‚‰ã¯ ã€Œæ©Ÿå™¨ãŒæ•…éšœã™ã‚‹ã®ã¯ã—ã‹ãŸãªã„ã€ã—ã‹ã—ãã‚Œã‚’ã„ã‹ã«æ—©ãå¾©æ—§ã•ã›ã‚‹ã‹ã€ ã¨ã„ã£ãŸã“ã¨ã‚’å¿µé ã«å…¥ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã€éšœå®³ãŒèµ·ã“ã£ã¦ã‹ã‚‰å¾©æ—§ã•ã›ã‚‹ã®ã§ã¯ãªãã€éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«
HeavyFeather 2009/03/29
yahoo

architecture

db

performance

MySQL

scalability

server
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
HeavyFeather 2009/03/04
db

development

MySQL

performance

scalability

storage

tips
ãƒªãƒ³ã‚¯
mixiã®å¹´æœ«å¹´å§‹å¯¾ç– æ—¥è¨˜æŠ•ç¨¿ã‚·ã‚¹ãƒ†ãƒ ã®æ”¹å–„ - mixi engineer blog
æœæ™©å†·ãˆã¦ãã¾ã—ãŸãã€‚é¢¨é‚ªãªã©å¼•ã„ã¦ã„ã¾ã›ã‚“ã§ã—ã‚‡ã†ã‹ã€‚ã•ã¦ã€å¹´æœ«ãŒè¿‘ã¥ã„ã¦ãã‚‹ã“ã®æ™‚æœŸã«å¼Šç¤¾ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæœ€ã‚‚æ°—ã«ãªã‚‹ã®ã¯ã€ãŠæ£æœˆã€‚ãã‚Œã‚‚æ¥å¹´1æœˆ1æ—¥ã‚’è¿ŽãˆãŸçž¬é–“ã§ã™ã€‚ 1æ—¥1æ—¥0æ™‚ã«ä½•ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼Ÿãã†ã€mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã§æœ€ã‚‚æ—¥è¨˜ãŒæ›¸ãè¾¼ã¾ã‚Œã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã«ãªã‚‹ã®ã§ã™ã€‚å€‹äººçš„ã«ã€Œã‚ã‘ãŠã‚ã“ã¨ã‚ˆã‚ã‚¢ã‚¿ãƒƒã‚¯ã€ã¨å‘¼ã‚“ã§ã„ã¾ã™ã€‚ä»Šå¹´ã¯æ—¥è¨˜ã ã‘ã§ã¯ãªãã€ã‚¨ã‚³ãƒ¼ã§ã‚‚ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒé£›ã³äº¤ã†ã“ã¨ã§ã—ã‚‡ã†ã€‚ã“ã®æ™‚æœŸã¯æºå¸¯é›»è©±ã®ã‚ãƒ£ãƒªã‚¢ã§ã‚‚ã•ã¾ã–ã¾ãªå¯¾ç–ã‚’è¡Œã£ã¦ã„ã¾ã™ãŒã€ãƒŸã‚¯ã‚·ã‚£ã§ã‚‚å¹´æœ«å¹´å§‹ã§ã‚‚ãƒ¦ãƒ¼ã‚¶ã®æ–¹ã«å¿«é©ã«ã‚µãƒ¼ãƒ“ã‚¹æä¾›ãŒã§ãã‚‹ã‚ˆã†ã«åŠªã‚ã¦ã„ã¾ã™ ä»¥ä¸‹ã¯æ˜¨å¹´ã®å¹´æœ«å¹´å§‹ã®æ—¥è¨˜æŠ•ç¨¿æ•°ã®æŽ¨ç§»ã§ã™ã€‚é’è‰²ãŒ12/31ã‹ã‚‰1/1ã€èµ¤è‰²ãŒ1/1ã‹ã‚‰1/2ã«ãªã‚Šã¾ã™ 1/1ã®æ–¹ãŒå…¨ä½“çš„ã«å¤šã„ã§ã™ãŒã€ç‰¹ã«å¹´ãŒå¤‰ã‚ã‚‹å‰å¾Œã®æŠ•ç¨¿æ•°ã¯å€è¿‘ããªã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ã“ã®æ™‚ã«è² è·ã«ã‚ˆã‚Šæ—¥è¨˜ã®æŠ•ç¨¿ãŒã—ã¥ã‚‰ã„çŠ¶æ…‹ã«ãªã£ã¦ã„ãŸã®
HeavyFeather 2008/12/16
MySQL

mixi

development

server

scalability

tips

web
ãƒªãƒ³ã‚¯
ã€Œå®Ÿç¾ã—ãŸã„ã“ã¨ã‚’è¨ˆç®—æ©Ÿã®å•é¡Œã«ç½®ãæ›ãˆã‚‹ã“ã¨ãŒã€ŽæŠ€è¡“åŠ›ã€ã€ã€ä¼Šè—¤CTOãŒâ€œã¯ã¦ãªæµâ€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ¥µæ„ã‚’èªžã‚‹ï¼šCodeZine
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
HeavyFeather 2008/11/23
db

hatena

linux

mysql

performance

scalability

server
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» æœŸé–“é™å®šã®æ–°æ©Ÿèƒ½ã€Œã‚¨ã‚³ãƒ¼ã€ç™»å ´
ã“ã‚“ã«ã¡ã¯ã€‚mixié–‹ç™ºéƒ¨ã®youheiã§ã™ã€‚ ä»Šå›žã¯å…ˆæ—¥8æœˆ4æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€Œã‚¨ã‚³ãƒ¼ã€ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¨ã‚³ãƒ¼ã¨ã¯ ã¾ãšã¯ã‚¨ã‚³ãƒ¼ã¨ã¯ã©ã†ã„ã†æ©Ÿèƒ½ã‹ã®ã”ç´¹ä»‹ã§ã™ãŒã€ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ãƒšãƒ¼ã‚¸ãŒã”ã–ã„ã¾ã™ã®ã§ãã¡ã‚‰ã‚’ã”è¦§ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã”ã–ã„ã¾ã™ã€‚ http://mixi.jp/guide_echo.pl ã„ãã¤ã‹æŠœç²‹ã—ã¾ã™ã¨ã€ ã‚ãªãŸã®"ä»Š"ã‚’ä¸€è¨€ã«ã—ã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿèª°ã‹ã«ä¼ãˆãŸã„ã“ã¨ã€ã²ã¨ã‚Šã”ã¨ç‰ã€ä½•ã§ã‚‚OKï¼ æ°—è»½ãªæ–°ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã™ã€‚ ãŸã¨ãˆã°ã€ã€Œä»Šæ—¥ã¯ã„ã„å¤©æ°—ã ãªã€œã€ã¨ã„ã†ã€ã²ã¨ã‚Šã”ã¨ã‹ã‚‰ã€ã€ŒãŠè…¹ã™ã„ãŸãƒ¼ï¼èª°ã‹ãƒ©ãƒ³ãƒã«ã„ã“ã†ã‚ˆï¼ã€ã¨ã„ã†ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸çš„ãªä½¿ã„æ–¹ã¾ã§ã€ã€Œã‚¨ã‚³ãƒ¼ã€ã®æ¥½ã—ã¿æ–¹ã¯ã‚ãªãŸæ¬¡ç¬¬ï¼ ãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£åŒå£«ã§ã€Œã‚¨ã‚³ãƒ¼ã€ã‚’ä½¿ã†ã¨ãƒ›ãƒ¼ãƒ ã«ãŠäº’ã„ã®æ›¸ãã“ã¿ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ æ°—ã«ãªã£ãŸæ›¸ãã“ã¿ã«ã¯ã€è¿”ä¿¡ã™ã‚‹ã“ã¨ã‚‚ã§ãã¡ã‚ƒã„ã¾ã™ã€‚ã‚ãªãŸãŒãµã¨æ›¸ãã“ã‚“ã ä¸€è¨€ã«ã€æ€ã‚ã¬è¿”
HeavyFeather 2008/08/07
mixi

mysql

db

performance

scalability
ãƒªãƒ³ã‚¯
1