MySQL(InnoDB) 㧠"Index column size too large. The maximum column size is 767 bytes." ã„ã‚れるã¨ãã®å¯¾ç– - ã‹ã¿ã½ã‚ーるtl;dr: MySQL 5.5.14以é™ã ã¨innodb_large_prefixオプションã§3072ãƒã‚¤ãƒˆã¾ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å¼µã‚Œã‚‹ MySQL(InnoDB)ã§ã¯ã€ã²ã¨ã¤ã®ã‚«ãƒ©ãƒ ã®ã‚ープレフィックスã®æœ€å¤§å€¤ãŒ767ãƒã‚¤ãƒˆã¨ã„ã†åˆ¶é™ãŒã‚ã‚‹ã®ã§ã€ã¤ã„ã†ã£ã‹ã‚Šã—㦠Index column size too large. The maximum column size is 767 bytes. ã¨ã‹ Specified key was too long; max key length is 767 bytes ã¨ã„ã£ãŸã‚¨ãƒ©ãƒ¼ã‚’見ãŸã“ã¨ã‚る人ã¯å¤šã„ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ よãã‚るケースã ã¨ã€varchar(256)以上ã®utf8ãªã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã‚ã†ã¨ã™ã‚‹ã¨ã“ã®ã‚¨ãƒ©ãƒ¼ã¨ã”対é¢ã§ãã¾ã™ã€‚ CREATE TABLE t (c varchar(256), index (c)); ERROR
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ - SH2ã®æ—¥è¨˜
vagrantã§CentOSã®VMã‚’ç«‹ã¡ã‚ã’ã¦ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé…ã„時ã«è©¦ã™ã“㨠- $shibayu36->blog;
RHEL6/CentOS6ã§ã¯ã€single-request-reopen ã‚’å¿…é ˆã«ã—ãŸã„…
{{#tags}}- {{label}}
{{/tags}}