Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see:
This is problem when your InnoDB crashes, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup)
In this is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads.
MySQL params are:
So let’s take standard MySQL 5.4.1, it starts:
090706 15:39:47 InnoDB: Database was not shut down normally!
090706 16:51:56 [Note] libexec/mysqld: ready for connections.
So you see it takes 1h 12 mins to start.
In XtraDB we made some improvements, and it shows:
090706 17:04:11 InnoDB: Database was not shut down normally!
090706 18:10:53 [Note] libexec/mysqld: ready for connections.
1h 06mins. Better, but still not good.
So Yasufumi sat, scratched his head and made new patch for InnoDB. With this patch
090707 19:00:01 InnoDB: Database was not shut down normally!
090707 19:06:42 [Note] libexec/mysqld: ready for connections.
6 mins 41 secs. 10x improvement. Something to think about.
The patch is not in official XtraDB tree yet, it lives in
The patch by itself is quite small, I would ask InnoDB experts to review it:
So your comments about patch is welcome! If it is stable it will go to XtraDB and XtraBackup.