Sketchy Polytopes

Notes on databases: max allowed packet size

The max.allowed.packet size limits the size of query packet from client. It may be specified at both client and server side. JDBC clients may need to pass “sessionVariables=maxAllowedPacket=…” during connection setup since the driver may not support changing session properties once the session has been established.See also this post. On server side, mysql --max_allowed_packet=32M to set the property and show variables like 'max_allowed_packet to query it.

Note that max allowed packet property is distinct from the fetch size property, which limits the number of rows fetched from the database.