… it is quite typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the… general logs anyway. However DO place Innodb Log Files on the same LVM volume as you need them to be snapshoted at… doing it “once” to migrate to the server with proper LVM configuration with no downtime as it is too fragile for every…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… do anything to align InnoDB pages – file system takes care of it (assuming you configure the file system correctly). I would however mention… Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1 and sda3 do not even align to 1k. sda2… want to know that when setting parameters for file system but when RAID is configured, there’s nothing more you can do…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…. After I got (what I thought was) the best configuration, I added LVM on top of that and the performance improved another… to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after…. The pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain … The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…based block-map technologies of the log structured file systems (WAFL, ZFS). With log structured filesystems … compared it with xfs. The difference with LVM snapshot is big. “randomio” opens its target … cache in the controller in RAID1+0 configuration. First the raw numbers – 100 threads, 20% writes…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… outliers and anomalies in every aspect of the server’s configuration and performance and contents. I’m looking for characteristics that…. The last three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this point, unless… ‘file‘ command) whether /usr/libexec/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…is to re-create RAID array in the same configuration as it was initially created, making the drive you…sectors 0 So we have RAID volume back but LVM shows this volume as NOT available and so …potentially corrupted. This is why I prefer to know files affected by bad blocks on the first place. ReadyNAS1…
Post: fsyncs on software raid on FusionIO
March 23, 2010 By 6 Comments
…. So for Linux we have software RAID and LVM, I tried to followup on my post How… test I used in previous post on next configurations: Single card RAID0 over two cards RAID1 over …–test=fileio –file-num=1 –file-total-size=50G –file-fsync-all=on –file-test-mode=seqrewr –max-time=100 –file-block-…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… , Following this blog we arrived at the conclusion to use lvm snapshots on the slave servers to prevent slaves from being… some of these slaves run on LVM‘s which have already occupied most of the file system space in that particular volume… ?? can we also directly mount snapshot as read only and configure mysql to use it , will that work ? and will that…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…they must be executed on db2 so better use mysql file socket, or real IP of the node, but not …t use mmm_clone i.e. you don’t have lvm or another way to create snapshots, this could be …if you’re using MMM, I suppose this is already configured. Pretty much the same can be achieved with master-master…
