… databases up properly either. For per-table restores, we use mysqldump + –single-transaction and > splice out what we need with… doing a mysqldump and splicing out what you need when maybe a critical table of data needs to be restored quickly and…
Post: L2 cache for MySQL
October 25, 2012 By 13 Comments
… I prefer to name it as L2cache. There is a quick benchmark on tpcc-mysql 2500W (250GB), I used data on…, which we need to resolve: Backup. In current state only mysqldump will work. To make backups with Percona XtraBackup we will…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… faster and result in less fragmented indexes. He also improved mysqldump so indexes are created with “fast index creation” when restoring… the backup is restored, the server will warm up very quickly. We merged new documentation into innobackupex, the Perl wrapper script…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 59 Comments
… Recovery using InnoDB? We use an internal process based on mysqldump and innodb file-per table. Our “Database File-Per-Table… authorized DBA. For failures on a MASTER, we do a quick shift and make one of the slaves the new master…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… had pretty good IO subsystem so we started number of mysqldump processes in parallel. Unlike in other case when we did… thread would rarely need to stall unable to perform any quick IO and unable to progress until scheduled read ahead can…
Comment: Wishes for mysqldump
May 23, 2007 By 19 Comments
I wrote a quick and dirty wrapper in python that launches many threads with mysqldump. Each thread stores the result in memory…
