…all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to … maybe just normal. We didn’t try too hard to get better performance because we already had … other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs using …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock… of them. And it’s highly configurable, so you can make the tool try very hard to keep working. pt-upgrade is… on a server. Granted, this can take a lot of disk space, but it allows you to “run now, compare later…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive (HDD) as in RAID1 or one disk drive at all, you couldn’t really… have to decide on very early when configuring RAID. Disk sectors Most if not all hard disk drives available on the market these days…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… ==== ======= ====== ======= ============ =========== Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk…compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions …
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
….intel.com/Detail_Desc.aspx?agr=Y&DwnldID=17485) 2) Hard erase the drive after the update to make sure its… has 6 SATA ports. 4) Switch on AHCI for the disk configuration in your bios, it vastly improves small file access whether… standard HDD. It’ll help minimise writes and the standard hard drives are excellent at sequential writes which is what most…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… in every aspect of the server’s configuration and performance and contents. I’m looking … Aborted_clients | 205174 | 6 | | Aborted_connects | 29 | 0 | | Binlog_cache_disk_use | 0 | 0 | | Binlog_cache_use | 9630066 | 468 | …since it’s a cheap query. It adds hardly any load. But for the application, it…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… make our first hard-to-prove assumption: Hard-to-prove assumption #1: A Key_read might correspond to a physical disk read, maybe…, which is a worst-case scenario for spinning disks. This is also very hard to prove, but seems reasonable based on the… a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… which need to be read from undo space will require disk seek, unless they are buffered already. This means your backup… consider performance overheads mentioned in such operation. Actually exactly this configuration could be lifesaver if you have system with LVM setup… LVM configuration with no downtime as it is too fragile for every day use. If you can’t use USB hard drive…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… failed hard drive will be completely inaccessible, this happens even you just happen to be one bad sector on the disk. This… instead is to re-create RAID array in the same configuration as it was initially created, making the drive you want… way is to get something like Drive Fitness Test (different hard drive vendors have different versions) such tools would often have…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… responsible for writing consistent snapshots of the index files to disk. The frequency of checkpoints, as with other engines like InnoDB… for recovery to complete. PBXT seems to have very few configuration parameters. Â Was this an intentional design decision, and do… hard problem to solve in general. Tuning parameters are often added to an engine in response to performance problems in particular configurations…
