… InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB…]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 …
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… so that we can see the impact of growth in data-set on the insert rate. We can see that adding…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
….cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I… recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult… was: I could only use mysqldump to import all the data into a clean/fresh innodb system! Good luck! Thomas
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb innodb_data_home_dir = 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…
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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
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 … Com_stmt_send_long_data to see whenever sending long data feature is used… 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
…include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ plugin Log output to …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
… hour or so of logs. That’s generally plenty of data for InnoDB to work with; an hour’s worth is more… 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…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it… ? (smaller log records mean more records for same sized logs), how random were data modifications (random updates will need random IO to…
