…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb…, read detailed investigation what is the reason of performance drop in next post. And last one workload I …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…in-memory. Benchmark on IO bound workload was performed with a buffer pool size of 1G, while benchmark on in-memory workload was performed… Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # performance sort_buffer_size = 8M read_…:autoextend innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… per second InnoDB needs to perform. So let me point out the optimizations I used for Percona Server: innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…innodb_write_io_threads = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 128M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 1900M innodb_log_files_in_group = 2 In…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
…innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_io_capacity = 4000 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_method = O_DIRECT innodb…
