MySQL AI User Guide
MySQL AI maintains several variables that configure its operation.
| 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”.
| 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”.