MySQL Forums
Forum List  »  General

Re: max_allowed_packet
Posted by: Jon Stephens
Date: December 19, 2023 02:31AM

The protocol limit for max_allowed_packet is 1GB.

The largest possible packet that can be transmitted to or from a MySQL 8.2 server or client is 1GB.

In other words, the upper limit is built into the client-server protocol and max_allowed_packet cannot be increased beyond this value.

If you need to transmit data that is larger than this, you'll need to break it up in your application into chunks that are no more than 1 GB each. Or rethink your application design. Or rewrite MySQL's networking code.


Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
December 17, 2023 08:54AM
Re: max_allowed_packet
December 19, 2023 02:31AM
December 23, 2023 11:19PM

Sorry, only registered users may post in this forum.

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.