Data Limit on MySQL DB Insert

Question

I was wondering if there was a limit to the size of data to be Inserted into a MySQL database?

I seem to be successfully Inserting records but when certain textarea fields get large, it seems like the records won't Insert. Can someone let me know if there is a size limit or if there is just an error?

Thanks.

Brett

There is the max_allow_packet setting which governs the client<->server connection. — Marc B
– Marc B, Commented Oct 4, 2011 at 17:41
I use to change the value of max_allowed_packet to 32M. You can do it in the config file. — Mario
– Mario, Commented Oct 4, 2011 at 19:59

fatnjazzy · Accepted Answer · 2011-10-04 17:42:41Z

2

It depends in the disk and memory size and network limitations mostly:

Quote From my sql website:

http://dev.mysql.com/doc/refman/5.0/en/blob.html

The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program

answered Oct 4, 2011 at 17:42

fatnjazzy

6,14212 gold badges60 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data Limit on MySQL DB Insert

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related