… the write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to…” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the… best tpcc results I got were when using compression. I still have to explain this, maybe it is related to better raid…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… 500GB. What are my options for achieving the best performance? I could by a ton of RAM, … point, or I might end up saturating my RAID controller such that now it becomes the bottleneck. Also… not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… relevant. It was and still is, however, relevant with HDD RAID storage – technology we have been using for many years – when… decides how to distribute writes properly so they make the best use of the underlying storage, it also makes sure file… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID … not different MySQL configurations, I didn’t try out different MySQL versions … mkfs. This is your best option if you have …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which …cases for this given workload the performance was best with both read_ahead types enabled but … work better with O_DIRECT mode. The RAID controller also can make significant difference here …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…cases also don’t log the resulting errors. The best place to fix these problems is in the application…for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of …is not unheard of for a monitoring agent or RAID utility software to do this. The pmp-check-…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… want to use mysql on /dev/sda3, but how can we ensure that it is aligned with the RAID stripes? It takes… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896… missed step related to getting the IO setup properly. The best choices here are between ‘deadline’ and ‘noop’. Deadline is an…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… memory while write buffering can too be done by MySQL and local RAID (with BBU) quite efficiently. It is worth to say… to do the same with MySQL. This works though I do not think it is the best choice. SAN is just another… use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…, but at the same time you should not have hardware RAID or have one without battery backed up cache (BBU unit…=2 This is probably best solution. In many cases this would be good change to do with MySQL 4 also because 100… should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… group: 2048 Inode blocks per group: 128 RAID stride: 8 RAID stripe width: 80 Flex block group size: … kernel panic. I believe remount-ro is the best option to use for the database server, though …probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing …
