[B! percona] tom__boã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tom__bo id:tom__bo

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

MySQL optimizer: ANALYZE TABLE and Waiting for table flush
tom__bo 2018/06/14
percona

mysql

table flush
ãƒªãƒ³ã‚¯
MySQLã®é«˜å¯ç”¨æ€§æ§‹æˆã®å±•æœ›2017å¹´ç‰ˆ(å¤§äººç·¨) | Yakst
ä»¥å‰å…¬é–‹ã•ã‚ŒãŸã€Œé•·è€ç·¨ã€(https://yakst.com/ja/posts/4656) ã«å¼•ãç¶šãã€æ¯”è¼ƒçš„æ–°ã—ã„MySQLé«˜å¯ç”¨æ€§ã‚ªãƒ—ã‚·ãƒ§ãƒ³ï¼ˆå¤§äººãŸã¡ï¼‰ã«ã¤ã„ã¦è§£èª¬ã—ãŸè¨˜äº‹ã€‚å‰å›žåŒæ§˜ã€åˆå¿ƒè€…å‘ã‘ã«ã€ŒGaleraã€ã¨ã€ŒRDS Auroraã€ã®2ã¤ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ã„ãã¤ã‹ã®é«˜å¯ç”¨æ€§ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è€ƒå¯Ÿã‚’è¡Œã„ã¾ã™ã€‚ ã“ã®ã‚·ãƒªãƒ¼ã‚ºã®å‰å›žã®è¨˜äº‹ï¼ˆè¨³æ³¨ï¼šæ—¥æœ¬èªžç‰ˆã¯ã“ã¡ã‚‰ï¼‰ã§ã¯ã€é•·ãã«ã‚ãŸã£ã¦åˆ©ç”¨ã•ã‚Œã¦ããŸMySQLã®é«˜å¯ç”¨æ€§ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ç§ã¯ã“ã‚Œã‚‰ã‚’ã€ŒThe Elders (é•·è€ãŸã¡)ã€ã¨åã¥ã‘ã¾ã—ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã¯ä»Šã§ã‚‚ã‚ˆãä½¿ã‚ã‚Œã¦ãŠã‚Šã€MySQLã®æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã”ã¨ã«æ”¹å–„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ç›´è¿‘5å¹´é–“ã§ç™»å ´ã—ã€ãªãŠã‹ã¤ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®ä¸ã§ç‰½å¼•åŠ›ã‚’å¢—ã—ã¦ã„ã‚‹é«˜å¯ç”¨æ€§ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã«ç€ç›®ã—ã¾ã™ã€‚ç§ã¯ãã®ä¸ã‹ã‚‰2ã¤ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’
tom__bo 2017/09/21
percona

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¡ãƒ¢ãƒªãƒ¼ä½¿ç”¨é‡ã‚’æœ€é©åŒ–ã™ã‚‹è¨å®šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ | Yakst
Percona Data Performance Blogã®ç¿»è¨³ã€‚Percona CEOã®Peter Zaitevã«ã‚ˆã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªãƒ¼ä½¿ç”¨é‡ã‚’ã©ã®ã‚ˆã†ã«æ±ºã‚ã‚‹ã¹ãã‹ã€ã¾ãŸãã‚Œã‚’æ±ºã‚ã‚‹æ™‚ã«æ°—ã«ã™ã‚‹ã¹ãã“ã¨ã¯ä½•ã‹ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€æœ€é©ãªMySQLã®ãƒ¡ãƒ¢ãƒªãƒ¼ä½¿ç”¨é‡ã‚’è¨å®šã™ã‚‹ãŸã‚ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’æ‰±ãŠã†ã¨æ€ã„ã¾ã™ã€‚ ä½¿ç”¨ã§ãã‚‹ãƒ¡ãƒ¢ãƒªãƒ¼ã®ãƒªã‚½ãƒ¼ã‚¹ã‚’ã©ã®ã‚ˆã†ã«ä½¿ã†ã‹æ£ã—ãè¨å®šã™ã‚‹ã®ã¯ã€MySQLã‚’æœ€é©ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã§ã‹ã¤å®‰å®šã—ã¦ä½¿ã†ãŸã‚ã«æœ€ã‚‚é‡è¦ãªã“ã¨ã®ã²ã¨ã¤ã§ã™ã€‚MySQL 5.7ã§ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã§ã¯éžå¸¸ã«å°‘ãªã„é‡ã®ãƒ¡ãƒ¢ãƒªã—ã‹ä½¿ã„ã¾ã›ã‚“ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾ã«ã—ã¦ãŠãã®ã¯ã€æœ€ã‚‚è‰¯ããªã„ã“ã¨ã®ã²ã¨ã¤ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã€ä¸é©åˆ‡ã«è¨å®šã—ã¦ã—ã¾ã†ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ›´ã«æ‚ªãã™ã‚‹(ã‚ã‚‹ã„ã¯ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã™ã‚‹)ã“ã¨ã«ã‚‚ãªã‚Šã‹ãã¾ã›ã‚“ã€‚ MySQLã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’è¨å®šã™ã‚‹ã«ã‚ãŸã£ã¦ã®æœ€åˆ
tom__bo 2016/06/14
MySQL

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

percona

tuning
ãƒªãƒ³ã‚¯
ç„¡åœæ¢ã§ALTERã§ãã‚‹Percona-Toolkitã®online-schema-change - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
MySQL5.5ã‚’ã¾ã ã¾ã çµ¶è³›åˆ©ç”¨ä¸ãªç§ã§ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹ç”¨ã—ã¦ã„ã‚‹ã¨INDEXè¿½åŠ ã‚„ã‚«ãƒ©ãƒ è¿½åŠ ã‚’è¡Œã„ãŸã„è¦æœ›ãŒå¤šã€…ç™ºç”Ÿã—ã¾ã™ã€‚ ãã‚Œã‚‚ç„¡åœæ¢ã§ã€‚ MySQL5.6ã‹ã‚‰ã¯ç„¡åœæ¢ã§INDEXè¿½åŠ ã‚„ã‚«ãƒ©ãƒ è¿½åŠ ãŒã§ãã‚‹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³DDLãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã‚«ãƒ©ãƒ è¿½åŠ ã¯ã¾ã è‰²ã€…åˆ¶ç´„ãŒã‚ã‚‹ã¿ãŸã„ã§ã™ãŒâ€¦ã€‚ http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html pt-online-schema-change MySQL5.5ã§ã‚‚ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’ã‚„ã‚ŠãŸã„ã®ã§ã€ æœ‰åãªã€ŒPercona-Toolkitã€ã«åŒæ¢±ã•ã‚Œã¦ã„ã‚‹pt-online-schema-changeã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ http://www.percona.com/software/percona-toolkit é€šå¸¸ã¯ãƒãƒƒã‚¯ãŒæŽ›ã‹ã£ã¦ã—ã¾ã†ALTER
tom__bo 2015/09/24
percona

MySQL
ãƒªãƒ³ã‚¯
percona-toolkitã®ç´¹ä»‹ã¨å„æ©Ÿèƒ½ã®æ—©è¦‹è¡¨ - Qiita
Percona Toolkitã¯MySQLç‰ã«é–¢ã™ã‚‹ä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã®é›†ã¾ã‚Šã§ã™ã€‚ Percona Toolkit Documentation ä»Šå›žã¯å„ãƒ„ãƒ¼ãƒ«ã®æ©Ÿèƒ½ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ ç´°ã‹ã„ä½¿ç”¨æ–¹æ³•ã«é–¢ã—ã¦ã¯éšæ™‚è¿½è¨˜äºˆå®šã€‚ pt-align ãƒ•ã‚¡ã‚¤ãƒ«ã‚„æ¨™æº–å…¥åŠ›ã‚’å—ã‘å–ã‚Šã€åˆ—ã‚’æƒãˆã¾ã™ã€‚
tom__bo 2015/08/20
ã‚ã¨ã§èªã‚€

percona

MySQL

RDB
ãƒªãƒ³ã‚¯
1