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 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… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition… and nor do RAID controllers as they also operate in 512-bytes internally. This however gets more complicated with SSD drives which…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
…Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2…. Some Newer Adaptec Controllers also offer using SSD as a cache with technology called MaxIQ. … device number 0 Logical device name : RAID10-A RAID level : 10 Status of logical device : Optimal Size …
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… look what a lifetime we can expect under a tpcc-mysql workload. I put 32 users threads against 5000W dataset (about…/sec, which corresponds to write throughput 273.45MB/sec from MySQL to disk. And it helps to calculate the lifetime of… RAID is much less than on SSD and you do not know what your throughput will be when you put workload on SSD…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have… memory slots already filled?) Does your budget allow to install SSD cards? (You may still need more than one, since they… located in differently. Raw results: Buffer pool, GB FusionIO Intel SSD RAID 10 2 450.3 186.33 80.67 4 538…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same…/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single device, in comparison to RAID… TPM on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM / $ Please note…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space… mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads and writes pages from buffer pool (replacing… allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… memory while write buffering can too be done by MySQL and local RAID (with BBU) quite efficiently. It is worth to say… evaluating SAN you should also evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the…hard drives it would perform as good as SSD ? Not really. Leaving all potential serialization issues …backups while assuming you have BBU on the raid volume impact on transactional log write speed is…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… showing benchmark results on Amazon EC2 servers with RAID‘ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t… times in EBS as compared to directly attached disks or SSD devices. InnoDB doesn’t handle this very well, because I… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get…
