on http://www.innodb.com/products/hot-backup/features/, I read:
"High performance — backup time is comparable to file copy, applying
logs for recovery is even faster."
While I have an idea, what "comparable to file copy" means, namely about
the same time as copying a file from the file system where the backup
file is to the file system, where the tablespace is, I don't quite get,
what "applying logs for recovery is even faster" means.
If one applies logs for recovery, one reads the log file and applies the
contents to the tables. The latter takes place in a cache mainly. So the
equivalent for a file copy would mean to copy the log file to a memory
file system. Does InnoDB Hot Backup indeed apply the log faster than that?
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder HRB München 161028