… customers are looking for cheaper alternatives. SATA SSD is an options. There is many products …: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems …about drops – the drive periodically cleans an internal cache or something. To understand better what kind …
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… a lot of question if this is good for SSD, or something else (i.e. xfs) should be used….with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 …}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file…
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 which…/11/03/xfs-write-barriers/ ), but again with enable write-cache you may lose transactions. So in final conclusion: 1. Intel SSD X25E is…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse… results are here and average results: RAID10 – 7439.850 TPM SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should….mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single device…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
…SSDs allowed in MaxIQ Cache pool : 8 MaxIQ Read Cache Pool Size : 0.000 GB MaxIQ cache fetch rate : 0 MaxIQ Cache Read, Write…Read-cache mode : Enabled MaxIQ preferred cache setting : Disabled MaxIQ cache setting : Disabled Write-cache mode : Enabled (write-back) Write-cache setting : Enabled (write-…
Comment: Heikki Tuuri answers to Innodb questions, Part II
November 7, 2007 By 13 Comments
… wouldn’t offload my log files to SSD unless the SSD incorporated an onboard RAM cache. Otherwise, as Peter and Heiki say,there… drives. If you already have external RAID arrays with BBU write cache, then I don’t think it makes sense to offload… a lot of performance. If you don’t have BBU write cache in an external RAID array, then it might make sense…
Comment: FlashCache: tpcc workload
May 26, 2010 By 18 Comments
…, but no BBU on SSD, it is directly attached and it has write cache enabled. I did not test SSD with BBU, so I can’t provide good feedback there. Disabling write cache on SSD really affects write…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… than cache. But before test setup let me address some concern (which I also had). Intel X25-M has a write cache which… exactly where to write data..”. So I assume we should be safe running Intel X25-M with enabled write cache. Second issue I… gives about 70GB of data. I allocated 35GB for cache on SSD and I used 16GB and 10GB buffer pool sizes. I…
Comment: FlashCache: tpcc workload
April 20, 2011 By 18 Comments
… expensive SSD or flash-drive such as X25E or fusion io drive with FlashCache due to the SSD write performance limitation? Would SSD made of MLC be problematic with FlashCache as a server cache after the cache becomes full? Therefore, in a real production environment, we should always spend big to get SLC SSD? Thanks…
Post: FlashCache: tpcc workload with FusionIO card as cache
June 2, 2010 By 20 Comments
This run is very similar what I had on Intel SSD X25-M card, but now I use FusionIO 80GB SLC…% dirty page, 80% dirty pages and write-through modes. I used full 80GB for caching ( total size of data is about 100GB… remember that load is very write intensive and all benefits in write-through mode come only from cached reads, so it is pretty…
