… you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA can be optimized better and a bit faster because of easier parsing. Mysqldump however takes… to speed up load to tables with unique keys. So as you can see there are many variables which affect load speed which…
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 statements… foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key constrains…’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables…
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 statements… foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key constrains…’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
…. He also improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which can potentially speed up restores greatly… that after the backup is restored, the server will warm up very quickly. We merged new documentation into innobackupex, the Perl wrapper script around xtrabackup. We cleaned this up, moved it to the POD (embedded perldoc), and we will…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… creation for all of the above cases, which can potentially speed them up greatly. This feature is controlled by the expand_fast… (0.01 sec) mysqldump Quoting the fast index creation chapter in the MySQL manual: “… you can generally speed the overall process of… the table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as… is faster local network transfer default GZIP compression will not speed things up on the standard point to point 1Gbit network connection… using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression make sense…
