Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 120502 11:51:16 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite… x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you are going to delete the log files later (or even…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 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_adaptive_flushing_method = estimate innodb_flush_log_at_trx…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service mysqld stop Then…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… system log sequence number 6087296438643. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb…
Comment: How to calculate a good InnoDB log file size
April 24, 2012 By 33 Comments
What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
… tips. BUT: Please add a big warning that just changing “innodb_log_file_size” is not enough (see other comments for more info…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…:22 InnoDB: Starting an apply batch of log records to the database… … InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 15906301, file name ../log… binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062 Relay_Log_File: relaylog.000181 That does not match. So what…
