… your main 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 for…
Comment: 5.0.75-build12 Percona binaries
January 25, 2009 By 18 Comments
Peter, innodb_ibuf_max_size=0 never inserts to insert buffer. So, it is equal … innodb_ibuf_max_size=0. If you don’t like insert buffer growing, I recommend innodb_ibuf_max_size=[several MB] and innodb_ibuf_active_contract=1 instead. And, Currently, innodb…
Comment: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
Peter, innodb_ibuf_max_size=0 does not disable insert buffer activity, there still will be operation to perform merge operations, and innodb_ibuf_max_size=0 can make it bad. Probably better to use innodb_ibuf_max_size=1M. Other options will comment Yasufumi.
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… show better performance. 0:disable, 1:enable * innodb_ibuf_max_size (default [the half of innodb_buffer_pool_size](bytes)) – This parameter is startup parameter. If…, only innodb_io_capacity is insufficient to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… InnoDB manages transactions in correct order most users may not have problem with this. New parameters in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling it makes the each…
Comment: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
Vadim, Will making innodb_ibuf_max_size=0 stop using insert buffer at all ? Is it possible … explain what exactly innodb_ibuf_accel_rate is because “this is additional tuning variable” is not very clear. Same about innodb_ibuf_active_contract…
Comment: 5.0.75-build12 Percona binaries
January 28, 2011 By 18 Comments
is innodb_ibuf_max_size allocated inside innodb_buffer_pool_size or not? I believe it’s inside otherwise we need to leave 50% of buffer pool size memory just for the insert buffer.
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… between these values will also grow and innodb_max_purge_lag will become your friend. “undo n… Ibuf for space 0: size 1, free list len 887, seg size 889, is not empty Ibuf for space 0: size…if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size …
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…the storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_method = O_DIRECT …”Ibuf: size” (like > 1000) may tend to losing the performance. If you have powerful IO system, you might set bigger values. innodb_ibuf_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb…join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-…
