WebFaction
Community site: login faq

In a private MySQL instance, I have 166 fields for a particular table which was created long ago.

innodb_file_per_table
innodb_file_format = Barracuda

Now, I'm incorporating TinyMCE for some of the fields (text) in the front-end. The user can enter a lot of HTMLized content.

What is the maximum row limit ?

asked 01 May, 05:35

anjanesh
66619
accept rate: 25%

Are you referring to the maximum size in bytes of a row or the maximum number of rows an innodb table can hold?

(01 May, 11:52) iliasr ♦♦

Bytes in one row.

(01 May, 13:51) anjanesh

According to the official documentation, the maximum row size is 65,535 bytes.

permanent link

answered 09 May, 07:20

iliasr ♦♦
1.9k14
accept rate: 36%

Thanks for the link. According to it a TEXT field can store L + 2 bytes, where L < 216. How can I otherwise store large amounts of text (HTML) in a text field ?

(09 May, 11:26) anjanesh

2^16 is 65536. You need to break up the field into chunks and store them in many fields.

(09 May, 21:41) johns ♦♦

Oh. I hope this is not 2^16 per row. 2^16 per TEXT field is acceptable I think.

(10 May, 14:47) anjanesh
1

We don't have any control over MySQL's limitations. Your application code must operate within those limits or use an alternative method to store the text.

(10 May, 21:12) johns ♦♦

Is the row limit higher in PostgreSQL ?

(11 May, 03:50) anjanesh

I believe so, as far as I can tell there is no limit on text types in postgres.

(11 May, 21:30) johns ♦♦

But I'm surprised that Uber migrated from Postgres to MySQL : https://eng.uber.com/mysql-migration/

(11 Jun, 06:17) anjanesh
showing 5 of 7 show 2 more comments
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:

×168
×1

question asked: 01 May, 05:35

question was seen: 209 times

last updated: 11 Jun, 06:17

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2016 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM