EPUB | CHM | PDF

TMySQLDatabase.Properties.MaxAllowedPacketSize

Top Previous Next

note Since v2.6.1

Sets max_allowed_packet connection parameter value.

Syntax:

property MaxAllowedPackedSize : Cardinal; default 16; //in megabytes

Description:

Sets max_allowed_packet connection parameter value in megabytes. Default value is 16 Mb. Actually this is the maximum size of data in a single field of single row that can be transferred from server to client or from client to server. You can increase it if you are working with large BLOB values. Maximum value is 1024 Mb (for current MySQL versions - 5.0/5.1).

warning Please note that this is client-side value. The server has its own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both on the client and on the server.