Announcement

Announcement Module
Collapse
No announcement yet.

max_allowed_packet

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • max_allowed_packet

    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.

    #v-

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

    thx

  • #2
    erkules wrote on Wed, 12 December 2007 10:15


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


    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.

    Comment


    • #3
      Oh thx I got it wrong. I thought its about the packet MySQL is sending. :worship: )

      Comment


      • #4
        erkules wrote on Thu, 13 December 2007 14:07

        Oh thx I got it wrong. I thought its about the packet MySQL is sending. :worship: )

        It's kind of, it's the packet buffer that MySQL allocates and each query must fit into that buffer.

        But when that data is transfered over a network it still has to be broken down even further. Which is performed by the network stack in the OS. Because the largest packet size that can be sent over an ethernet connection is 1518 bytes and still the actual useful data transfered is even less than that.

        Comment

        Working...
        X