mysql set bulk_insert_buffer_size

设置为120m

mysql> set session bulk_insert_buffer_size = 1024 * 1024 * 1;

show variables like '%bulk%';

+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| bulk_insert_buffer_size | 125829120 |
+-------------------------+-----------+
1 row in set (0.00 sec)