… ## 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_… insert rate of ~25k INSERTs Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs …
Post: Some little known facts about Innodb Insert Buffer
January 13, 2009 By 11 Comments
… all buffer pool dirty pages are completed. This can be very surprising. Stats about Innodb Insert Merge Buffer are available in SHOW INNODB STATUS output: ————————————- INSERT BUFFER AND ADAPTIVE HASH INDEX ————————————- Ibuf: size 7545, free list len 3790, seg size 11336, 8075308 inserts…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… of insert buffer – segment size and free list as well as if there are any records is insert buffer. Next it shows how many inserts were done in insert buffer… of merges to number of inserts is pretty much insert buffer efficiency. Adaptive hash index is hash index Innodb builds for some pages to…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… Innodb Tablespace. Insert Buffer size is also restricted to half of the buffer pool size (can be changed via innodb_ibuf_max_size option) which can be significant size… looking at SHOW INNODB STATUS this is how you can see Insert Buffer Size: Ibuf: size 108931, free list len 64619, seg size 173551, In this…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…to most users? INSERT w/PRIMARY KEY defined: Number of rows inserted – 1 INSERT w/FOREIGN KEY constraint: Number of rows inserted – 1 …innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling it makes the each user threads positive to contract the insert buffer as possible in asynchronous innodb_ibuf…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but … size ought to be many gigabytes, well, you have a more active write workload. Perhaps you’re inserting …advice to size the logs as a fraction of the buffer pool size is just wrong. One final note: huge buffer …
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…innodb_buffer_pool_size=6G 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…
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… are up to date), number of unflushed pages in innodb buffer pool and its size as well as performance of IO subsystem. As… you can reduce “undo” phase is size your transactions appropriately – so updates/inserts/deletes can be sized to affect limited number of rows…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…bulk_insert_buffer_…innodb_buffer_pool_instancesblogpercona.commanual Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages_dirtyblogpercona.commanual Innodb_buffer_pool_pages_flushedblogpercona.commanual Innodb_buffer_pool_pages_freeblogpercona.commanual Innodb_buffer…
