…max_join_sizeblogpercona.commanual max_length_for_sort_datablogpercona.commanual max_prepared_stmt_countblogpercona.commanual max_relay_log_sizeblogpercona.commanual max_seeks_for_keyblogpercona.commanual max_sort_lengthblogpercona.commanual max…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… it does not have to do random disk seeks to fetch secondary index pages to the buffer …: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free:… the restore time for a regular dump with a dump created with –innodb-optimize-keys (the test database…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…€™t perfectly serial it’s having to seek on disk which slows down throughput. If … performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB. … might make sense for a foreign key to reference only a prefix of the primary key. PZ: Thanks Heikki…
