… to run benchmarks of different SSD cards. This time I show numbers for Virident FlashMAX 1400. This is a MLC PCIe SSD device. There are couple notes on these results. First, this time I use a different server. For this benchmark it… space to provide better write performance. So as usually I start with random writes, async. Soon after initial period, the result…
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…preferable, but there is one more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later …sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… MLC benchmarks), however I put results here to show theoretical maximal results. So let’s start with random reads: I’d say SSDs… can see results on http://www.percona.com/docs/wiki/benchmark:ssd:start, in summary table, randwr rows) 3. For cards connected in… based drives instead of SSD in my InnoDB on FusionIO benchmarks). So in summary I can say With SSD drives you can get…
Post: On Benchmarks on SSD
July 14, 2010 By 3 Comments
…-E SSD card ( I do not want to name vendor here, as the problem is the same for any card). The benchmark starts… task of running benchmark on SSD trickier. It is similar to benchmarks on database but up-down. The database just after start is in… A. The many benchmark scenarios ( and my initial sysbench fileio scripts) suppose to create files at the start of benchmark and remove afterward…
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… Ubuntu 8.10, as CentOS was not able to start with attached SSD card to HighPoint controller) and along with other tests… (see my post http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… benchmark I used sysbench oltp with 300 mln rows, which gives about 70GB of data. I allocated 35GB for cache on SSD… are there http://www.percona.com/docs/wiki/benchmark:flashcache:sysbench:300mln_rows:start And short results: buffer_pool, GBRAID10 FlashCache 20… quite impressive. Of course you do not have to believe benchmarks, so I encourage you to test yourself (my full scripts…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… Intel SSD X25-M card. While full results and config are on Wiki: http://www.percona.com/docs/wiki/benchmark:pbxt:tpcc:start…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… report and results are available on benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of results are on graph: In summary: on RAID final result: 2556.592 TpmC on Intel SSD… able to start and finish crash recovery. I am impressed. In my next rounds I am looking to run similar benchmarks on…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…). Hardware was our Dell 900 (specs here). To start with, we have a test on the RAID10 … Let me point out three interesting characteristics about this benchmark: The A arrow is when data fits completely … already filled?) Does your budget allow to install SSD cards? (You may still need more than one, …
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… RAID10 and 2 32GB SSDs used for ZIL and L2ARC, 72G RAM and 40G buffer pool. We started it up with innodb… system and/or innodb can become very slow (Yasufumi’s benchmarks show this very well). After enabling adaptive flushing we see… spot” for your server / workload combination. As always, you should benchmark your particular systems and not blindly follow advice you read…
