… 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….cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
Hi Chris, try this: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on ….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… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…: ## 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_commit = 2 innodb…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… size in a 5.0.95 MySQL database running on RHEL 5. I 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 rename…
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_lock_wait…
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)! Since…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable …true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check… Page hash 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… XtraBackup included IPv6 data type ZeroMQ plugin Log output to syslog is enabled by default… JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7…. stable release is: 3891 files changed, 473733 insertions(+), 210435 deletions(-) The size of the Drizzle kernel …
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
… wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post actually…. Since there are two log files by default, divide that in half, and now you can set innodb_log_file_size=64M Does that look surprisingly small? It might. I commonly see log file sizes in the gigabyte ranges…
