…: ## 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_flush_method = O_DIRECT innodb_max…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…/my.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 to… of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… 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]#
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, …ps.log ps aux | grep mysqld >> ps.log …Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) … memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers …
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_log_buffer_size = 8M innodb_flush_log_at…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…, 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… the common advice to size the logs as a fraction of the buffer pool size is just wrong. One final note: huge buffer pools or really unusual…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have been… are up to date), number of unflushed pages in innodb buffer pool and its size as well as performance of IO subsystem. As there…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… dirty pages in innodb buffer pool which had to be flushed before recycling. First ran however was done with clean buffer pool (after reading all… on hardware log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384 I…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… used 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=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb…
Post: How long is recovery from 8G innodb_log_file
December 22, 2010 By 11 Comments
… support of innodb_log_file_size > 4G. This test was done using Percona Server 5.5.7, but the same performance expected for InnoDB-plugin… 51sec for 144GB innodb_buffer_pool_size: 101220 22:45:37 InnoDB: Database was not shut down normally! .. 101220 22:55:00 InnoDB: Rollback of non…
