Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

max_allowed_packet

erkuleserkules ContributorInactive User Role Beginner
According to http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#option_mysqld_max_allowed_packet
#v+

The maximum size of one packet or any generated/intermediate string.The packet message buffer is initialized to net_buffer_length bytes, but can grow up to max_allowed_packet bytes when needed. This value by default is small, to catch large (possibly incorrect) packets.You must increase this value if you are using large BLOB columns or long strings. It should be as big as the largest BLOB you want to use. The protocol limit for max_allowed_packet is 1GB. </pre>

#v-

With other words: max_allowed_packet needs to be >= than the largest column?

thx

Comments

  • sterinsterin Mentor Inactive User Role Contributor
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">erkules wrote on Wed, 12 December 2007 10:15</td></tr><tr><td class="quote">

    With other words: max_allowed_packet needs to be >= than the largest column?

    </td></tr></table>
    Actually it means that it must be larger than the largest query you are sending.

    So if you are inserting into several columns in the same insert. It has to be larger than the combined size of the data inserted to all these columns.
  • erkuleserkules Contributor Inactive User Role Beginner
    Oh thx I got it wrong. I thought its about the packet MySQL is sending. :worship: )
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.