…the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 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… you can increase it a bit to be on the safe size and scale appropriately. The third …will get into complex balancing game besides considering all…
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 …only size of allocated buffer pool size) this might never happen. This is very unusual case of increasing your buffer pool size… requests ? Probbably but we need to consider caching by OS as well as disk…
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…considering buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB…
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…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…increase buffer pool size. Some threads which would be safely sleeping waiting on IO completion are now finding their data in buffer pool… locking. Consider for example bunch of transactions updating single row in the table… and not because of internal Innodb limits but because your application …
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… wrong) 2.Disk size increased so much that 1.000.000 MB are not that uncommon 3.Memory size on a server. even…) Also the buffer_pool_size, 128MB = 12.5% of the average minimum(!) server memory size, it is really the minimum it should be considering that: (1) InnoDB is now…
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…the result IÂ got running Percona Server in optimized mode: innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=1 innodb_log_file_size = 8000M innodb_log_files_in_group = 2 innodb…
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…increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases…
