…used: ## 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…second, with noticeable spikes after every 100 million rows inserted. I noticed…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set to 128M, which does not 100… of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT… end result was: I could only use mysqldump to import all the data into a clean/fresh innodb system! Good luck! Thomas
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool…_custkey i_o_orderdate 4 NULL 232722 100.00 Using where; Rowid-ordered scan; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool…use Large Pages for allocating Innodb Buffer Pool and few other buffers…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
…100 / index_size, 2) fit_pct FROM (SELECT index_id, COUNT(*) cnt, SUM(dirty = 1) dirty, SUM(hashed = 1) hashed FROM innodb_buffer_pool…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… your write working set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I … “innodb_buffer_pool_size=20480Mâ€) while the bulk of the rest (9 GB) is used for the OS…on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…pool_size=16M innodb_buffer_pool_size=15G 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…100 Warehouses (about 9.5GB datasize). The result is: Here the result grows up to 16 connections, but after that InnoDB… use…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…max_connections” threshold (650) connections. Cpu is fine (about 100% of 400% available, MPM and dual core reports …innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
… Buffer Pool size affects Innodb Performance ? I always expected the effect to be positive, Innodb with large buffer pool to performing better. Including …hours with very little disk IO and one CPU 100% busy. I took oprofile to see what exactly … but by LSN this is why it is used only on recovery…
