…:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files…. Neither IO alignment nor file size made any difference. Adding LVM here reduced single-thread performance by 5-10%. Sequential write…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… about each of them briefly: InnoDB page You don’t need to do anything to align InnoDB pages – file system takes care… file system correctly). I would however mention couple things about InnoDB storage: first – in Percona Server you can now customize page… point. Let’s get down one more level: LVM If you are using LVM, you want to make sure it does not…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… that caused downtime for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes… problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… was a great workaround if you’re using only Innodb tables – Innodb when Innodb does crash recovery it would print position in master… only using Innodb tables of course) Another way this functionality was usable is cloning Slave->Slave by use of LVM without pausing… lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching your MyISAM system…
Comment: Global Transaction ID and other patches available!
May 15, 2009 By 9 Comments
We’ve been using innodb freeze for a while now but I think that in conjunction with LVM snapshots we’ve been avoiding any bugs with it… It’s redundant now though with LVM snapshots. We were using innodb freeze BEFORE we started using LVM to bypass a bug in xfs…
Comment: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… up InnoDB by simply copying its files?” Please could anyone confirm something what we’re doing is OK: LVM, XFS filesystem with InnoDB. We simply create an LVM snapshot and then do a file copy. Sure, it means that InnoDB has… question if anyone has any insight please: LVM snapshots have been indicated as severely affecting InnoDB performance – however someone on a thread…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… repositories i.e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile… before the first DELETE statement above. If you use my LVM snapshot script*, it also saves the binary log coordinates when… somehow blew up in flames, hardware problems or encounter and LVM bug, your snapshots are useless. Also, you cannot test restore…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
Coway, SysBench is specially implemented to emulate IO for MySQL/Innodb and so this is why I use it. Also what… just raw partition to LVM ? In this case LVM really adds very little overhead or did you compare LVM to LVM when SNAPSHOT for…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 24, 2012 By 20 Comments
… the case of mylvmbackup, the LVM snapshot implemented? Is it not atomic in itself, so that InnoDB file writes can happen while the snapshot it being made? If LVM snapshots are atomic, yet a FTWRL InnoDB snapshot can be inconsistent and unrecoverable sometimes, how is InnoDB ACID?
Comment: Disaster: LVM Performance in Snapshot Mode
February 8, 2009 By 55 Comments
… with LVM…. It can be DOG slow when a snapshot is live. We’ve avoided this problem by first doing an InnoDB… the snapshot and COW operations can happen internally as the InnoDB buffer pool allows our DB to avoid having to do… benefit of having the InnoDB buffer pool use the linux page cache. Transferring the snapshot from the LVM image would come from…
