…: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…. New features include: Backup and 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 from backup to give excellent performance without a lengthy “warm…=2′ will create 4 IO threads that will read the data and pipe it to 2 compression threads. New streaming format…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… copying, it was required to uncompress the entire backup to restore a single table). Percona XtraBackup now supports streaming incremental backups… done by the xtrabackup binary which calculated deltas by scanning data files. Which meant those two feature were mutually exclusive, i…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… recovery as on ability to restore data from backup which can be far from being enough to restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore process you better look at the whole process which is required to bring system to the working state, including data…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
…/docs/wiki/percona-xtradb:patch:innodb_lru_dump_restore (Yasufumi names it LRU dump/restore, because he thinks about buffer pool as… /*!XTRA_LRU_DUMP*/; and to restore select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_RESTORE*/; it will create/read file ib… buffer_pool, restarted mysqld, restored buffer_pool ( it took about 4 min to load 26GB worth of data), and run (xtradb warm…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… it will be quick to rearrange their database or even restore from backup. You need Patience simply because things are going…, Batch Jobs can take quite similar time. Binary Backup and restore will be faster but it can still take hours especially… as results you’ve gotten for small data set may not apply to large data set so you need to re-test…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… will give you a walk through guide on how to restore your data after physical or logical failure, using practical examples to… for recovery (prerequisites) * Preparing your data * Identifying the structure and state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… February 10, We will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent… like InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets, and how to… safely using Tungsten Replicator with parallel apply. Bring your big data questions to this live webcast as we tour the cutting…
Comment: xtrabackup-0.5, bugfixes, incremental backup introduction
April 9, 2009 By 6 Comments
Leon, To restore data you can copy backup to final /data directory directly and run innobackupex –apply-log /data it should execute prepare and…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… scan queries. Full table scan queries allow to preload table data ether in storage engine caches or in OS cache. You… I wanted to point out it separately. To warmup this data you might run select 1 from _table_ limit 1 for… problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should…
