I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous … card is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare… 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h, but the result…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a sysbench uniform oltp rw workload. 256… to investigate later. The scripts and raw results are on Benchmarks Launchpad. Follow @VadimTk !function(d,s,id){var js,fjs…
Post: SSD: Free space and write performance
July 17, 2010 By 9 Comments
… from SSD Performance Blog ) In previous post On Benchmarks on SSD, commenter touched another interesting point. Available free space affects write performance on SSD… with 100GiB. So returning to question how to run proper benchmark, the result significantly depends what percentage of space on card…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… benchmarks passion (see my two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD… results are here and average results: RAID10 – 7439.850 TPM SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should… (see my post http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While…
Post: Testing Intel SSD 520
May 1, 2012 By 8 Comments
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show the results of raw IO performance of this card. The benchmark… to understand it better. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… the results presented there Benchmarking MariaDB-5.3.4 The initial benchmark is described in Benchmarks of Intel 320 SSD 600GB, and the result… neighbor pages and the configuration to provide better experience on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method…-plugin, like MariaDB suggests in Benchmarking MariaDB-5.3.4. Raw results and scripts are on Benchmarks Launchpad Follow @VadimTk !function(d…
Post: Intel 520 SSD in MySQL sysbench oltp benchmark
May 21, 2012 By 11 Comments
In my raw IO benchmark of Intel 520 SSD we saw that the drive does not provide uniform throughput … it affect workload if it comes from MySQL. I prepared benchmarks results for Sysbench OLTP workload with MySQL running on Intel… use write cache from RAID controller (i.e. LSI-9260). Benchmarks specification, hardware, scripts and raw results are available in the…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
Following my previous benchmark of Samsung 830, today I want to show results for … publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL… talk – you are welcome to join the webinar. Disclaimer: This benchmark is done as part of consulting work for STEC, but…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used. Traditionally… MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount… 20% better throughput. I am still going to run more benchmark to get better picture. The script for tests: for size…
Post: Testing Intel® SSD 910
September 4, 2012 By 2 Comments
… came on PCI-e SSD market with their Intel SSD 910 card. With a slogan “The ultimate data center SSD” I assume Intel… scripts I used for other reviews, i.e. Testing Intel SSD 520 First results are for asynchronous writes: The result averages… attractive. I am going to run more corresponding MySQL-based benchmarks to see how the card is compared to alternatives under…
