… need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file and restart the server. If you do, InnoDB…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…to 128 for good measure. Since there are two log files by default, divide that in half, and now you can set innodb_log_file_size…calculation, I end up finding that the log file size needs to be a lot smaller than it’s configured to…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… to keep the number of dirty pages within the given innodb_max_dirty_pages_pct limit. Another possible solution would be to increase innodb_log_file_size… makes calculating how many pages we need to flush extremely hard (read “impossible”), and this is one of the reasons why innodb_adaptive_flushing…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file… in the error log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm files exist but… a query is going to be possible to improve a lot, and a simple mental calculation can then tell me how much total gain…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log…calculated. As it is seen from the chart above the performance almost doesn’t depend on logging…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer_size…to separate tablespace related IO from log related IO so you can see how much IO your log file requires. Note depending on your innodb_flush_log…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb_log_files…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 38 Comments
@sedat: If you change innodb_log_size, you’ll have to remove the old log files manually so MySQL can create new ones. See also http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/comment-page-1/#comment-390952 Best regards, Jochen
