March 13, 2015

MySQL 5.7.6: Make InnoDB fill factor settable

Worklog: git show 3f4abb52fbfe9118fc94a4b60876c16e5aa2e0e0 Make InnoDB fill factor settable (WL#6747) : This work by Yasufumi Kinoshita makes themerge_threshold settable per index. Until now it has been fixed at 50%. If the  amount of data within the page falls below the merge_threshold, e.g. when deleting a row or shortening it via an update, InnoDB will attempt to merge it […]