quick question – the xfs_freeze feature is really killer when one wants to do consistent snapshots/backup of database directories, etc. Is there anything similar in ext4 or is the benchmark of ext4 +lvm (which I know allows this) on par with xfs_freeze (without lvm) ?
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… results for other runs. So Creating LVM snapshot indeed could cause tremendous overhead – in the benchmarks I’ve done it is ranging… any system doing writes to experience the “performance shock” when LVM snapshot is created with greatly reduced capacity which when will…) So we’ll do some research around LVM and I hope to do more benchmarks – for example I’m very curios how…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see… used xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with next… may be tricky. But in this case you may consider LVM snapshots or XtraBackup
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I used… and performance without LVM was slightly better than with LVM as expected. I had to redo all of the benchmarks to get the… (not verified). 6. Added LVM on top of aligned partition table, used proper file system alignment. Benchmark results I had a hard…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… all this system. Originally I wanted to publish some nice benchmarks where InnoDB on SSD outperforms RAID 10, but recently I…. with barrier) I have 5250 writes / s, this is because LVM ignores write barriers (see http://dammit.lt/2008/11/03… is good ones – another are for research 4. XFS without LVM is putting barrier option which decreases write performance a lot
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
One of our customers was setting up box for MySQL LVM backups. The box had 2 RAID volumes (internal drives and… volumes were configured as different “volume groups”. Volume groups in LVM live completely isolated life and you can’t use space… side) P.S That would be interested to benchmark one day how LVM performs in shapshot mode in case undo space is…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
A while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes… on RDS may not be the most advanced available. My benchmarks generally showed that I was not able to outstrip RDS… EBS volume snapshots, for example. They work much better than LVM snapshots, in terms of impact to the system’s performance…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
In benchmarks passion (see my two previous posts) I managed to setup … post http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… on the process of alignment, if you’re curious about benchmark results, here they are. What is IO alignment I would… point. Let’s get down one more level: LVM If you are using LVM, you want to make sure it does not… the partition table. On the system that I have been benchmarking, defaults worked out just fine because I was using a…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… traditional filesystems use COW technology on various levels – volume manager (LVM, VXVM) or in the filesystem (VxFS). If you use LVM snapshots the choice of the filesystem can be quite important. I run “randomio” benchmark on ext3 filesystem and compared it with xfs. The difference with LVM snapshot is big. “randomio” opens…
