… databases of decent size. Two important compression questions you need to decide for backup is where to do compression (on the source or… LZO default compression file compressed in 10.5 seconds and resulted in 390MB compressed file, this gives us 97MB/sec compression speed which is… backups. I should also note for mysqldump backup typically tools with better and slower compression make sense because it takes longer to…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly… Innodb for) – for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock…, so it’s important to make this operation as painless as possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…demonstrate the power of Shard-Query it is important to test complex queries involving joins and aggregation…the data to tab delimited flat files using mysqldump. I started by loading the raw data from… was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test …
Post: Living with backups
November 6, 2008 By 28 Comments
…seem by my last sentence, but it is not important right now. Either way the data is out …heavy queries against each table in the database when mysqldump is used or reading a lot of data when…that you can immediately, on the fly, create a compressed archive. For example: /root/backup-tools/tar –read-…
Comment: Wishes for mysqldump
May 24, 2007 By 19 Comments
… version of mysqlpdump whith some important improvements: * Store dumps to files directly instead to stdout * Can compress files * Dump each table in its own file * Can pass parameters directly to mysqldump http://www.fr3nd.net…
