… features include: Backup and restore of LRU dump. For servers that support dump and restore of the XtraDB buffer pool … compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… while performing a backup when given the –galera-info option to innobackupex. XtraBackup now supports compressed backups…. As part of the backup, the LRU dump is now included as well. Support for… the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… compression performance is usually not the problem (though backup impact on server performance may…leap in compressed file size. Though in this example we used MySQL binary …compression make sense because it takes longer to dump and much longer to load to the database anyway so overral compression…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…slave_compressed_…binlog_dump_…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…tool kit which helps improve the performance of queries against a MySQL database by distributing the work … with the MyISAM storage engine, then I dumped the data to tab delimited flat files using… was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… degraded the performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi…recommend using the much safer LRU Dump/Restore patch, which provides similar improvements in restart performance and has the advantage of persisting…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
…from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona …recommend using the LRU Dump/Restore patch which provides similar improvements in restart performance. Replacement is …LRU dump/restore can be found here. Bug Fixes On a high concurrency environment with compressed…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… Also, a gzip compression potentially compresses the database more than just prefix compression. The downside in …an InnoDB instance is created. PZ: Sequential “dump” of buffer pool would need more optimizations …out you can get better performance by using couple of MySQL Servers on single node. You…
Post: Living with backups
November 6, 2008 By 28 Comments
… some nightly batch job that just dumps all MySQL tables into a text file or ordinarily…compressed archive. For example: /root/backup-tools/tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql… still chances for performance problems to happen on the working instance of MySQL. Such danger may…
Comment: Living with backups
November 18, 2008 By 28 Comments
…backups while performing server upgrades… My new backup slave performs the whole backup (~60GB uncompressed dump, though using on-the-fly compression with Gzip…the default) gives the best performance in all tested kernels – side read operation are fast and MySQL starts lagging slightly. – Using CFQ…
