Congratulations to Monty Program and the many community contributors for releasing the GA version of MariaDB 5.3. We were in… great improvements Oracle has made to the MySQL 5.5 release. This should help MariaDB be faster and more scalable, as…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here pretty…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…INNODB STATUS and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560; in additional pool… should be and I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
… released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool… of buffer pool ? There are several reasons. First, it’s not rate on modern servers to have 32GB+ of RAM, with allocated InnoDB buffer_pool…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…, improving buffer pool usage (currently you may need to both store Compressed and Uncompressed versions of the page in the buffer pool in many… did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5… released so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches to make Innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… 64 page extent becomes totally empty, and also it can release individual pages from its 32 ‘fragment extent’ pages. PZ: This…: INNODB uses it’s own internal buffer pool but it’s in conflict with the Linux kernel’s buffer pool. In high load situations where INNODB… system tablespace when an InnoDB instance is created. PZ: Sequential “dump” of buffer pool would need more optimizations to work – Innodb would also need…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… details of the release can be found in the 5.5.13-20.4 milestone at Launchpad. Improvements SHM Buffer Pool has been… for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is released… cores. documentation Buffer pool fixes Improvements of buffer_pool scalability. documentation innodb_buffer_pool_pages Information about content of buffer_pool pages. …
Post: Returning to InnoDB scalability
July 28, 2006 By 42 Comments
… is with “buffer pool” mutex, which protects innodb_buffer_pool. In details, for each scanned row InnoDB calls block_get / block_release functions which aquire/release the block related to the current row. And the problem functions block_get / block_release use mutex_lock(buffer_pool_mutex) / mutex_unlock(buffer_pool…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
…) ( in release process ) Usability / operations Show content of buffer_pool Import / export of dedicated tables Import / export of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io…
Comment: Percona Server 5.5.16-22.0
October 17, 2011 By 2 Comments
…-buffer-pool-restore (to be consistent with innodb-buffer-pool-restore-at-startup).” Just checked 5.5.16 on our test machine with the innodb-blocking-buffer-pool-restore directive: mysqld: 111017 10:13:12 InnoDB: Restoring buffer pool pages from ib_lru_dump So I guess the release notes…
