…to speed up load to tables with unique keys. So as you can see there are many variables which affect load speed which makes it extremely hard to…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed…speed which is good enough to compress all data… how…mysqldump backup typically tools with better and slower compression make sense because it takes longer to dump and much longer to load to…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysqldump Quoting the fast index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading…data is loaded.” mysqldump in Percona Server supports the new option –innodb-optimize-keys which does just that, i.e. it tries to…
