…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: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… fields (less than max_length_for_sort_data) data should be stored in sort buffer and sort file so there would be no need for read_rnd_buffer, if… than max_length_for_sort_data in its static presentation. We should do benchmarks sometime to see how it really impacts performance both for MyISAM and Innodb.
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max_sort_length…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…using merge sort, InnoDB has to scan the clustered index only once, even though the actual sorting is done separately for …Name: t Engine: InnoDB Version: 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… Name: sbtest Engine: InnoDB Version: 10 Row_format: Compact Rows: 10000060 Avg_row_length: 224 Data_length: 2247098368 Max_data_length: 0 Index_length: 1460322304 Data_free: 7340032 … for in memory case, even though in this case the gain is just about 2x for this workload. Still substantial. Sorting…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…InnoDB DEFAULT CHARSET=latin1 COMMENT=’Data from BTS ontime flight data. Data for Origin and Destination airport data…InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data…skip-name-resolve sort-buffer-size=512K…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…Specific options myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=… inserts per transaction for 1 innodb table (25 inserts or .2 seconds of data to be inserted)…data length was 231B. It seemed the writing of the insert is what was taking all the time. Data…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…data) Benchmark length: 4000 sec but the result is taken only for…innodb_io_capacity = 20000 innodb_io_capacity_max = 40000 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max… = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = …
