… R420 with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA SSD: Kingston HyperX 3K… note the transaction produces 4 INSERTs and workload is very write intensive. So what are results in this case: InnoDB gradually…_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native…
Post: Testing the Micron P320h
…the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took…Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.)…MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in…
Post: Intel 320 SSD write performance - contd.
… Intel 320 SSD write performance before, but I was not satisfied with these results. Somewhat each time on Intel 320 SSD I was getting different write… before each run. This leads me to conclusion that write performance on Intel 320 SSD is decreasing in time, and actually it is… /dev/sd$i Discussing this problem with engineers working with Intel 320 SSD drives I was advised to use artificial space provisioning…
Post: Testing Intel® SSD 910
Intel came on PCI-e SSD market with their Intel SSD 910 card. With a slogan “The ultimate data center SSD” I assume Intel targets rather… share. But before that, few words on the card internals. Intel puts separate 200GB modules, so 400GB card is visible as… used for other reviews, i.e. Testing Intel SSD 520 First results are for asynchronous writes: The result averages at 150 MiB/sec…
Post: Testing Intel SSD 520
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show … let me jump directly to results. First case is random write asynchronous 8 threads IO, the test is done just after… is 0.69ms. Now let me get back to random write case. I will try synchronous IO varying amount of threads…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
… make previous results inconsistent. In short words using Intel SSD X25-E card with enabled write-cache (which is default and most performance…/11/03/xfs-write-barriers/ ), but again with enable write-cache you may lose transactions. So in final conclusion: 1. Intel SSD X25E is NOT reliable in default mode 2. To have durability we need to disable write cache ( with…
Post: Should I buy a Fast SSD or more memory?
… to buy memory instead, and use the storage device for writes. Here’s the benchmark I came up with to confirm… improves performance by about five times (or 2x with an Intel SSD). To get the same improvement with memory, you would… There are already appliances on the market which use 8 Intel SSD devices). Is a 2x or 5x improvement enough? There…
Post: On Benchmarks on SSD
… graph from sysbench fileio random write benchmark with 4 threads. The results were taken on PCI-E SSD card ( I do not… devices support TRIM command, for example the first generation of Intel SSD cards did not support it, while G2 does. So why… to 520 MB/s Write: Up to 480 MB/s Sustained Write: Up to 420 MB/s Random Write 4KB : 70,000 IOPS…
Post: FlashCache: first experiments
… INTEL, Firmware Revision: 045C8621) * SSD-2: Intel X25-M 160GB ( 2 gen ) ( Model Number: INTEL SSDSA2M160G2GC, Firmware Revision: 2CV102HA ) * FlashCache: build over SSD-1 or SSD… separate RAID partition ( not on FlashCache or SSD) * Benchmark: sysbench oltp ( read-only and read-write modes), 80mln rows (~18GB of data… works when we put FlashCache on FusionIO cards instead of Intel SSD.
Post: Intel 320 SSD read performance
… and startups. Intel 320 SSD appears to be a popular drive with a quite acceptable price. I wrote about write performance of these… SAS 2.5 disks single Intel 320 SSD directly attached to a HighPoint RocketRAID 2300 two Intel 320 SSD in hardware RAID0 mode, attached…, ms (less is better) threads Intel 320 SSD Intel 320 SSD strip RAID ratio RAID/Intel 320 ratio RAID/Intel 320 strip 1 0.53 0…

