… restore of LRU 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
…). First run (xtradb cold) I made just after restart and ran it for 1h. After that 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: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… when crash recovery (disabled by default) Patch to dump and restore innodb_buffer_pool Fixed bugs: Bug#488315: rename columns and add unique…-server-percona MySQL-client-percona The latest source code of XtraDB, including development branch you can find on LaunchPAD. Please report…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… easily spotted by converting tables to Innodb on restored backup. Full text search indexes, GIS, multi-column …do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be …check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are …
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
….4 milestone at Launchpad. Improvements SHM Buffer Pool has been replaced with LRU Dump/Restore The ”SHM” buffer pool patch, which provided the ability to… handling inbuf_page_get_zip(). Bug Fix: #802348 (Y. Kinoshita). XtraDB crashed when importing big tables (e.g. 350G) using the…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here and for setting up LRU dump/restore… option ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server will not start and print the corresponding error…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…, especially if you crashed with full 32GB buffer_pool. There is reported bug http://bugs.mysql…. server to different or (basically the same) restore single table from backup, possibly on different …was asked what are our current plans about XtraDB with recent InnoDB-pluging release, as performance…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…bytes on disk The problem is that after restoring table from mysqldump, the query that scans …query significantly, especially when data is not in buffer_pool and execution goes to read from disk …really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… for production environments. This feature limits the age of idle |XtraDB| transactions. If a transaction is idle for more seconds than…-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking-lru-restore), which is OFF by default. When set to ON, restoring from the… boolean option, –innodb-blocking-lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump file is…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
…takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup) …with 16 running threads. MySQL params are: innodb_buffer_pool_size=16G innodb_log_files_in_group=…it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your …
