Re: 'max_allowed_packet' paramater can't exceed 17 mo - Thimble Smith - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: 'max_allowed_packet' paramater ca...

From	Sent On	Attachments
Sylvain SANTRISSE	22 Dec 2000 04:31
Thimble Smith	22 Dec 2000 04:49
Michael Widenius	23 Dec 2000 03:01

Subject:	Re: 'max_allowed_packet' paramater can't exceed 17 mo
From:	Thimble Smith (ti...@mysql.com)
Date:	12/22/2000 04:49:14 AM
List:	com.mysql.lists.bugs

On Fri, Dec 22, 2000 at 01:31:57PM +0100, Sylvain SANTRISSE wrote:

How-To-Repeat: insert a blob bigger than 15 mo via any API.

The manual for SHOW VARIABLES says: ``max_allowed_packet'' The maximum size of one packet. The 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 big (possibly wrong) packets. You must increase this value if you are using big `BLOB' columns. It should be as big as the biggest `BLOB' you want to use. The current protocol limits `max_allowed_packet' to 16M.

It's not possible to have a packet larger than 16M, because of a limit in the client-server protocol.

Tim