… 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… to understand it better. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… numbers for Virident FlashMAX 1400. This is a MLC PCIe SSD device. There are couple notes on these results. First, this… not mistaken it is 25W, however Virident to provide full write performance requires 28W. And while many servers can handle 28W… internally more space to provide better write performance. So as usually I start with random writes, async. Soon after initial period, the…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… series of posts on testing different SSD, in my last post I mentioned that SATA SSD performance is getting closer to PCIe… 107053 Following the format of previous benchmarks, first is random write async 16KB case. We can see some wave-like pattern… and each card shows individuals patterns and different handling of write and read IO cases. Follow @VadimTk !function(d,s,id…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… drives for more write intensive load. By the way, Percona benchmarks seem to be the only freely available SSD benchmarks that are…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC… are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode… G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode… G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable… 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used. Traditionally…” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads…, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is not…
Comment: Review of Virident FlashMAX MLC cards
March 1, 2012 By 14 Comments
Sergey, I had a post on this topic http://www.mysqlperformanceblog.com/2011/11/15/mlc-ssd-card-lifetime-and-write-amplification/
Post: Intel 320 SSD write performance - contd.
September 28, 2011 By 8 Comments
… SSD write performance before, but I was not satisfied with these results. Somewhat each time on Intel 320 SSD I was getting different write… experiment as in previous post, this is sysbench fileio random write on different file size, from 10GiB to 140GiB with 10GiB… each run. This leads me to conclusion that write performance on Intel 320 SSD is decreasing in time, and actually it is…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… time to turn off write-cache on SSD – all transactions are in place now, but write speed is only 1200 writes / s, which is comparable with RAID 10 So in conclusion to warranty Durability with SSD we have to disable write-cache…/03/xfs-write-barriers/ ), but again with enable write-cache you may lose transactions. So in final conclusion: 1. Intel SSD X25E is…
