7.1 System Variables

MySQL AI maintains several variables that configure its operation.

• bulk_loader.data_memory_size

  Command-Line Format	--bulk_loader.data_memory_size=#
  System Variable	bulk_loader.data_memory_size
  Scope	Global
  Dynamic	Yes
  SET_VAR Hint Applies	No
  Type	Integer
  Default Value	(0.125) * #memory GB
  Minimum Value	67108864
  Maximum Value	1099511627776

  Specifies the amount of memory to use for LOAD DATA with ALGORITHM=BULK, in bytes. See: Section 3.1, “Bulk Ingest Data”.

• bulk_loader.concurrency

  System Variable	bulk_loader.concurrency
  Scope	Global
  Dynamic	Yes
  SET_VAR Hint Applies	No
  Type	Integer
  Default Value	(1/2) * #vcpus
  Minimum Value	1
  Maximum Value	1024

  The maximum number of concurrent threads to use by one LOAD statement with ALGORITHM=BULK. See: Section 3.1, “Bulk Ingest Data”.