MySQL Forums
Forum List  »  InnoDB

Re: Modify maximum number of columns
Posted by: Rick James
Date: September 13, 2015 07:54PM

5.6.9 raised the InnoDB column limit a little, to 1017. However, there is ~8KB limit on the size of a record. That may be what you are hitting.

A couple of thoughts...

Changing an INT (4 bytes) to a MEDIUMINT (3 bytes) may help avoid the 8KB. (And lots of other potential changes.

Also, by changing the block size from 16KB (the default) to 32KB, I _think_ the 8KB grows to ~16KB. (No, going to 64KB does not give you another doubling.) This could also get you from 766 all the way to 1017. I do not know the details, and have heard of no one who has done it. Warning: I think it has to be done for _all_ InnoDB tables in the system.

Options: ReplyQuote


Subject
Views
Written By
Posted
1471
September 12, 2015 11:05AM
910
September 12, 2015 12:27PM
857
September 12, 2015 05:06PM
828
September 12, 2015 05:41PM
909
September 12, 2015 08:31PM
883
September 13, 2015 03:30PM
Re: Modify maximum number of columns
818
September 13, 2015 07:54PM
788
September 13, 2015 08:20PM


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.