[B! innoDB] kimimasaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kimimasa id:kimimasa

innoDBã«é–¢ã™ã‚‹kimimasaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

The Art of Workï¼šMySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ æ€§èƒ½ç·¨ - SH2ã®æ—¥è¨˜
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ã®ç¶šãã§ã™ã€‚å‰å›žã¯InnoDB Pluginã®ç‹¬è‡ªæ©Ÿèƒ½ã§ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã®ä»•çµ„ã¿ã‚’è§£èª¬ã—ã€Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ãŒç´„åŠåˆ†ã«ã¾ã§åœ§ç¸®ã•ã‚Œã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã£ã¦æ€§èƒ½ãŒã©ã®ã‚ˆã†ã«å¤‰åŒ–ã™ã‚‹ã‹ã‚’ã€å®Ÿéš›ã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è©¦é¨“ã‚’è¡Œã£ã¦è¦‹ã¦ã„ãã¾ã™ã€‚ è©¦é¨“ã®æ–¹é‡ ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã‚‹æ€§èƒ½ã¸ã®å½±éŸ¿ã¯ã€ä»¥ä¸‹ã®äºŒç‚¹ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ãƒ¡ãƒªãƒƒãƒˆï¼šãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºãŒå°ã•ããªã‚‹ãŸã‚ã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒæ¸›ã‚‹ ãƒ‡ãƒ¡ãƒªãƒƒãƒˆï¼šåœ§ç¸®ãƒ»å±•é–‹ã®å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ãŸã‚ã€CPUè² è·ãŒé«˜ããªã‚‹ ãã“ã§ã€ã“ã‚Œã‚‰ã®ç‰¹å¾´ãŒã‚ˆãåˆ†ã‹ã‚‹ã‚ˆã†ã«è©¦é¨“ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å·¥å¤«ã—ã¾ã™ã€‚Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ã¯InnoDBä¸Šã§ãŠã‚ˆã5GBã‚ã‚Šã¾ã™ãŒã€ã¾ãšç‹ã„ç¯„å›²ã«çµžã£ã¦èªã¿å–ã‚Šå‡¦ç†ã‚’è¡Œã†ã“ã¨ã§ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒã‚ã¾ã‚Šç™ºç”Ÿã—ãªã„ã‚ˆã†ã«ã—ã¾ã™ã€‚ã“ã‚Œã§CPUè² è·ã®å‚¾å‘ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚æ¬¡
kimimasa 2009/07/09
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

innoDB

mysql

ãƒ‡ãƒ¼ã‚¿åœ§ç¸®

ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯

Compression

tips
ãƒªãƒ³ã‚¯
MySQL InnoDB Pluginã®ç°¡å˜ãªãƒ“ãƒ«ãƒ‰æ‰‹é † - SH2ã®æ—¥è¨˜
ã“ã‚Œã¾ã§æ•°å›žã«æ¸¡ã£ã¦InnoDB Pluginã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ããŸã®ã§ã€InnoDB Pluginã‚’è©¦ã—ã¦ã¿ãŸããªã£ãŸã¨ã„ã†æ–¹ãŒã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãã€‚ãã“ã§æœ¬æ—¥ã¯ãã®ã‚ˆã†ãªæ–¹ãŒã„ã‚‹ã“ã¨ã‚’æœŸå¾…ã—ã¦ã€InnoDB Pluginã‚’çµ„ã¿è¾¼ã‚“ã MySQLã®ç°¡å˜ãªãƒ“ãƒ«ãƒ‰æ‰‹é †ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚æœ¬æ‰‹é †ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªç‰¹é•·ãŒã‚ã‚Šã¾ã™ã€‚ MySQLã®é•·ã„configureã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è¦šãˆãªãã¦ã‚ˆã„ã€‚ã¨ã„ã†ã‹MySQLãŒä½•ãªã®ã‹çŸ¥ã‚‰ãªãã¦ã‚‚ã§ãã‚‹ãƒ¬ãƒ™ãƒ« RPMãŒã§ãã‚‹ã®ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«/ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒç°¡å˜ã€‚è©¦ã—ã¦ã¿ã¦é£½ããŸã‚‰ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¯èƒ½ ä»Šå¾Œãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒä¸ŠãŒã£ã¦ã‚‚ãŠãã‚‰ãæ‰‹é †ã¯å¤‰ã‚ã‚‰ãªã„ ã‚³ãƒ”ãƒšã§ãŠï½‹ å¯¾è±¡OSã¯Red Hat Enterprise Linux 5ã¨CentOS 5ã§ã™ã€‚ ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ã§rpmbuidã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹(åˆå›žã®ã¿) $ cd $ echo "%_topdir $H
kimimasa 2009/07/09
mysql

Plugins

tips

