… backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally Available) stable… undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5… similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup can use XtraDB changed page tracking feature to perform the…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
… thinks about buffer pool as about LRU list, which how it is internally). To save buffer pool you execute select * from information_schema.XTRADB_ADMIN… I saved buffer_pool, restarted mysqld, restored buffer_pool ( it took about 4 min to load 26GB worth of data), and run (xtradb warm) tpcc…
Post: How well do your tables fit in buffer pool
March 26, 2010 By 4 Comments
In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes … table we can see how well different tables fit in buffer pool. SELECT d.*, ROUND(100 * cnt * 16384 / ( data_length + index_length…, table_name, COUNT(*) cnt, SUM(dirty), SUM(hashed) FROM INNODB_BUFFER_POOL_PAGES_INDEX GROUP BY schema_name, table_name ORDER BY…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… will be ready soon. Main difference XtraDB-rel2 it contains additional scalability fixes for buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld…=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M… down. XtraDB and XtraDB-rel2 seem quite better, I guess this is mostly because fixes to rw_locks and to buffer_pool mutex (in…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… buffer_pool scalability. documentation innodb_buffer_pool_pages Information about content of buffer_pool pages. documentation Documentation is on http://www.percona.com/docs/wiki/percona-xtradb:start. Percona XtraDB…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… most time in buffer_pool mutex, contention here is not fully resolved yet in InnoDB-plugin. Now, let’s take XtraDB. In additional to multiple IO threads, we have patch to decrease contention on buffer_pool mutex, plus separate purge…_checkpoint algorithm. The results are: So I guess buffer_pool improvements play here for XtraDB, and looking on summary result: InnoDB 9439.316…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…). In addition to this, XtraDB diagnostics include the ability to see the contents of the buffer pool (see docs), and InnoDB row… end of a log file (see docs). Insert Buffer control – The insert buffer is a great feature of InnoDB that is not… size of your buffer pool, and when it does, it doesn’t try to aggressively free entries (a full buffer provides no use…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… innodb_buffer_pool_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M…_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… on the database nodes. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on…:21:17 InnoDB: Initializing buffer pool, size = 400.0M 120619 13:21:17 InnoDB: Completed initialization of buffer pool 120619 13:21:18 InnoDB…
