… 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… /etc/my.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]#
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…
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 … edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… logfile 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…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… = innodb_data_file_path = ibdata1:10M: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…
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.
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL… + 2623331) File system 294352 (…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle… is: 3891 files changed, 473733 insertions(+), 210435 deletions(-) The size of the …file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 14 Comments
… 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 will…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In… installation. MySQL 5.5 increased the default buffer pool size to something more sane (128MB instead of 8MB), but the log file size remains at…
