… innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb… good settings out-of-box, but I am ready to tune something if there are suggestions.
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin….that the entire data set fits into the buffer pool, so there are no reads from disk. … the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20%…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but still small… via /proc, I’d vote in the other direction. Stay tuned for part two of this series, wherein we’ll take…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…. innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size… with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 128M innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is…’re looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… good performance innodb_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in this…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… affect how InnoDB works internally? Let me show some details. Internally, InnoDB uses two lists for flushing (writing pages from the Innodb buffer pool… flushing, because that defines what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… (dirty) buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must…, we have dirty buffers. These two numbers are relevant from the BUFFER POOL AND MEMORY section of SHOW ENGINE INNODB STATUS: Database pages… the Innodb plugin this was really the only way to tune dirty buffer flushing. However, I have seen servers with 3% dirty buffers and…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… you’re optimizing for throughput in this scenario, you will tune innodb_concurrency_tickets to the 99th percentile of small PK lookups… innodb_log_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…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being unflushed you… Buffer pool hit rate 999 / 1000 This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb… your active database size is smaller than allocated buffer pool size so you can tune it down. Even if free pages is…
