… directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup…. Example of how this information can be used to create/restore a slave can be found in this blogpost. Percona XtraBackup… non-relevant tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed #1130145. Due to different…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… directory during the backup stage. During the copy back stage (restore) it is copied back to data directory. After the backup…. Example of how this information can be used to create/restore a slave can be found in this blogpost. Percona XtraBackup… non-relevant tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed #1130145. Percona XtraBackup didn…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…> SHOW PROFILE; +——————————+———–+ | Status | Duration | +——————————+———–+ . . . | copy to tmp table | 18.396514 | | restoring secondary keys | 52.567644 | . . . +——————————+———–+ 19 rows in set (0.00… index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading an indexed table… with a separate ALTER TABLE after restoring the data from a dump would actually make the restore slower; mysqldump –innodb-optimize-keys…
Comment: MySQL Backup tools used by Percona Remote DBA for MySQL
March 17, 2013 By 8 Comments
… take a long time to load. Some factors that affect speed of restore include innodb_log_file_size, innodb_buffer_pool_size… drives it may not speed things up nearly as much. I recommend testing restores using different number of restore threads and measure time taken. Compare this to the time taken to doing a binary restore…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… options) resulting in 260MB compressed file. This gives us compression speed of about 21MB/sec – clearly much less than even single… is faster local network transfer default GZIP compression will not speed things up on the standard point to point 1Gbit network… gives 105MB/sec read speed from archive media and 276MB/sec write speed to the hard drive – this means restoring from backup compressed…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay…-buffer-pool-restore (in 5.1 it is –innodb-blocking-lru-restore), which is OFF by default. When set to ON, restoring from… boolean option, –innodb-blocking-lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump file is…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay… boolean option, –innodb-blocking-lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump file is… boolean option, –innodb-blocking-lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump file is…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… PDO but would not > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly… queries. It is also much easier to do backup > and restore if you need only portion of your data recovered. While… it’s time to do a full data restore, more tables means longer restore times. Deciding to create a new table for…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… are created with “fast index creation” when restoring a dump, which can potentially speed up restores greatly. Laurynas worked on ensuring that Percona… file from Percona Server, so that after the backup is restored, the server will warm up very quickly. We merged new…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
…, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup) In this is… in http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/ tree. The patch by itself is quite small, I… it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your comments about patch is welcome…
