… with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table with modified… the duration of operation. You can also use Percona Xtrabackup, LVM or other database backup approach which does not relay on…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… completely unanticipated bug or performance bottleneck. This is exactly the case with LVM Number of customers have reported the LVM gives very high… performance without LVM snapshot was 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the performance… (in particular sequential file reads). If you’ve done some LVM performance tests yourself or will be repeating mine (parameters posted) please…
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….S That would be interested to benchmark one day how LVM performs in shapshot mode in case undo space is stored on…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… card with enabled write-cache (which is default and most performance mode) does not warranty storing all InnoDB transactions on permanent… can affect performance results significantly (I have no results on hands, but it is to be tested). What about LVM there ? Well… is good ones – another are for research 4. XFS without LVM is putting barrier option which decreases write performance a lot
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… being remapped it is read from the undo location. The LVM Snapshots versioning is however different from database Multi Versioning because… should consider performance overheads mentioned in such operation. Actually exactly this configuration could be lifesaver if you have system with LVM setup…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility… snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there are different implementations… database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… 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
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want…. The last three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this point, unless…. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… you have, the higher probability that one of them will perform unpredictably, and you are essentially bound by the weakest link… and reduced mutex contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock…. They work much better than LVM snapshots, in terms of impact to the system’s performance and ability to mount them on…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… the case. There are whole classes of systems where Disk performance is not that important – consider for example systems where most… you have to consider a lot of topics – security, manageability, performance. I tend to advice different things depending on what is… as well because this makes it very easy to use LVM for backups while assuming you have BBU on the raid…
