… of innodb_log_file_size > 4G. This test was done using Percona Server 5.5.7, but the same performance expected for InnoDB-plugin…: for 52GB innodb_buffer_pool_size: 101220 21:54:31 InnoDB: Database was not shut down normally! .. 101220 22:02:40 InnoDB: Rollback… for 144GB innodb_buffer_pool_size: 101220 22:45:37 InnoDB: Database was not shut down normally! .. 101220 22:55:00 InnoDB: Rollback…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…=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_adaptive_checkpoint=keep_average innodb…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size… = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 92684288 xtrabackup: Starting InnoDB instance…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory for… using solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin fashion. I… first file in a log file group. My questions are: What is always being written to the first file in the log file group? HT: InnoDB writes…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb needs to… logs are of reasonable size and wikipedia has 40 minutes or so with innodb_log_file_size=256MB. In other cases I know same log file…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
… theory. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and… between 0 and innodb_log_file_size. Point 0 means there are no modified pages. Checkpoint_age can’t grow past innodb_log_file_size, as… 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…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Doing recovery: scanned up to log sequence number 12682768136… files and applying logs took about 9 minutes in this setup. This number of course can change a lot depending on hardware log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the redo logs… the redo log What is not obvious from the documentation is that while Innodb_os_log_written is incremented when the log file is written, the LSN is incremented when the log buffer is written…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… is less than innodb_max_dirty_pages_pct and checkpoint age is 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… 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… was really puzzled, looking for answers in MySQL status counters, innodb status, memory info and what not. It seemed that the…, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log…
