… dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored… your new slave will end up with a warmed up buffer pool to mimic that of the master. Streaming incremental backups. It…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 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 12 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: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
…tree. So basically we made: new split-buffer-mutex patch, which separate global buffer pool mutex into several small mutexes, and ported …, table compression – XtraDB will support moving tables between servers – XtraDB will be released with fast recovery patch – XtraDB has additional performance …
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
…-2 of our XtraDB storage engine. Here is a list of enhancements: split-buffer_pool_mutex The patch splits global InnoDB buffer_pool mutex into several and eliminates waitings on flush IO and mutex when there is no enough free buffers. It… get as bzr branch lp:percona-xtradb -r tag:release-1.0.2-2 percona-xtradb-1.0.2-2 as source…
