max_allowed_packet

Max packet length to send to or receive from the server

See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

PARAMETERS

Command-line

--max_allowed_packet=#

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

BIGINT UNSIGNED

Minimum Value

1024

Maximum Value

1073741824

Default Value

16777216

SkySQL Default (Standalone 10.4)

33554432

SkySQL Default (Standalone 10.5)

33554432

SkySQL Default (Primary/Replica 10.4)

33554432

SkySQL Default (Primary/Replica 10.5)

33554432

SkySQL Default (Analytical 10.4)

16777216

SkySQL Default (HTAP 10.4)

16777216

SkySQL Default (Xpand 10.5)

33554432

See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.

CHANGE HISTORY

Release Series

History

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Default value changed in MariaDB Community Server 10.2.4 from 4194304 to 16777216

EXTERNAL REFERENCES