SET bulk_insert_buffer_size =1024*1024*256;
SHOW VARIABLES LIKE '%bulk%';
If you want to keep that value when you restart mysql, just add this to my.cnf
[mysqld]
bulk_insert_buffer_size = 256M
SET bulk_insert_buffer_size =1024*1024*256;
SHOW VARIABLES LIKE '%bulk%';
If you want to keep that value when you restart mysql, just add this to my.cnf
[mysqld]
bulk_insert_buffer_size = 256M