Understanding Bulk Index Creation in InnoDB (and innodb_sort_buffer_size)

(Jean-François Gagné) In a previous post, I presented an Unexpected Memory Consumption for Bulk Index Creation in InnoDB. This was triggered by an increased innodb_sort_buffer_size and as stated in another post: “the sorting algorithm does not scale well with large sort buffers”. In this post, I w

Read More - Register for Free Membership