… 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…@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
… 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…
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… 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
… 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…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and… –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=10…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and… –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval=10…
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… + 2382090360) Page hash 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560)…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… 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…
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 …
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.