innoDB
ãƒªãƒ³ã‚¯
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ - SH2ã®æ—¥è¨˜
InnoDB Pluginã®é¢ç™½ã„æ©Ÿèƒ½ã®ä¸€ã¤ã«ã€ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žã¯ãã®ä»•çµ„ã¿ã¨åŠ¹æžœã«ã¤ã„ã¦è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯ã‚°ãƒ©ãƒ•ã‚’ã”è¦§ãã ã•ã„ã€‚ ã“ã‚Œã¯Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€è¨˜äº‹æœ¬æ–‡ã®æ ¼ç´ã•ã‚Œã¦ã„ã‚‹textãƒ†ãƒ¼ãƒ–ãƒ«ã‚’MySQL 5.1ï¼‹InnoDB Plugin 1.0ã®ç’°å¢ƒã«ãƒãƒ¼ãƒ‰ã—ãŸã‚‚ã®ã§ã™ã€‚ å…ƒãƒ†ã‚ã‚¹ãƒˆï¼šä»Šå›žåˆ©ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã¯2009/06/21ç‰ˆã®ã‚‚ã®ã§ã™(jawiki-20090621-pages-articles.xml.bz2)ã€‚å…ƒãƒ†ã‚ã‚¹ãƒˆã¯ã“ã“ã‹ã‚‰Xml2sqlã‚’ç”¨ã„ã¦ã‚¿ãƒ–åŒºåˆ‡ã‚Šãƒ†ã‚ã‚¹ãƒˆã‚’å–ã‚Šå‡ºã—ãŸã‚‚ã®ã‚’ç”¨ã„ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯1,167,411ä»¶ã®è¨˜äº‹ãŒæ ¼ç´ã•ã‚Œã¦ãŠã‚Šã€å®¹é‡ã¯3,436MBã¨ãªã£ã¦ã„ã¾ã™ã€‚ å…ƒãƒ†ã‚ã‚¹ãƒˆ gzipï¼šå…ƒãƒ†ã‚ã‚¹ãƒˆã‚’gzipã‚³ãƒžãƒ³ãƒ‰ã§åœ§ç¸®ã—ãŸã‚‚ã®ã§ã™ã€‚ MyISAMï¼šè¨˜äº‹ã‚’MyISAMã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«
kimimasa 2009/07/01
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

innoDB

mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒˆãƒªã‚¬ãƒ¼ã®å®Ÿç”¨æ€§ã‚’ç¢ºèªã™ã‚‹ãŸã‚ã« InnoDB ã® SELECT COUNT(*) ã‚’é«˜é€ŸåŒ–ã—ã¦ã¿ã‚‹
æœ€è¿‘ RDBMS ã®ãƒˆãƒªã‚¬ãƒ¼ã‚’è‰²ã€…æ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€çŸ¥ã‚‰ãªã„äººã«ãƒˆãƒªã‚¬ãƒ¼ãŒä½•ã‹ã„ã¡ã„ã¡èª¬æ˜Žã™ã‚‹ã®ã«ç°¡å˜ãªä¾‹ã¯ãªã„ã‹ãªã€ã¨ã„ã†ã®ã¨ã€MySQL ã®å‡¦ç†é€Ÿåº¦ã¯ãƒˆãƒªã‚¬ãƒ¼ã«ã‚ˆã£ã¦ã©ã®ç¨‹åº¦å¤‰åŒ–ã™ã‚‹ã‹ã€ã¨ã„ã†ã“ã¨ã‚’ç¢ºèªã™ã‚‹ãŸã‚ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªå®Ÿé¨“ã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ InnoDB ã¯ã—ã°ã—ã°ã€ã€ŒSELECT COUNT(*) ãŒé…ã„ï¼ã€ã¨æ‰¹åˆ¤ã•ã‚Œã¾ã™ã€‚ã§ã¯ã€ãƒˆãƒªã‚¬ãƒ¼ã‚’ä½¿ã£ã¦è¡Œæ•°ã‚’åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚Œã°ã„ã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿã€€ä»¥ä¸‹ã®ã‚ˆã†ã«ã€æ¥µã‚ã¦å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ« t1 ã‚’ä½œã‚Šã€ãã®è¡Œæ•°ã‚’ t1_cnt ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ mysql> create table t1 ( ->Â Â id int unsigned not null primary key auto_increment, ->Â Â v int unsigned not null -> ) engine=innodb
kimimasa 2009/07/01
innoDB

mysql

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

