…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…
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 did not exist: new to be created InnoDB: Setting log file…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
… ‘show engine innodb status’, is shows there are 10 io threads(4 are read, 4 are write) and a log thread and a insert buffer thread .just like follows: ——– FILE I/O ——– I/O…: waiting for completed aio requests (write thread) but i found that the value of the innodb_thread_concurrency is 8. so, what…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… release, Drizzle 7.0. I plan to write a variety of blog posts on each … JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0…a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… to gather statistics about how the log file writes are distributed in terms of write size. InnoDB writes to the log files in multiples of 512 bytes. Mark… So, in sum, we see that about 3/4ths of InnoDB log file writes on this workload are 512 or 1024 bytes. (It might… writes are smaller than 4k. This server has innodb_flush_log_at_trx_commit set to 2. This means each transaction does a log file write…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…. Since 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… in it. If you’re writing huge entries to the log, fewer log entries will fit into a given log file size, which will generally…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
If you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting… 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…
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… of 8MB), but the log file size remains at 5MB. That’s 10MB total, because there are two logs by default. Is it…? Write your suggestion for a default log file size into the comments. By the way, if you’re looking to choose a good log file…
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_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to increase size of your Innodb log files to be able to use a lot of memory for write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes files in the log file group… the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How often or what is the pattern of these first log file writes…
