WebFaction
Community site: login faq

I have a table with 165 fields and most of them are text or varchar(1000).
Now, when entering data into one such row, I get

mysql_error() = Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

How do I increase the capacity of the row ? (InnoDB)

asked 14 Mar, 06:43

anjanesh's gravatar image

anjanesh
58617
accept rate: 25%


The solution is to make some changes to the MySQL server config, and to your table structure, as described here on ServerFault: Issue with maximum row size in MySQL

To do that on WebFaction, you'll need to install a private MySQL instance and then modify the etc/my.cnf for the private instance.

permanent link

answered 14 Mar, 18:11

seanf's gravatar image

seanf ♦♦
12.0k21534
accept rate: 37%

Before I try running a private instance, I would like to know if changing the table to MyISAM would have any side-affects. I changed the table to MyISAM on my localhost and I could enter the data.

(14 Mar, 18:34) anjanesh anjanesh's gravatar image

There seems to be a good summary of the differences between the two engines here: What are the main differences between InnoDB and MyISAM?

(15 Mar, 00:11) seanf ♦♦ seanf's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×165

question asked: 14 Mar, 06:43

question was seen: 1,033 times

last updated: 15 Mar, 00:11

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2017 PARAGON INTERNET GROUP LIMITED
WEBFACTION IS A SERVICE OF PARAGON INTERNET GROUP LIMITED
REGISTERED IN ENGLAND AND WALES 7573953 - VAT REGISTRATION NUMBER 182147021
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM