…: ## 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…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… 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… [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]#
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 … recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult… 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…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…: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_trx_commit = 1 innodb_lock_wait_timeout…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet… simple script: while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related… intrusive. Run SHOW ENGINE INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… 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 to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
… 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… 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…
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… 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… are up to date), number of unflushed pages in innodb buffer pool and its size as well as performance of IO subsystem. As…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
… 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….5 increased the default buffer pool size to something more sane (128MB instead of 8MB), but the log file size remains at 5MB. That… a default log file size into the comments. By the way, if you’re looking to choose a good log file size for your…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… in log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being unflushed you may want to increase it. You also can see number of pending normal log writes and…
