…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
…InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer…buffer pool size innodb…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is… relay logs, Innodb Transactional Logs also like to be cached otherwise OS will need to do reads to serve writes to these log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer_pool_write…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… read requests per a readahead. The InnoDB buffer is 256 page read requests for the aio read thread….buffer pool can buffer many writes to the same page, then fewer disk writes are needed. But if your write…this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…writing into Innodb updates buffer pool pages in memory and records page operations in the transaction (redo) log. Behind the scenes those updated (dirty) buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log… fixes to rw_locks and to buffer_pool mutex (in rel2). Conclusion: As read-only workload seems fine, read-write cases is something to worry…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… affect how InnoDB works internally? Let me show some details. Internally, InnoDB uses two lists for flushing (writing pages from the Innodb buffer pool memory to…, because that defines what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk, but…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… read-mostly cases when you still would like some redundancy RAID5 can work pretty well as well but beware of random writes… swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a… looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs…
