MySQL :: Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

Posted by: Rick James
Date: May 02, 2014 09:14PM

Similar:
http://forums.mysql.com/read.php?22,567500,567502

Compact and Compressed are different. See
http://dev.mysql.com/doc/refman/5.5/en/innodb-row-format-dynamic.html

ALTER TABLE foo ROW_FORMAT=DYNAMIC;

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

5123

Tom Robinson

May 01, 2014 06:13PM

Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

8513

Tom Robinson

May 02, 2014 12:07AM

Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

4167

Rick James

May 02, 2014 09:14PM

Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

2927

Tom Robinson

May 04, 2014 07:00PM

Re: innodb_large_prefix and ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

3408

Tom Robinson

May 04, 2014 07:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.