[B! DB][ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] DNPPã®ãƒ

DNPP id:DNPP

DBã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹DNPPã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

Flash-Based DBMSã®æœ€å‰ç·š
ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ¡ãƒ¢ãƒªãƒ¼ã‚’ä½¿ã£ãŸSolid State Drive (SSD)ã®å®¹é‡ãŒ160GBã«åˆ°é”ã—ã€å¸‚å ´ä¾¡æ ¼ã‚‚ä¸‹ãŒã£ã¦ããŸã“ã¨ã«ã‚ˆã‚Šã€ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®ä»£æ›¿å“ã¨ã—ã¦SSDã‚’ä½¿ã†ç”¨é€”ãŒã„ã‚ˆã„ã‚ˆç¾å®Ÿå‘³ã‚’å¸¯ã³ã¦ãã¾ã—ãŸã€‚ä½Žå®¹é‡ã®ã‚‚ã®ãªã‚‰æ—¢ã«iPodã‚„ãƒ‡ã‚¸ã‚«ãƒ¡ç”¨ã®ãƒ¡ãƒ‡ã‚£ã‚¢ãªã©èº«ã®å›žã‚Šã«ã‚‚æ™®åŠã—ã¦ãŠã‚Šã€å¸‚å ´ã§ã¯ã™ã§ã«ã€Œç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã€Œã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¸ãƒ¬ãƒ³ãƒžâ€•æŠ€è¡“é©æ–°ãŒå·¨å¤§ä¼æ¥ã‚’æ»…ã¼ã™ã¨ãã€ã‚ˆã‚Šï¼‰ã€ãŒèµ·ã“ã£ã¦ã„ã‚‹ã¨ã„ãˆã¾ã™ã€‚ï¼ˆHDDæè¼‰ã®Walkmanã¨ã‹æ—¢ã«æ»…ã‚“ã§ã„ã‚‹ä¾‹ã‚‚ã‚ã‚‹ã—ã€‚ã€‚ã€‚ï¼‰
DNPP 2011/12/12
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

_è³‡æ–™

æŠ€è¡“

HDD

SSD
ãƒªãƒ³ã‚¯
Leo's Chronicle: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ å…¥é–€ï¼šã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä½“è‚²ä¼šç³»å›³æ›¸é¤¨ï¼Ÿã€
ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã¨ãã®ç ”ç©¶ã®ä¸–ç•Œã‚’ä¸€èˆ¬ã®äººã«ã‚ã‹ã‚Šã‚„ã™ãä¼ãˆã‚‹ãŸã‚ã€ã€Œå›³æ›¸é¤¨ã€ã‚’ãƒ¢ãƒ‡ãƒ«ã«ã—ãŸè©±ã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚è©¦é¨“ã«å‡ºãã†ãªï¼ˆï¼Ÿï¼‰éƒ¨åˆ†ã¯å¤ªå—ã§å¼·èª¿ã—ã¦ã‚ã‚Šã¾ã™ã€‚ï¼‰ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨ã„ã†è¨€è‘‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®é›†ã¾ã‚Šã¨ã„ã†æ„å‘³ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç ”ç©¶ã§ã¯ã€ä¾‹ãˆã¦è¨€ã†ãªã‚‰ã€Œæ¬²ã—ã„æœ¬ãŒã™ãã«è¦‹ã¤ã‹ã‚‹å›³æ›¸é¤¨ã€ã‚’ã„ã‹ã«ä½œã‚‹ã‹ã¨ã„ã†å•é¡Œã‚’è€ƒãˆã¾ã™ã€‚ã“ã“ã§ã€Œãƒ‡ãƒ¼ã‚¿ã€ã¯å›³æ›¸é¤¨ã®ã€Œæœ¬ã€ã«ç›¸å½“ã—ã€ã€Œãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã€ã¯ã€Œæœ¬æ£šã€ãŒãŸãã•ã‚“åŽã‚ã‚‰ã‚Œã¦ã„ã‚‹å›³æ›¸é¤¨ã®å»ºç‰©ã ã¨è€ƒãˆã¦ãã ã•ã„ã€‚ ã€Œæ¬²ã—ã„æœ¬ãŒã™ãã«è¦‹ã¤ã‹ã‚‹ã€ã¨ã¯ã©ã†ã„ã†ã“ã¨ã§ã—ã‚‡ã†ã‹ï¼Ÿä¾‹ãˆã°ã€å›³æ›¸ç›®éŒ²ã‚’èª¿ã¹ã¦ç›®çš„ã®æœ¬æ£šã®ç•ªå·ãŒã‚ã‹ã£ãŸã¨ã—ã¦ã‚‚ã€æœ¬æ£šã¾ã§ã®è·é›¢ãŒé ã‘ã‚Œã°ãŒã£ã‹ã‚Šã—ã¦ã—ã¾ã„ã¾ã™ã‚ˆãï¼Ÿï¼ˆé«˜ã™ãŽã¦æ‰‹ãŒå±Šã‹ãªã„ã€ã¨ã‹æ³£ã‘ã¦ãã¾ã™ï¼‰
DNPP 2011/12/12
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

