… test as our concern is general IO performance in this case – it is not something MySQL related. I tested things on RHEL5… The performance without LVM snapshot was 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the performance was 25 io/sec which is about 6 times lower ! I honestly do not understand what LVM could…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot…our question of space requirements for MySQL Backups using LVM. As you can see from …snapshot but not your data, so it is pretty safe. Though of course you should consider performance…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots…The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file…several others that can be performed with existing plugins, so …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This… include EBS volume snapshots, for example. They work much better than LVM snapshots, in terms of impact to the system’s performance and ability…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the… forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… helpful in other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and… stall if this lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this …there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first …Analyzing MySQL‘s workload and data After I’m done with that, I’ll grab a few snapshots of…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… recovery time or further degraded performance. In the large databases I run in production relaying on MySQL Replication for HA I often… a DRBD LVM snapshot. Works on a Secondary node too. I’m not sure Florian understood what was meant here. With MySQL Master… of paying extra performance costs. It is worth to note DRBD also allows building very nice mixed environments with MySQL – for example…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large … affect web site performance dramatically. Sometimes instead of using slave you may use database version from the backup or LVM snapshot of current…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there…. The other benefit of read-write snapshot is you can actually start MySQL Server on it and perform recovery, check tables or do…
