Because MySQL does not have native bulk load support, the MySQL driver emulates bulk load using the standard batch mechanism. See Using a DDBulkLoad Object for more information.
Only one connection property affects how bulk load works with the MySQL driver (see the following table).
Table 41. Summary: Bulk Load Properties for the MySQL Driver
Property
Description
BulkLoadBatchSize
Provides a suggestion to the driver for the number of rows to load to the database at a time when bulk loading data. The default is 1000.