… 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… good is read speed from snapshot (in particular sequential file reads). If you’ve done some LVM performance tests yourself or will be…
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
… internal drives so LVM and backup has less backup on the running system. As the system was configured creating snapshot volume with…”. Volume groups in LVM live completely isolated life and you can’t use space from one volume group for snapshot for another….S That would be interested to benchmark one day how LVM performs in shapshot mode in case undo space is stored on…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is needed while… overhead, and there is no space requirements. Another issue with LVM snapshot it may convert pretty much sequential IO done while scanning… will only use snapshot but not your data, so it is pretty safe. Though of course you should consider performance overheads mentioned…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility – this is obvious one. May… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there…) Remove snapshot: lvremove -f /dev/Main/dbbackup If you want to create slave based on such snapshot you need to perform couple of…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots that… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… and reduced mutex contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock… include EBS volume snapshots, for example. They work much better than LVM snapshots, in terms of impact to the system’s performance and ability…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… if the performance drops even more, if multiple snapshots are active at the same time? I wonder why the Linux LVM snapshot implementation performs so badly in comparison to ZFS snapshots (which…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? …three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this… with that, I’ll grab a few snapshots of SHOW FULL PROCESSLIST, and look for …
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…
