…, I don’t see the innodb fast recovery patch in this release? Why? I “backported” the xtradb fast recovery patch to 5.0.82 and it is compiling/working fine, but recovery is not that fast in some cases: 100GB InnoDB data, 24GB buffer pool, 3x256M logs on SSD is taking 40 minutes to recover, worst case scenario, fast recovery enabled. I…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…as logical operation of opening file is rather fast on local file system – one can open/close…InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB: Doing recovery…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… cases – in most cases using Innodb for tables which you need to be recovered fast is better solution. Innodb Recovery – Unless you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… of the shared tablespace ibdata. That is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server… the use of –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert… the next blog post I’ll explain how to do recovery using Percona Data Recovery toolkit.
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24… of features I would like to see soon: Fast recovery. Both recovery after crash and recovery from backup can take unacceptable long time, especially… asked what are our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB…
Post: A few administrative updates
August 26, 2009 By 12 Comments
… : innodb fast recovery patch. Reason: Innodb recovery has always been a big headache for any DBA since it used to take ages to complete a recovery after crash. Now with the patch I am able to do a recovery in less than a…
Post: Recovery after DROP [ TABLE | DATABASE ]
July 19, 2009 By 4 Comments
In your recovery practice we often face the problem when data lost by … case even our InnoDB Data Recovery tool can’t help, as table / directory with files was deleted (if you have innodb-file-per… there are two utilities which can help of you are fast (and lucky) enough. First one is ext3grep http://code.google…
Comment: 5.0.84-build18 Percona binaries
August 24, 2009 By 4 Comments
… ok. It runs with the same my.cnf except innodb_fast_recovery=true. The recovery time on a hw failure was with 5.0…) The DB has: 500 Tablespace 2x256K ib_logfile 20 GB innodb_buffer_pool_size on dual quad core intel E5345 32…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… XtraDB release 7. This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase…_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1.35 crashes with… enqueued for flush again when innodb_flush_neighbours=0†Bug #395783 in Percona-XtraDB: “main.innodb_bug42101 fails on 5.1…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… just need to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools as Innodb Hot… have any long running queries. If you’re using only Innodb tables and do not need to synchronize binary log position…