ãƒˆãƒªã‚¬ãƒ¼
ãƒªãƒ³ã‚¯
MySQL InnoDBã«ãŠã‘ã‚‹ãƒãƒƒã‚¯ç«¶åˆã®è§£æžæ‰‹é † - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é‹ç”¨ã§é¿ã‘ã‚‰ã‚Œãªã„ã®ãŒã€ãƒãƒƒã‚¯ç«¶åˆã«ã‚ˆã£ã¦èµ·ã“ã‚‹ã‚·ã‚¹ãƒ†ãƒ ãƒˆãƒ©ãƒ–ãƒ«ã¸ã®å¯¾å¿œã§ã™ã€‚ã€Œ2æ™‚ã¾ã§ã«çµ‚ã‚ã‚‹ã¯ãšã®ãƒãƒƒãƒå‡¦ç†ãŒæœã«ãªã£ã¦ã‚‚çµ‚ã‚ã£ã¦ã„ãªã„ã€ã¨ã‹ã€Œè² è·ãŒé«˜ã„ã‚ã‘ã§ã‚‚ãªã„ã®ã«ã‚·ã‚¹ãƒ†ãƒ ãŒç„¡å¿œç”ã«ãªã£ã¦ã„ã‚‹ã€ã¨ã„ã£ãŸãƒˆãƒ©ãƒ–ãƒ«ãŒç™ºç”Ÿã—ãŸã¨ãã€DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ãã‚ŒãŒãƒãƒƒã‚¯ç«¶åˆã«ã‚ˆã‚‹ã‚‚ã®ãªã®ã‹ã©ã†ã‹ã‚’åˆ‡ã‚Šåˆ†ã‘ã¦ã€é©åˆ‡ã«å¯¾å‡¦ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ã“ã‚Œã¾ã§InnoDBã¯ãƒãƒƒã‚¯ç«¶åˆã«å¯¾ã—ã¦ã»ã¨ã‚“ã©æ‰“ã¤æ‰‹ãŒãªã‹ã£ãŸã®ã§ã™ãŒã€æœ€è¿‘ã‚ˆã†ã‚„ãå¯¾å‡¦æ–¹æ³•ãŒã§ã¦ãã¾ã—ãŸã€‚ä»Šæ—¥ã¯ãã®æ‰‹é †ã‚’ç¢ºèªã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ å‰æ ä»Šå›žã”ç´¹ä»‹ã™ã‚‹æ‰‹é †ã¯ã€MySQLã®ä»¥ä¸‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’å¯¾è±¡ã«ã—ã¦ã„ã¾ã™ã€‚ MySQL 5.1ï¼‹InnoDB Plugin 1.0 MySQL 5.4 ã„ããªã‚Šãƒãƒ¼ãƒ‰ãƒ«ã‚’ä¸Šã’ã¦ã—ã¾ã£ã¦ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ãŒã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ä»¥ä¸‹ã‚„ç´ ã®5.1ã§ã¯ä½¿ãˆã¾ã›ã‚“ã®ã§ã”æ³¨æ„ãã ã•ã„ã€‚ä»¥é™ã®å®Ÿè¡Œä¾‹ã¯ã™ã¹ã¦
kimimasa 2009/06/26
innoDB

mysql
ãƒªãƒ³ã‚¯
MyISAMã‹ã‚‰InnoDBã¸åˆ‡ã‚Šæ›¿ãˆã‚‹ã¨ãã®æ³¨æ„ç‚¹
MySQLã‚’ä½¿ã„å§‹ã‚ã¦é–“ã‚‚ãªã„äººãŒã‚ˆãé™¥ã‚‹ç½ ã®ä¸ã«ã€æ°—ã¥ãã¨ä½¿ã£ã¦ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒMyISAMã ã£ãŸï¼ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯MyISAMãªã®ã§ã€MySQLã«è©³ã—ããªã„äººãŸã¡ãŒæ¯”è¼ƒçš„é™¥ã‚Šã‚„ã™ã„ç½ ãªã®ã ã€‚ãã‚‚ãã‚‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†æ¦‚å¿µè‡ªä½“ãŒMySQLç‹¬è‡ªã®ã‚‚ã®ãªã®ã§ä»•æ–¹ã®ãªã„è©±ã§ã‚ã‚‹ã€‚MyISAMã¯ç´ æ™´ã‚‰ã—ã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆãŸã¨ãˆã°ã“ã®Yahoo!ã®ä¸ã®äººã«ã‚ˆã‚‹æŠ•ç¨¿ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«ï¼‰ã§ã‚ã‚‹ãŒã€é•·æ‰€ã‚‚ã‚ã‚Œã°çŸæ‰€ã‚‚ã‚ã‚‹ã€‚ä¾‹ãˆã°ã€ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å¯¾å¿œã§ã¯ãªã„ã€‚ ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã§ã¯ãªã„ã€‚ æ›´æ–°ã¨å‚ç…§ãŒå…¥ã‚Šä¹±ã‚ŒãŸå ´åˆã®åŒæ™‚å®Ÿè¡Œæ€§èƒ½ãŒã‚ˆããªã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå¤§ããï¼ˆæ•°å„„è¡Œã¨ã‹ï¼‰ãªã‚‹ã¨INSERTã®æ€§èƒ½ãŒåŠ£åŒ–ã™ã‚‹ã€‚ ãªã©ãªã©ã€‚ç‰¹ã«å‰è€…ã®2ã¤ãŒå•é¡Œã§ã€ã‚¢ãƒˆãƒŸãƒƒã‚¯ãªæ“ä½œãŒå¿…è¦ãªã¨ã“ã‚ã§ãƒã‚¸ãƒƒã‚¯ã‚’å®Ÿè£…å‡ºæ¥ãªã‹ã£ãŸã‚Šã€ã‚µãƒ¼ãƒãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸæ™‚ã«ãƒ‡ãƒ¼ã‚¿ãŒãŠäº¡ããªã‚Šã«ãª
kimimasa 2009/02/24
mysql

