[B! innodb] k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k-holy id:k-holy

innodbã«é–¢ã™ã‚‹k-holyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒ—ãƒãƒ€ã‚¯ãƒˆã«æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’åŠ ãˆãŸã„ã€æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ›´æ–°ã‚‚ã»ã—ã„ ã¨ã„ã†ã¨ãã®æ‰‹è»½ãªæ–¹æ³• - Qiita
ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚ªãƒ¼ãƒŠãƒ¼ ã‚„ ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰ã®è¦æœ›ã«ã‚ˆã£ã¦ æ¤œç´¢æ©Ÿèƒ½ ã®å¿…è¦æ€§ã«è¿«ã‚‰ã‚ŒãŸã¨ãã€ ã‚ã‚Šãµã‚ŒãŸæ–¹æ³• ã§ã‹ã¤ é€Ÿæ”» ã§å®Ÿè£…ã™ã‚‹æ–¹æ³•ã§ã™ è¦ä»¶ æ—¥æœ¬èªžæ–‡ç« ãªã©ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã€å…¨æ–‡æ¤œç´¢ã§ãã‚‹ æ¤œç´¢ãƒªã‚¯ã‚¨ã‚¹ãƒˆã«å¯¾ã—ã¦ã€ååˆ†é«˜é€Ÿã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’è¿”ã™ æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ›´æ–°ã•ã‚Œã€å®Ÿãƒ‡ãƒ¼ã‚¿ã¨ç›¸é•ãŒã§ãªã„ æ¤œç´¢å¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ãŒè¿½åŠ ï¼æ›´æ–°ï¼å‰Šé™¤ã•ã‚ŒãŸã‚‰æ¤œç´¢çµæžœã«ã‚‚å³åæ˜ ã•ã‚Œã‚‹ å¸Œæœ› ã§ãã‚‹ã ã‘é€Ÿãå®Ÿè£…ï¼æä¾›ã—ãŸã„ ã§ãã‚‹ã ã‘é‹ç”¨ã‚³ã‚¹ãƒˆã‚‚å°ã•ãã—ãŸã„ ãŠã™ã™ã‚ãªæ–¹æ³• ã‚‚ã—ã‚‚ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒMySQLäº’æ›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ã¦ã„ãŸã‚‰ã€è¦ä»¶ã‚’æº€ãŸã—ã¦ æ˜Žæ—¥ã«ã‚‚æä¾›ã§ãã‚‹ ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆæ°—æŒã¡ã§ã™ã€ãƒ•ãƒãƒ³ãƒˆå‘¨ã‚Šã®å®Ÿè£…ãªã©äº‹æƒ…ã«ã‚ˆã£ã¦å½“ç„¶ã‚³ã‚¹ãƒˆãŒå¤‰ã‚ã‚Šã¾ã™ :Pï¼‰ ã”ãå¹³å‡¡ãªçŸ¥è˜ã§å®Ÿç¾ã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã€ã“ã®æ–¹æ³•ã®åˆ©ç‚¹ã¯å¤§ãã„ã¨æ€ã„ã¾ã™ MySQL ( 5.7 ä»¥ä¸Š ) ã®å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã€å…¨æ–‡
k-holy 2019/11/05
æ—¢å˜ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã€ã¾ãŸã¯æ¤œç´¢ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¿½åŠ ã—ã¦ãƒˆãƒªã‚¬ãƒ¼ã§æ›´æ–°ã€‚æ£è¦åŒ–å‡¦ç†ã¯å¿…é ˆã¨ãªã‚‹ã¨æ¤œç´¢ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”¨æ„ã™ã¹ãã‹ã€‚

mysql

mariadb

