…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_adaptive_flushing_method = estimate innodb…write performance, so I went ahead to choose a table structure with no secondary indexes…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
….cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set… are not going to choose 64M or more (but e.g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… to calculate the cost of MRR when the optimizer is choosing the query execution plan, is not sufficiently tuned and it…, 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… purpose of benchmarking IO bound workload, the InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up, so that it…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper 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…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… write working set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should note for most application… (of which Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of the rest (9 GB) is… wrote the post on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
Peter wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the… common advice to size the logs as a fraction of the buffer pool size is just wrong. One final note: huge buffer pools or really unusual workloads may require bigger (or smaller!) log sizes. This…
Comment: Choosing innodb_buffer_pool_size
November 27, 2007 By 38 Comments
[...] This is the cached version of http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/ We are neither affiliated with the authors of this page nor responsible for its content. Choosing innodb_buffer_pool_size [...]
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting… happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find… are up to date), number of unflushed pages in innodb buffer pool and its size as well as performance of IO subsystem. As there…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
… the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In general, there are … default buffer pool size to something more sane (128MB instead of 8MB), but the log file size remains at…size into the comments. By the way, if you’re looking to choose a good log file size…
Comment: Choosing innodb_buffer_pool_size
April 19, 2009 By 38 Comments
[...] UPDATE 关于它具体的查看http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/ innodb_log_file_size [...]
