… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have been…, but changes from which already made it to the database. Unlike “redo” phase “undo” phase can’t be reduced by sizing your log files…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…handling the XtraDB changed page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp …O and AIO routines if large innodb_log_block_size value is used in the combination with changed page tracking. Bug fixed #1114612 (Laurynas…
Comment: What to tune in MySQL Server after installation
January 30, 2009 By 118 Comments
Hi. I changed the parameter – innodb_log_file_size and many of mysql databases were giving lots of errors … the above 3, only civicrm_price_set_entity is an innodb table. The other 2 are myisam. Finally after a lot… how to change the parameter innodb_log_file_size but it looks like it’s not as easy as editing the my.cnf file and restarting…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again, you… the error log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm files exist but… rewritten. Indexes and data types and table structures can be changed. Queries can be broken into pieces, combined, or even eliminated…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
… most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and all changes to data are performed… about 7/8 of innodb_log_file_size, and the “async” point is at about 6/8 = 3/4 of innodb_log_file_size. So, there is one…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…. Innodb uses fuzzy checkpointing so this line hold log sequence, all changes up to which has been flushed from buffer pool. Changes having higher log… in 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 is…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
…innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb_flush_log…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 17 Comments
….0. And I can tell you that changing innodb_log_file_size does NOT work for good. Changed it to 32M yesterday for Zarafa MySQL tuning…:00 InnoDB: Log file ./ib_logfile0 did not exist: new to be created Nov 8 19:45:00 mysqld: InnoDB: Setting log file ./ib_logfile0 size to… a final note (my personal view on this topic): Never change innodb_log_file_size in a running production system with no backups at all…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… will use its own block size.. – Of course the things may change if “innodb_flush_log_at_trx_commit=1″…size=26G innodb_data_file_path=ibdata1:10M:autoextend 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…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… LRU list, then innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size do not matter, and changing these settings won’t… less than 3/4 of innodb_log_file_size * innodb_log_files_in_group. If you have these conditions and observe intensive writes, InnoDB is using LRU list…
