…innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_…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_…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 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…
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…
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them … building index by sort with small buffer – this comes from building index on long character field with very short length, Innodb would use fixed size records for sort…
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 = …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
…you 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 …
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…
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…sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer…
