…the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…the buffer pool, then worst case you could be reading the same page multiple times into the buffer pool. So considering…the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the…increase it a bit to be on the safe size and scale appropriately. The…MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size…
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
…the same LSN range scheduled for flush and Innodb might end up flushing most of buffer pool…size of allocated buffer pool size) this might never happen. This is very unusual case of increasing your buffer pool size… However the shared drive at shared MySQL … but we need to consider caching by OS …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…increase it to 70% ? It seems 70%Â is too big, and now we again hit the limit set by innodb_log_file_size. The…MySQL 5.5.8. But, finally, let me show the result IÂ got running Percona Server in optimized mode: innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=1 innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…InnoDB does the buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s flushes smoother and increase…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…At Percona, we consider it important not only to have the best peak …the results for tpcc-mysql, 500w (around 50GB of data) on RAID10. I used innodb_buffer_pool_size=24G, innodb_log_file_size=2000M (innodb…increasing log_size we added option innodb_log_block_size which allows to change IO block size…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…increasing number of rows being tested 20% per step. I’m trying standard Innodb page size, 4KB page size as 16K page size… 128M buffer pool. It could be compared to 4K pages case just with 1/4 of data (and the … on MySQL 5.5 As a summary: If you have very random access pattern with small rows consider…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…consider it’s self busy very easily. Keeping a large percentage of pages dirty increases…the rest of the information shown). In addition to this, XtraDB diagnostics include the ability to see the contents of the buffer pool (see docs), and InnoDB…
