… during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select… query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
Post: Some little known facts about Innodb Insert Buffer
January 13, 2009 By 12 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 2 Comments
… 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 5 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 38 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…