_è³‡æ–™

æŠ€è¡“
ãƒªãƒ³ã‚¯
ï¼»æ¬¡ä¸–ä»£DBç·¨ï¼½åˆ†æ•£KVSã«é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’ç½®ã„ã¦ã¯ã„ã‘ãªã„
åˆ†æ•£KVSï¼ˆã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ï¼‰ã¯ã€RDBMSã®ä»£ã‚ã‚Šã«ãªã‚‹ã¨æ€ã£ã¦ã¯ã„ã‘ãªã„ã€‚RDBMSã§ã¯å½“ãŸã‚Šå‰ã ã£ãŸæ©Ÿèƒ½ã®ä¸€éƒ¨ã¯ã€ã‚ãã‚‰ã‚ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã“ã®ãŸã‚ã€é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’ã‚€ã‚„ã¿ã‚„ãŸã‚‰ã¨åˆ†æ•£KVSä¸Šã«ç½®ãã®ã¯ã‚„ã‚ãŸæ–¹ãŒã‚ˆã„ã€‚ åˆ†æ•£KVSã§ã‚ãã‚‰ã‚ãªã‘ã‚Œã°ãªã‚‰ãªã„æ©Ÿèƒ½ã«ã¯ã€æ¬¡ã®å››ã¤ãŒã‚ã‚‹ã€ ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ ãƒ»æŽ’ä»–åˆ¶å¾¡æ©Ÿèƒ½ ãƒ»èªã¿å–ã‚Šä¸€è²«æ€§ã‚’ä¿è¨¼ã™ã‚‹æ©Ÿèƒ½ ãƒ»ã‚¹ãƒ—ãƒªãƒƒãƒˆãƒ–ãƒ¬ã‚¤ãƒ³å¯¾ç–æ©Ÿèƒ½ é€†ã«ã„ãˆã°ã€ã“ã‚Œã‚‰ã‚’å–ã‚Šè¾¼ã¾ãªã„ã“ã¨ã§ã€åˆ†æ•£KVSã¯RDBMSã§ã¯ã‹ãªã‚ãªã‹ã£ãŸã€ç„¡å°½è”µãªã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãƒ¼ã‚„ã€æ¥µç«¯ã«çŸã„ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ãƒ¼ï¼ˆè¦æ±‚ãŒè¿”ã£ã¦ãã‚‹ã¾ã§ã®é…å»¶æ™‚é–“ï¼‰ã«ã‚ˆã‚‹é«˜ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å®Ÿç¾ã§ããŸã‚ã‘ã ã€‚ ã¨ã“ã‚ãŒã€ä½¿ã„æ–¹ã‚’é–“é•ãˆã‚Œã°ã€ãŸã¡ã¾ã¡å•é¡ŒãŒç”Ÿã˜ã¦ã—ã¾ã†ã€‚ã¨ã‚Šã‚ã‘ã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£KVSä¸Šã«ç½®ãå ´åˆã¯æ³¨æ„ãŒå¿…è¦ã ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«æ”¯éšœ é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã¨ã¯ã€ä¸æ•´åˆã‚„æå¤±
DNPP 2010/08/10
*ã‚ã¨ã§èªã‚€

KVS

è¨å®š

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šMyISAMã¨InnoDB (1/3)
ä»Šå›žã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸ã§ã‚‚ç‰¹ã«æœ‰åãªã€ŒMyISAMã€ã¨ã€ŒInnoDBã€ã®2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚MyISAMã¯MySQLã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨MyISAMãŒé¸æŠžã•ã‚Œã¾ã™ã€‚ã‚‚ã†ä¸€æ–¹ã®InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€MySQLã«è±Šå¯Œãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦æœ‰åã§ã™ã€‚ ã¾ãšã¯ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®æ§‹é€ ã«ã¤ã„ã¦è§£èª¬ã—ã€æœ€å¾Œã«InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ•ã‚¡ã‚¤ãƒ«æ§‹é€ ã‚’èª¬æ˜Žã™ã‚‹å‰ã«ã€å‰çŸ¥è˜ã¨ã—ã¦MySQLã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã¨å‘¼ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°æƒ…å ±ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã€2ã¤ã®ã‚µãƒ–ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå˜åœ¨ã—ã¾ã™ï¼ˆå›³1ï¼‰ã€‚ ã€Œmysqlã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯æ¨©é™ãƒ†ãƒ¼ãƒ–ãƒ«ã¨å‘¼ã°ã‚Œã‚‹MySQ
DNPP 2010/08/10
*ã‚ã¨ã§èªã‚€

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

ã‚µãƒ¼ãƒãƒ¼

DB
ãƒªãƒ³ã‚¯
1