In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like 13GB… pages. In this case, InnoDB has to flush some data to be able to perform the read. For this, InnoDB uses the LRU list… 3/4 of innodb_log_file_size * innodb_log_files_in_group. If you have these conditions and observe intensive writes, InnoDB is using…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_method = O_…help the performance. * This test uses “innodb_read_ahead = 0″ (The both of read-ahead are disabled) “innodb_ibuf_contract_const = 50000″ “innodb_ibuf…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read…innodb-log-block-size ( 512 bytes), and another with –innodb-log-block-size=4096. Full benchmark…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not give you better performance…disk during this read-only benchmark. Why ?…performance problems. Interesting enough Innodb has a very similar task of managing its own cache of file descriptors (set by innodb…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative performance implications. On the other …buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… copied to processing thread local storage on Key Read Request. This lock is per key cache so …is a problem is benchmark run with disabled key_cache (=0). Results for MyISAM with key_buffer_size=0 Threads … InnoDB, and results: Threads Queries/sec 1 296 2 341 4 544 8 493 16 498 InnoDB both performs …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…INNODB_BUFFER_POOL_READ_AHEAD | 0 | | INNODB_BUFFER_POOL_READ_AHEAD_EVICTED | 0 | | INNODB_BUFFER_POOL_READ_REQUESTS | 3776369 | | INNODB_BUFFER_POOL_READS | 191571 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, …the join_buffer_size and the read_rnd_buffer_size/mrr_buffer_size and both of these buffers should be increased appropriately for the best possible performance gain. This…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…make sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not …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_read_io_threads = 8 innodb…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…workload was performed with a buffer pool size of 1G, while benchmark on in-memory workload was performed with a buffer pool size of 6G. The benchmarks … read_rnd_buffer_size=32M optimizer_switch=’batched_key_access=on’ join_buffer_size=32M MariaDB 5.5.20 Configuration innodb_file_per_table=1 innodb_…
