Wlad These SSD reviews of yours are just superb. My favourite on the MySQL Performace blog! You can also do a review on the best available hardware raid-sets and give your advise.
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 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: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 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: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 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…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
…three types of failures: * mysql becomes unavailable (best case) * mysql connection are unresponsive connection happen very slowly * mysql connection are unresponsive connection…weekly. * hardware failure – typically losing a disk. Usually the RAID controller does the right thing though when hard …
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 …
Post: Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
… change on other caches, which are MySQL Caches – Innodb Buffer Pool and Key Buffer are best example though Falcon, PBXT and other storage engines have similar buffers. There is also table_cache both MySQL side…, the hardware IO cache may however cause dramatic difference. Hardware RAID cache is the one but more important SAN caches which…
