Mysql批量插入五千条数据怎么做优化

五千条的数据量插入时间达到了五分钟，有没有大佬有优化方式

用jdbc的批量处理去做。

调整bulk_insert_buffer_size
参考

variables - how to set bulk_insert_buffer_size in mysql? - Stack Overflow I want to set bulk_insert_buffer_size variable for insert. I searched from other pages too, all they are saying about my.cnf. But there is no my.cnf in my system. I checked my.ini and there is no s... https://stackoverflow.com/questions/20301010/how-to-set-bulk-insert-buffer-size-in-mysql