MyISAM

innoDB
ãƒªãƒ³ã‚¯
MySQL InnoDBã®ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ ãŠã•ã‚‰ã„ - SH2ã®æ—¥è¨˜
MySQLã®InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯è¡Œãƒãƒƒã‚¯ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ã—ã‹ã—Oracleã¨åŒã˜æ„Ÿè¦šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã€æ€ã‚ã¬ã¨ã“ã‚ã§ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«å‡ºãã‚ã™ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯InnoDBã®ãƒãƒƒã‚¯ç¯„å›²ãŒOracleã‚ˆã‚Šã‚‚å¾®å¦™ã«åºƒã„ãŸã‚ã§ã™ã€‚ å®Ÿéš›ã®ä¾‹ã§ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ mysql> select * from t; +----+------+ | c1 | c2 | +----+------+ | 10 | a | | 15 | a | | 20 | a | | 25 | a | | 30 | a | | 35 | a | | 40 | a | | 45 | a | | 50 | a | +----+------+c1åˆ—ã¯ä¸»ã‚ãƒ¼ã«ãªã£ã¦ã„ã¾ã™ã€‚1ã¤ã‚ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ä»¥ä¸‹ã®SQLã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ mysql> set tx_isolation = 'repeatable-r
kimimasa 2009/01/15
mysql

innoDB
ãƒªãƒ³ã‚¯
InnoDBã®ãƒã‚°ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã®é–¢ä¿‚
InnoDBã®ãƒ‡ãƒ¼ã‚¿é ˜åŸŸã¯ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã¨ã„ã†ã€åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„2ç¨®é¡žã®ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯åå‰ã‹ã‚‰ã™ã‚‹ã¨ãŸã ã®ãƒã‚°ã ã‹ã‚‰å‰Šé™¤ã—ã¦ã‚‚å¹³æ°—ã‹ãªï¼Ÿã¨æ€ã£ã¦å‰Šé™¤ã—ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒå¾Œã‚’çµ¶ãŸãªã„ã€‚ãã“ã§ã€ä»Šæ—¥ã¯ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã®é–¢ä¿‚ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã¨æ€ã†ã€‚ InnoDBã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€åˆ¥åWAL - Write Ahead Logã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã§ã€åå‰ã‚’æ—¥æœ¬èªžã«ç›´ã™ã¨ã€Œå‰ã‚‚ã£ã¦æ›¸ãè¾¼ã‚“ã§ãŠããŸã‚ã®ãƒã‚°ã€ã¨ã§ã‚‚å‘¼ã¹ã‚‹ã ã‚ã†ã‹ã€‚InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚ŒãŸæ›´æ–°ã¯ã€å…¨ã¦ã„ã£ãŸã‚“ãƒã‚°ã«æ›¸ãè¾¼ã¾ã‚Œã‚‹ã®ã§ã‚ã‚‹ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚³ãƒŸãƒƒãƒˆã•ã‚Œã‚‹ã¨ã€innodb_flush_log_at_trx_commit=1ãŒè¨å®šã•ã‚Œã¦ã„ã‚Œã°ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãè¾¼ã¿ãŒè¡Œã‚ã‚Œã‚‹ã€‚0ã¾ãŸã¯2ã®å ´åˆã«ã¯ã€ãƒã‚°ãƒãƒƒãƒ•ã‚¡ã¨å‘¼ã°ã‚Œã‚‹é ˜åŸŸã«ãƒ‡ãƒ¼ã‚¿ãŒä¿æŒã•ã‚Œã‚‹ã€‚ãã®å¾Œã€æ™‚é–“ã‚’
kimimasa 2009/01/12
mysql

innoDB
ãƒªãƒ³ã‚¯
Adaptive checkpointing
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of â€œamountâ€. The other is the limit of â€œageâ€. â€” limit of â€œamountâ€ â€” As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the buffer pool is filled by dirty blocks, InnoDB cannot allocate new blocks without flushing the dirty blocks and the
kimimasa 2008/11/15
mysql

innoDB
ãƒªãƒ³ã‚¯
1