MySQL Forums
Forum List  »  Perl

Re: Max_allowed_packet problem
Posted by: Rick James
Date: June 07, 2015 06:48PM

Check these variables (this is what I have):
| query_alloc_block_size       | 8192  |
| query_prealloc_size          | 8192  |
| transaction_alloc_block_size | 8192  |
But it sounds like a lower level (TCP / Ethernet) packet size.

Or maybe I am looking at the wrong aspect. 8KB is very small for a result -- a row with a large TEXT field will need more.

(Sorry, but this is in an area where I don't have a lot of knowledge.)

Options: ReplyQuote

Written By
April 06, 2015 10:06AM
Re: Max_allowed_packet problem
June 07, 2015 06:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.