MySQL Forums
Forum List  »  General

Re: Row size too large (> 8126).
Posted by: Rick James
Date: May 23, 2016 04:07PM

Even if you increase the page size to 64KB, you can't put more than 16KB in one row. You must change the page size for _all_ tables in the server. This is not a pretty picture; let's try to solve your problem another way.

If you need 400 "fields", will you be really using more than a few of them in SQL? If not, then encode it as JSON and have one large column (TEXT or MEDIUMTEXT) that contains the JSON. (And have a few other columns for filtering/sorting/etc.)

Your application can do the encode/decode. What language are you using?

Options: ReplyQuote


Subject
Written By
Posted
Re: Row size too large (> 8126).
May 23, 2016 04:07PM


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.