innodb

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
MySQL5.7 InnoDB ã®N-gramå…¨æ–‡æ¤œç´¢ã‚’æ¤œè¨¼ï¼†ã‚µãƒ¼ãƒ“ã‚¹å°Žå…¥ã—ãŸ
â€» ã“ã®è¨˜äº‹ã¯ä»¥å‰Mediumã§å…¬é–‹ã—ãŸè¨˜äº‹ ã®è»¢è¼‰ã§ã™ MySQL5.7ãƒ»InnoDBãƒ»N-gram ã¨ã„ã†ç’°å¢ƒä¸‹ã§å…¨æ–‡æ¤œç´¢ã®æŒ™å‹•ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦æ¤œè¨¼ã‚’è¡Œã£ãŸã€‚FULLTEXT INDEXã¯ä»¥å‰ã¯MyISAMã§ã—ã‹åˆ©ç”¨ã§ããªã‹ã£ãŸãŒã€ 5.6.4ã‹ã‚‰InnoDBã§ã®ã‚µãƒãƒ¼ãƒˆãŒå§‹ã¾ã£ã¦ã„ãŸã€‚ InnoDBã®å…¨æ–‡æ¤œç´¢ã¯5.7ã€ç‰¹ã«5.7.6ä»¥é™ã§ã„ã‚ã‚†ã‚‹CJKï¼ˆä¸å›½èªžãƒ»æ—¥æœ¬èªžãƒ»éŸ“å›½èªžï¼‰ãŒN-gramã§æ¨™æº–ã‚µãƒãƒ¼ãƒˆã•ã‚Œå§‹ã‚ã€ CREATE TABLEæ–‡ã§ç°¡å˜ã«ãƒ‘ãƒ¼ã‚µãƒ¼ã‚’æŒ‡å®šã§ãã‚‹æ§‹æ–‡ã®ã‚µãƒãƒ¼ãƒˆã€ è¨å®šã‚„ã‚¯ã‚¨ãƒªã®çµ„ç«‹ã§è€ƒãˆãªã„ã¨ã„ã‘ãªã„äº‹ãŒæ¸›ã£ãŸäº‹ã§å°Žå…¥éšœå£ãŒã‹ãªã‚Šä¸‹ãŒã£ã¦ã„ã‚‹ã€‚ â€»4.1ã¨5.0ã§ã‚µãƒ¼ãƒ“ã‚¹å°Žå…¥çµŒé¨“ãŒã‚ã‚‹ç§ã®å€‹äººçš„ãªæ¯”è¼ƒæ„Ÿæƒ³ã§ã™ã€‚ FULLTEXT INDEXã‚‚ä»–ã®INDEXã¨åŒæ§˜ã«ãƒ‡ãƒ¼ã‚¿æ›´æ–°ãƒ»å‰Šé™¤ã®éš›ã«INDEXã®rebuildãŒèµ°ã‚‹ã®ã§æ›´æ–°æ™‚ã®è² è·ã«ã¯æ³¨æ„ãŒå¿…è¦ã§ã€F
k-holy 2019/11/05
"ã€Œä»–INDEXãŒä»˜ä¸Žã•ã‚ŒãŸã‚«ãƒ©ãƒ ã€ã«ã‚ˆã‚‹çµžè¾¼ã®æ–¹ãŒåŠ¹çŽ‡çš„ã§ã‚ã£ã¦ã‚‚ãã®INDEXã¯ç„¡è¦–ã•ã‚Œã¦ã€FULLTEXT INDEXã«ã‚ˆã‚‹æ¤œç´¢ãŒå®Ÿè¡Œã•ã‚Œã‚‹"

innodb

mysql

