[B! alter] justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

justoneplanet id:justoneplanet

alterã«é–¢ã™ã‚‹justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

~mysqlatfacebook/mysqlatfacebook/tools : files for revision 20
justoneplanet 2013/01/18
MySQL

alter table

alter

facebook
ãƒªãƒ³ã‚¯
[MySQL] ã‚µã‚¤ãƒˆç„¡åœæ¢ã§ ALTER TABLE ã‚’å¯èƒ½ã«ã™ã‚‹ pt-online-schema-change | ãƒã‚·ãƒ£ãƒã‚°ã€‚
æ—©ãæ²–ç¸„ã‚ªãƒ•ã‚£ã‚¹ä½œã£ã¦ãã‚Œãªã„ã‹ãªãƒ¼å¯’ãã¦ä»•äº‹ã«ãªã‚‰ãªã„ã‚ˆï¼ã¿ãªã•ã‚“ã“ã‚“ã«ã¡ã¯ nakamura ã§ã™ã€‚ ãƒãƒ¼ãƒ³ãƒå¾Œã‚‚ã‚µã‚¤ãƒˆã®é‹ç”¨ã‚’å—ã‘æŒã£ã¦ã„ã‚‹ã¨ã©ã†ã—ã¦ã‚‚æ©Ÿèƒ½è¿½åŠ ãªã©ã§ DB ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã‚’å¤‰ãˆãªãã‚ƒã„ã‘ãªã„ã£ã¦äº‹ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿é‡ãŒã•ã»ã©å¤šããªã‘ã‚Œã°å•é¡Œã«ãªã‚‰ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€MySQL ã® ALTER TABLE ã¯ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã«å¯¾ã—ã¦æ›¸ãè¾¼ã¿ãƒãƒƒã‚¯ã‚’ã‹ã‘ã¦ã—ã¾ã†ãŸã‚ã€ã‚µã‚¤ã‚ºã®å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã®å ´åˆçµæ§‹ãªæ™‚é–“ã‚µã‚¤ãƒˆã‚’æ¢ã‚ã‚‹å¿…è¦ãŒå‡ºã¦ãã¦ã—ã¾ã£ãŸã‚Šã€‚ã€‚ã€‚ã„ã„åŠ æ¸›ãªã‚“ã¨ã‹ãªã‚‰ãªã„ã®ã‹ã‚ˆï¼ã¨æ€ã£ã¦æŽ¢ã—ã¦ã„ãŸã‚‰ä¸ã€…ã„ã„æ„Ÿã˜ã®ãƒ„ãƒ¼ãƒ«ã‚’è¦‹ã¤ã‘ãŸã®ã§ä»Šå›žã¯ãã®ã”ç´¹ä»‹ã§ã™ã€‚ Percona Toolkit pt-online-schema-change ã¯ Percona Toolkit ã¨ã„ã† MySQL ã‚’ä½¿ã†ä¸Šã§ã®ä¾¿åˆ©æ©Ÿèƒ½ã‚’ã¾ã¨ã‚ãŸãƒ„ãƒ¼ãƒ«ç¾¤ã«å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚pt-online-sc
justoneplanet 2013/01/18
MySQL

alter table

alter
ãƒªãƒ³ã‚¯
MySQLã§ALTER TABLEæ–‡ã®é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹ - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆã‚’è¡Œã†ã«ã¯ã€ALTER TABLEæ–‡ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚MySQLã®ALTER TABLEæ–‡ã¯ã€å¤‰æ›´å¾Œã®å®šç¾©ã«ã‚‚ã¨ã¥ãä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã€å¤‰æ›´å‰ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€æœ€å¾Œã«äºŒã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã‚‹ã¨ã„ã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã«ã¤ã„ã¦ã‚‚ã€ç¾åœ¨ã®ã¨ã“ã‚å¤§åŠã®ã‚±ãƒ¼ã‚¹ã§å†…éƒ¨çš„ã«ALTER TABLEæ–‡ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã¾ã™ã€‚ ALTER TABLEæ–‡ã®æ€–ã„ã¨ã“ã‚ã¯ã€å‡¦ç†ãŒã‚‚ã†ã™ãçµ‚ã‚ã‚‹ã®ã‹ã©ã†ã‹ãŒåˆ†ã‹ã‚‰ãªã„ã¨ã“ã‚ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºãŒ1GBã‚’è¶…ãˆã‚‹ã‚ãŸã‚Šã‹ã‚‰åˆ†å˜ä½ã®æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ã«ãªã‚Šã€100GBã¨ã‚‚ãªã‚‹ã¨æœ¬å½“ã«çµ‚ã‚ã‚‹ã®ã‹ï¼Ÿã¨è¦‹ã¦ã„ã¦ä¸å®‰ã«ãªã‚Šã¾ã™ã€‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ™‚é–“ãŒé™ã‚‰ã‚Œã¦ã„ã‚‹å ´åˆã¯ã€ä½œæ¥ã‚’ä¸æ–ã™ã¹ãã‹ã©ã†ã‹é›£ã—ã„åˆ¤æ–ã‚’è¿«ã‚‰ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ å®Ÿã¯ã€ã¨ã„ã†ã»ã©ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ALTER
justoneplanet 2012/10/05
alter

