Any idea how the bulk_insert_buffer_size affects inserts when using INSERT INTO … SELECT versus LOAD DATA INFILE. This is mainly for new tables without existing data.
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… to note that the InnoDB buffer pool for my 5.6 instance is 128MB – smaller than the size of my DIR data…, which discusses improving bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB…_state | 0 | +—————————+——–+ 10 rows in set (0.00 sec) mysql> insert into dir_test_innodb (full_name, details) SELECT reverse(full…
