Reply to thread

Message

If you reduce the InnoDBpage size to 8KB or 4KB by specifying the innodb_page_size option when creating the MySQL instance, the maximum length of the index key is lowered proportionally, based on the limit of 3072 bytes for a 16KB page size. That is, the maximum index key length is 1536 bytes when the page size is 8KB, and 768 bytes when the page size is 4KB.

http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html[DOUBLEPOST=1382015913][/DOUBLEPOST]Morpheus, is there a configuration file I can change so as to test a mysql 5.6 or higher install?
I was thinking about installing 5.5, import a few things, Export the DB, upgrade it to 5.6 and see what happens

<blockquote data-quote="breese" data-source="post: 1034257" data-attributes="member: 114299">If you reduce the InnoDB<a href="https://forum.team-mediaportal.com/glossary.html#glos_page_size" target="_blank">page size</a> to 8KB or 4KB by specifying the <a href="https://forum.team-mediaportal.com/innodb-parameters.html#sysvar_innodb_page_size" target="_blank">innodb_page_size</a> option when creating the MySQL instance, the maximum length of the index key is lowered proportionally, based on the limit of 3072 bytes for a 16KB page size. That is, the maximum index key length is 1536 bytes when the page size is 8KB, and 768 bytes when the page size is 4KB.&nbsp;<a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html" target="_blank">http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html</a>[DOUBLEPOST=1382015913][/DOUBLEPOST]Morpheus, is there a configuration file I can change so as to test a mysql 5.6 or higher install?I was thinking about installing 5.5, import a few things, Export the DB, upgrade it to 5.6 and see what happens</blockquote>

[QUOTE="breese, post: 1034257, member: 114299"] If you reduce the InnoDB[URL='https://forum.team-mediaportal.com/glossary.html#glos_page_size'][U]page size[/U][/URL] to 8KB or 4KB by specifying the [URL='https://forum.team-mediaportal.com/innodb-parameters.html#sysvar_innodb_page_size'][U]innodb_page_size[/U][/URL] option when creating the MySQL instance, the maximum length of the index key is lowered proportionally, based on the limit of 3072 bytes for a 16KB page size. That is, the maximum index key length is 1536 bytes when the page size is 8KB, and 768 bytes when the page size is 4KB. [url]http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html[/url][DOUBLEPOST=1382015913][/DOUBLEPOST]Morpheus, is there a configuration file I can change so as to test a mysql 5.6 or higher install? I was thinking about installing 5.5, import a few things, Export the DB, upgrade it to 5.6 and see what happens [/QUOTE]