é€²æ—ç®¡ç†

MySQL
ãƒªãƒ³ã‚¯
MySQLã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“ã‚Œã‚‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„æ·±å¤œæ—©æœå¸¯ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ—¥ã¯ãã‚Œã‚’ç„¡åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ åŸºæœ¬çš„ãªã‚¢ã‚¤ãƒ‡ã‚¢ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å¯¾è±¡ã®å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚Œã‚‹æ›´æ–°å‡¦ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¾ã™ å·®åˆ†ãƒ‡ãƒ¼ã‚¿ã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆãŸæ–¹ã¯çµæ§‹ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–ã‚Œã‚‹ã‹ã©ã†
justoneplanet 2012/01/18
MySQL

alter

table

ãƒãƒƒã‚¯

lock
ãƒªãƒ³ã‚¯
ALTER TABLEã‚’ä¸Šæ‰‹ã«ä½¿ã„ã“ãªãã†ã€‚
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã—ãŸã„ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå£Šã‚Œã¦ã—ã¾ã£ãŸã®ã§å†ä½œæˆã—ãŸã„ã€‚ãã‚“ãªå ´åˆã¯ALTER TABLEã‚’ä½¿ã†ã€‚ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã™ã‚‹ãŠé¦´æŸ“ã¿ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚‹ãŒã€ãã®æŒ™å‹•ã¯æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã€‚ï¼ˆã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ãŠã¼ã—ãæ–¹ã€…ã‹ã‚‰ã‚‚åº¦ã€…è³ªå•ã‚’å—ã‘ã‚‹ã€‚ï¼‰ãã‚“ãªã‚ã‘ã§ã€ä»Šæ—¥ã¯ALTER TABLEã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã¾ãšçµè«–ã‹ã‚‰è¨€ã†ã¨ã€ãªã‚“ã¨MySQLã®ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ã‚³ãƒ”ãƒ¼ã—ç›´ã™ã®ã§ã‚ã‚‹ã€‚ãªã‚“ã¦ç„¡é§„ãªã“ã¨ã‚’ï¼ï¼Ÿã¨æ€ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼‰ã®å¤‰æ›´ã‚’å‹•çš„ã«è¡Œã†ã«ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚µãƒãƒ¼ãƒˆãŒå¿…è¦ã§ã‚ã‚Šã€å‹•çš„ãªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã¾ã å°‘ãªã„ã®ã§ã‚ã‚‹ã€‚ï¼ˆå‹•çš„ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯MySQL Clusterãã‚‰ã„ã ã€‚ã—ã‹ã‚‚è¿½åŠ ã ã‘ã€‚ï¼‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åˆ©ç”¨å‡ºæ¥ã‚‹MyISAMã¯Inn
justoneplanet 2012/01/18
alter table

mysql

alter
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 24.3 ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ç®¡ç†
SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ã¦ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å¤‰æ›´ã™ã‚‹æ–¹æ³•ã¯å¤šæ•°ã‚ã‚Šã¾ã™ã€‚ALTER TABLE ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–æ‹¡å¼µã‚’ä½¿ç”¨ã—ã¦ã€æ—¢å˜ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’è¿½åŠ ã€å‰Šé™¤ã€å†å®šç¾©ã€ãƒžãƒ¼ã‚¸ã¾ãŸã¯åˆ†å‰²ã§ãã¾ã™ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ãŠã‚ˆã³ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹æƒ…å ±ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚Šã¾ã™ã€‚ ä»¥é™ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯æ¬¡ã®ãƒˆãƒ”ãƒƒã‚¯ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ RANGE ã¾ãŸã¯ LIST ã«ã‚ˆã£ã¦ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ç®¡ç†ã«ã¤ã„ã¦ã¯ã€ã‚»ã‚¯ã‚·ãƒ§ãƒ³24.3.1ã€ŒRANGE ãŠã‚ˆã³ LIST ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ç®¡ç†ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ HASH ãŠã‚ˆã³ KEY ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ç®¡ç†ã«ã¤ã„ã¦ã¯ã€ã‚»ã‚¯ã‚·ãƒ§ãƒ³24.3.2ã€ŒHASH ãŠã‚ˆã³ KEY ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ç®¡ç†ã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ãŠã‚ˆã³ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹æƒ…å ±ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«
justoneplanet 2010/12/20
mysql

partition

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³

alter

5.1.6
ãƒªãƒ³ã‚¯
1