mariadb

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
ã¾ã æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼Ÿ - Qiita
ã¾ã æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼Ÿ ã“ã®è¨˜äº‹ã¯ InnoDB ã®ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§æ—¥æœ¬èªž NGRAM ã®ç¶šãã§ã™ã€‚ ä»¥é™â†‘ã®è¨˜äº‹ã‚’ã€Œå‰å›žã®è¨˜äº‹ã€ã¨å‘¼ç§°ã—ã¾ã™ã€‚ ä¾‹ã«ã‚ˆã£ã¦å®Ÿé¨“ã—ã¤ã¤è¨˜è¿°ã—ã¦ã„ã¾ã™ã€‚æ•´åˆæ€§ã‚„å†…å®¹ã®ä¿è¨¼ã¯ã§ãã¾ã›ã‚“ã€‚ æ¤œè¨¼ã«ä½¿ã£ãŸã®ã¯ CentOS 7, mysql 5.7.9 ã§ã™ã€‚ å‰å›žã®è¨˜äº‹ã¯ä½•ã‚’ã—ã¦ã„ã‚‹ã®ã‹ ç«¯çš„ã«è¨€ãˆã°ä¸‹è¨˜ã§ã™ã€‚ æ–‡å—åˆ—ã‚’ ngram åŒ–ã™ã‚‹ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®šç¾© å…¨æ–‡æ¤œç´¢ã—ãŸã„è¤‡æ•°ã‚«ãƒ©ãƒ ã‚’çµåˆã—ã¦ ngram åŒ–ã—ãŸæ–‡å—åˆ—ã‚’æ ¼ç´ã™ã‚‹ã‚«ãƒ©ãƒ ã‚’å®šç¾© ãƒˆãƒªã‚¬ãƒ¼ã§â†‘ã®ã‚«ãƒ©ãƒ ã« ngram åŒ–ã—ãŸæ–‡å—åˆ—ã‚’æ”¾ã‚Šè¾¼ã‚€ â†‘â†‘ã®ã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦ FULLTEXT INDEX ã‚’å¼µã‚‹ æ¤œç´¢æ™‚ã« â†‘â†‘â†‘ã®ã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦ MATCH AGAINST æ¤œç´¢ã‚’è¡Œã†ã“ã¨ã§å…¨æ–‡æ¤œç´¢ ã¨ã¾ãè‰²ã€…ã‚ã‚“ã©ã„ã“ã¨ã‚’ã—ã¦ã„ã¾ã™ã€‚ ç‰¹ã«æœ¬ç‹ã§ã¯ãªã„ãƒˆãƒªã‚¬ãƒ¼ã¨ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã®å®šç¾©ãŒå«Œã€‚ my
k-holy 2019/11/05
InnoDBã§FULLEEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å…¨æ–‡æ¤œç´¢

mysql

mariadb

innodb

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
ã„ã¤ã©ã®ã‚ˆã†ã«InnoDBã‚’å…±é€šãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã‹ã‚‰ç§»å‹•ã™ã‚‹ã‹ | Yakst
InnoDBã§å…±é€šãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ãŸå ´åˆã«ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ãŒè‚¥å¤§åŒ–ã™ã‚‹å•é¡Œã®è§£æ±ºæ‰‹æ®µã«ã¤ã„ã¦å®Ÿä¾‹ã‚’äº¤ãˆã¦ç´¹ä»‹ã™ã‚‹ã€‚ August 22, 2014 by Fernando Laudares å…ˆã®æŠ•ç¨¿ã€ŒMySQLã®ibdata1ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã®å•é¡Œã¨å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦è©³ã—ãã¿ã‚‹ã€ã§ã€ å…±é€šãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã¨å‘¼ã°ã‚Œã‚‹ã¨ã“ã‚ã«å±žã™ã‚‹å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŒã¤ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰ã€ibdata1ã®è‚¥å¤§åŒ–å•é¡Œã«ã¤ã„ã¦ã¿ãŸã€‚ å…ˆã®æŠ•ç¨¿ã‚’ã™ã‚‹å‹•æ©Ÿã¨ãªã£ãŸç‰¹å®šã®ã‚±ãƒ¼ã‚¹ã§ã¯ã€ã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ‡ã‚£ã‚¹ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ãŒæž¯æ¸‡ã—ã€ibdata1ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç¸®å°ã™ã‚‹æ–¹æ³•ã‚’æŽ¢ã—ã¦ã„ã‚‹é¡§å®¢ãŒã„ãŸã€‚ ã”å˜ã˜ã®é€šã‚Šã€ãã®ãƒ•ã‚¡ã‚¤ãƒ«(ã¾ãŸã¯ã€å…±æœ‰ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ§‹æˆã™ã‚‹ibdataãƒ•ã‚¡ã‚¤ãƒ«ä¸€å¼)ã¯ã€ innodb_file_per_tableãŒç„¡åŠ¹ã«ãªã£ã¦ã„ã‚‹ã¨ãå…¨ã¦ã®InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ã ã‘ã§ãªãã€ UNDO
k-holy 2017/09/12
mysql

