…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…
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…MySQL 5.5…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL… 1…File…
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…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…mysql> show engine innodb status\G select sleep(60); show engine innodb status\G Log sequence number 84 3836410803 1 row in set (0.06 sec) 1…innodb_log_file_size=64M Does that look surprisingly small? It might. I commonly see log file sizes…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=1 innodb_log_file_size = 8000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=…innodb_buffer_pool_size=26G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…log files. For this run, I used innodb_log_file_size=4G (innodb_log_files_in_group=2) for Percona Server. That gave 8GB in total size for log files (MySQL 5.5…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M (innodb_log_files…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…file descriptor numbers of the log files: # lsof -p $(pidof mysqld) | grep ib_log mysqld 29772 mysql 8uW REG 8,2 268435456 7143989 /var/lib/mysql…1 22016 2 24064 1 40960 1 So, in sum, we see that about 3/4ths of InnoDB log file…
