[B! DB][performance] rch850ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rch850 id:rch850

DBã¨performanceã«é–¢ã™ã‚‹rch850ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

InnoDBã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã‚ˆã‚‹MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¸ã®å½±éŸ¿ | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚MySQLãŒã‚µãƒãƒ¼ãƒˆã™ã‚‹4ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®ç‰¹å¾´ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä¸Šã®ç‰¹æ€§ã‚’ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å±¥æ´ã®ä¿æŒæ–¹æ³•ã«çš„ã‚’å½“ã¦ã¦æ¯”è¼ƒã€‚ January 14, 2015 by Peter Zaitsev éŽåŽ»æ•°ãƒ¶æœˆã«æ¸¡ã£ã¦ã€InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å±¥æ´ã®è² å‚µã®å±é™ºæ€§ã¨ã€MVCCãŒMySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã®åŽŸå› ã«ãªã‚Šã†ã‚‹ã“ã¨ã«ã¤ã„ã¦ã€ã„ãã¤ã‹ã®è¨˜äº‹ã‚’æ›¸ã„ã¦ããŸã€‚ã“ã®è¨˜äº‹ã§ã¯ãã‚Œã«é–¢é€£ã—ã¦ã€InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨MVCC(multi-version concurrency controlã€å¤šç‰ˆåž‹åŒæ™‚å®Ÿè¡Œåˆ¶å¾¡)ã¨ã®é–¢é€£æ€§ã€ãã—ã¦ãã‚Œã‚‰ãŒMySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã©ã†å½±éŸ¿ã™ã‚‹ã®ã‹ã‚’å–ã‚Šä¸Šã’ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ MySQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã¯MySQLã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®è©³ç´°ãªèª¬æ˜ŽãŒã‚ã‚‹ã€‚ã“
rch850 2015/01/29
MySQL

performance

DB
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
rch850 2012/12/05
MySQL

DB

performance
ãƒªãƒ³ã‚¯
RDBMSã®æ™‚ä»£ã®çµ‚ã‚ã‚ŠãŒè¦‹ãˆã¦ããŸ - ãã—ã ã®ã¯ã¦ãª
ã‚¯ãƒ©ã‚¦ãƒ‰ã¨ä¸€ç·’ã«ã‚„ã£ã¦ããŸã‚‚ã® æœ€è¿‘ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒæµè¡Œã£ã¦ã¾ã™ã€‚ Googleã®MapResuceã‹ã‚‰å§‹ã¾ã£ã¦ã€Microsoftã®Azureã¾ã§ã€å¤§æ‰‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºæƒã£ãŸæ„Ÿã˜ã€‚ ã§ã€ãã“ã§ã€ã“ã‚“ãªã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºã¾ã—ãŸã¨ã„ã†ã¨ãã«ã€å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©ãã®ã‚¯ãƒ©ã‚¦ãƒ‰ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®èª¬æ˜ŽãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€ãã‚Œã¯RDBMSã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ Googleã ã¨BigTableã€Microsoftã ã¨SQL Data Servicesã€ã‚ã¨ã¯Amazonã®SimpleDBã€‚ã©ã‚Œã‚‚ã€åŸºæœ¬çš„ã«ã¯ã²ã¨ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒãƒƒã‚·ãƒ¥ã‚³ãƒ¼ãƒ‰ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã»ã‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ã‚‚ã€Oracle Coherenceã ã£ãŸã‚Šã€æ¥½å¤©ã®Romaã ã£ãŸã‚Šã€éžRDBMSã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¨ã„ã†ã‚ã‘ã§ã¯ãªã„ã‘ã©ã€mixiã®Tokyo Tyrantã‚„Apache CouchDBã‚‚ã€RDB
rch850 2008/12/15
ã‚³ãƒ¡ãƒ³ãƒˆã§æµ…ã„æµ…ã„è¨€ã‚ã‚Œã¦ã‚‹ã‘ã©ä½•ãªã®ï¼Ÿæ€è€ƒã®å¹…ãŒç‹ã„ã®ï¼Ÿé¸æŠžè‚¢ã‚’æç¤ºã—ã¦ã„ã‚‹ã ã‘ãªã®ã«

DB

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

DB

Scalability
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
rch850 2007/11/09
DB

performance
ãƒªãƒ³ã‚¯
1