innodb
ãƒªãƒ³ã‚¯
MySQLã§MyISAMã‹ã‚‰InnoDBã«ä¹—ã‚Šæ›ãˆã‚‹éš›ã«çŸ¥ã‚‰ãªã„ã¨ãƒãƒžã‚‹ã€æ€–ã„è©± - Y-Ken Studio
photo by byte MySQLã¨ã„ãˆã°ã€å··ã§ã¯InnoDBã°ã‹ã‚Šæ³¨ç›®ã•ã‚Œã€MyISAMã®åœ°ä¸‹ã‚¢ã‚¤ãƒ‰ãƒ«åŒ–ãŒã«ã‚ã‹ã«èªžã‚‰ã‚Œã‚‹ä»Šæ—¥ã“ã®é ƒã€çš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã‚ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å¤‰æ›ã™ã‚‹ã ã‘ã§æ¸ˆã‚€ãªã‚‰ã€ç°¡å˜ãªã®ã§ã™ã€‚ -- legacy_my_tableã‚’InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«å¤‰æ›ã™ã‚‹ ALTER TABLE legacy_my_table ENGINE=InnoDB; ã‚ˆã—çµ‚ã‚ã£ãŸï¼ã•ã‚ãƒ©ãƒ³ãƒã‚¿ã‚¤ãƒ ã ï¼ ãƒ»ãƒ»ãƒ»ã¨ç‰‡ä»˜ã‘ã¦ã—ã¦ã—ã¾ã†ã¨ã€æ‚²åŠ‡ãŒèµ·ã“ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚(>o<;) ãã‚Œã§ã¯æœ¬æ—¥ã€MyISAMã‹ã‚‰InnoDBã¸ç§»è¡Œã™ã‚‹ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„æ„å¤–ãªè½ã¨ã—ç©´ã¨Tipsã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ AUTO INCREMENTã®æŒ™å‹•ãŒé•ã†è½ã¨ã—ç©´ ä»¥ä¸‹ã«è©²å½“ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆã«ã¯ã€æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ç§ã¯ãƒãƒžã‚Šã¾ã—ãŸã€‚ INSERT IGNORE INTO
k-holy 2016/12/01
mysql

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

mysql

innodb
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°å¸¸è˜ã¯ã“ã‚Œã ï¼ã€ŒMySQL ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°å¸¸è˜ã¯ã“ã‚Œã ï¼ã€ŒMySQL ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ ã“ã‚“ã«ã¡ã¯ã€‚ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® nobuh ã§ã™ã€‚ æ ªå¼ä¼šç¤¾ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼æ§˜ä¸»å‚¬ã®Â db tech showcase sapporo 2015 Â ãŒ 9æœˆ10æ—¥ã€11æ—¥ã®2æ—¥é–“ã«ã‚ãŸã£ã¦é–‹å‚¬ã•ã‚Œã¾ã—ãŸ ã€‚ ä»Šå›žã€å¼Šç¤¾ã‚‚ç™ºè¡¨ã™ã‚‹æ©Ÿä¼šã‚’é ‚ãã¾ã—ãŸã®ã§ã€ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦æ—¥ã€… MySQL ã¨æ ¼é—˜ã—ã¦åŸ¹ã£ãŸãƒŽã‚¦ãƒã‚¦ã«ã¤ã„ã¦ãŠè©±ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ãã®ç™ºè¡¨ã§ä½¿ã£ãŸã‚¹ãƒ©ã‚¤ãƒ‰ãŒã“ã¡ã‚‰ã§ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®ä»®æƒ³ã‚µãƒ¼ãƒãƒ¼ã‚’ä½¿ã£ã¦ MySQL ã®ç®¡ç†ã‚„ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ—¥ã€…é‚é€²ã•ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã”è¦§ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ ä»Šã¾ã§ã«ã‚‚ MySQL ã«é–¢ã—ã¦ã„ãã¤ã‹è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã®ã§ã€ã“ã®æ©Ÿä¼šã«æ˜¯éžã”è¦§ãã ã•ã„ï¼ â†’ OSC2015åŒ—æµ·é“ã§ã€Œã“ã‚Œã ã‘ã¿ã‚Œã°å¤§ä¸ˆå¤«ãƒ¼Cactiã«ã‚ˆã‚‹MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœã€
k-holy 2015/09/14
mysql

innodb
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
k-holy 2014/09/16
mysql

innodb
ãƒªãƒ³ã‚¯
QAï¼ IT ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - ï¼ IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
k-holy 2014/05/14
mysql

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
k-holy 2012/01/17
InnoDBã®ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯

mysql

InnoDB
ãƒªãƒ³ã‚¯
1