…MySQL…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
… since MySQL 4.1 this option is used in narrow range of cases – if you retrieve few 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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…=1000M 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=…_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_data_home_dir = /db innodb_data_file_path = ibdata1:10M:…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… in terms of data and index size: mysql> show table status like “…: 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
… Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_… skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes for…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 4000 sec but the result is taken only for last 2000 sec…=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… essential for expand_fast_index_creation, because temporary files for merge-sorting are created…for InnoDB tables and thus, is just a special case of the previous one: mysql… Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728 Auto…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…MySQL/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data…_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_… for 1 innodb table (25 inserts or .2 seconds of data…data length was 231B. It seemed the writing of the insert is what was taking all the time. Data…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… it takes more than 3 mins for execution. Below i have given the … /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_…data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01.as.osti.local-slow.log log-warnings=2 max…
