Purpose

Specifies the size (in bytes) of the chunks the driver uses to send long data to the server.

Valid Values

x

where:

x
is an integer not exceeding the value of the MySQL max_allowed_packet system variable.
If the value of LobCommandSize is larger than the value of the max_allowed_packet variable, the driver sends long data in chunks of the size set by the max_allowed_packet variable.

Example

If the total size of a long data value is 3 MB and LobCommandSize is set to the default value of 1048576 (bytes), the driver sends the long data to the server in chunks of 1,048,576 bytes.

Default

1048576 (bytes)

Data Type

int