… 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=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options 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 = 10G #myisam_max_extra_sort_file_size…
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: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most … of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, …starting at 10:03:36. Also, the server is reading a lot (~150MB/s) but doing very little …
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… for this workload-hardware innodb_io_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan_depth…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… for documentation for read_rnd_buffer_size you would find descriptions such as “The read_rnd_buffer_size is used after a sort, when reading rows in… had name very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only… – which are offsets for MyISAM and primary key values for Innodb or storing full data which is being retrieved (good for…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would … large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large allocations. Finally…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…totalblogpercona.commanual Innodb_buffer_pool_read_aheadblogpercona.commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool…
