….00 sec) Now let’s see how performance is affected when turning …to the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb_buffer_pool_sizeset to…innodb-optimize-keys ignores foreign keys because InnoDB requires a full table rebuild on foreign key changes…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes…to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For this, you need to find a way to tell Linux to…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…innodb logfiles. We can see that innodb_buffer_pool_instances=8 makes a big difference on small buffer_pool sizes, while on bigger buffer_pool, innodb_buffer_pool…
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 compared to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file_size=400M # Approx 20% of buffer pool innodb_thread_concurrency=64 # Default is 8 wich is a way to…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… as database which is less than innodb_buffer_pool_size) You will have all buffer pool busy sooner or later. How to figure out if it is… amount of queries increased dramatically or may be because queries changed their plans. Do the sizing This especially works well in… innodb_buffer_pool_size (while having innodb_flush_method=O_DIRECT) and see how performance depends on buffer size so you get and understanding what Memory-To…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… double write buffer to ensure consistent page writes. Why log? Since InnoDB tries to keep the working set in memory (InnoDB Buffer Pool), therefore the changes made by… was processed so the change does not need to be applied. How does this affect response time? In order to keep ACID compliance, the…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…InnoDB works internally? Let me show some details. Internally, InnoDB uses two lists for flushing (writing pages from the Innodb buffer pool memory to…innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size do not matter, and changing…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… really need to think how large it can get. We’re already seeing half a TB innodb_buffer_pool size and I expect it to close… pages in buffer pool to be getting close to 100 millions of entries. So as result of this bug – if you’re running innodb_file… design or use innodb_file_per_table=0 for such tables (thankfully you can change this variable online in Innodb Plugin, MySQL 5…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… of dirty pages in innodb buffer pool which had to be flushed before recycling. First ran however was done with clean buffer pool (after reading all… workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384 I got about same…
