…innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…sort_buffer_sizeblogpercona.commanual Sort_merge_passesblogpercona.commanual Sort_rangeblogpercona.commanual Sort_rowsblogpercona.commanual Sort…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general …5MB. Good to see innodb log re-sizing is made automatic now. innodb_old_blocks_time = 1000…sort_buffer_size = 256K Good choice for very small sorts but more complicated queries will suffer causing more frequent file based sorts…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt… are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server…sometimes see unlikely settings, such as making the sort buffer size much too large (a gigabyte comes to mind…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
… than command line options (like much of Performance Schema configuration). Innodb settings alone push 100. True you do not need to… natural step I would like to see taken is having MySQL to chose sensible values for them automatically, based on system… into account. Is not it silly for example MySQL would use the same sort_buffer_size whenever there is only one query running and…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size…sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
