…. Find out number of KB being written to the given LVM volume per second. Now keep in account Innodb double write buffer… anyway. However DO place Innodb Log Files on the same LVM volume as you need them to be snapshoted at the same… recreation etc are also possible trouble makers. Third,Use dedicated LVM volume for MySQL Instance. This is good idea for many reason and…
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
… our customers was setting up box for MySQL LVM backups. The box had 2 RAID volumes (internal drives and enclosure) with database being… space available on the volume…. The problem was internal and external volumes were configured as different “volume groups”. Volume groups in LVM live completely isolated…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so … way you probably will be unable to mount it, find LVM volumes on it etc, and you can go back and correct… Read ahead sectors 0 So we have RAID volume back but LVM shows this volume as NOT available and so it can’t…
Comment: LVM Configuration mistake to Avoid
July 11, 2008 By 10 Comments
… create temporary volume to consume all space on slow physical volume. Add fast physical volume to the same volume group. Create your MySQL LVM Volume on it. Now drop the temporary “space consumer” you had on the slow volume…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we… layers (MySQL, Operation System, Hardware) when for example row is being inserted into Innodb table on Linux stored on LVM volume over RAID10…
Post: MySQL Performance Blog gets new server.
October 26, 2007 By 4 Comments
… partitioning – I really prefer to keep all important data on LVM volume so it is easy to backup.
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… atomic snapshot of the volume, which can be later mounted same as original file system Why snapshot based MySQL backups are great… able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there… to provide you with volume which consistently matches state of the volume at the time storage is created. In LVM it is implementeed…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… point. Let’s get down one more level: LVM If you are using LVM, you want to make sure it does not… pvcreate it is also a good idea to use appropriate Volume Group Physical Extent Size for vgcreate – I think default 4MB… format it with mkfs directly or add it as an LVM physical volume. This let’s you avoid any mistakes when working…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add…’s performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to… the technical level. These include EBS volume snapshots, for example. They work much better than LVM snapshots, in terms of impact to…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… – 10 volumes. And of course to get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small problem with backup over EBS. On single EBS volume you can just do snapshot, but on several volumes it may be tricky. But in this case you may consider LVM…
