… 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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… binlogs off your primary server so you can perform point in time recovery. Store your binlogs … if not using myisam tables Built in compression Each table is dumped to a separate file. This …that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL I discuss S3 …
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… 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: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 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: 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: 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: Announcing Percona XtraBackup 2.0.1
June 25, 2012 By 1 Comment
…compressed backup, performing a compressed/uncompressed incremental backup would fail because xtrabackup_checkpoints was compressed. This has been fixed by omitting xtrabackup_checkpoints from compression… tar utility unconditionally when streaming ib_lru_dump and xtrabackup_galera_info. Which led to…
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 19 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…
