May 22, 2012

Post: FusionIO - time for benchmarks

… posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The problem was that FusionIO did… strict mode, so I lost interest FusionIO for couple month. But I should express respect to FusionIO team, they did not ignore… works internally (FusionIO does not have RAM on board and takes memory from host, so there is always cache kept in OS…

Post: FlashCache: tpcc workload with FusionIO card as cache

… on Intel SSD X25-M card, but now I use FusionIO 80GB SLC card. I chose this card as smallest available… you can see it for about $3K). There is also FusionIO IO-Xtreme 80GB card, which is however MLC based and… FlashCache on FusionIO in 20% dirty page, 80% dirty pages and write-through modes. I used full 80GB for caching ( total size…

Post: RAID vs SSD vs FusionIO

… SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should be noted – both SSD and FusionIO are run in “non-durable….mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it… have the same space as FusionIO we need 4 cards (but it still will be cheaper than FusionIO), but it also may…

Post: Write performance on Virident tachIOn card

… benchmark using the same methodology as in my experiment with FusionIO, which was stripped for performance. Also using my script, Virident… to use an SSD card as a cache layer (say, with FlashCache), as, usually for caching, you will try to fill all… point and full capacity point is much smaller compared with FusionIO Duo (without additional spare capacity reservation). * Also, looking at the…

Post: MySQL 5.5.8 and Percona Server: being adaptive

…. Furthermore, this optimization is not needed for flash devices, like FusionIO or Virident cards. An additional optimization we have for SSDs… is 512 bytes, in test with FusionIO I use 4096 bytes, to align IO with internal FusionIO size. You can see that…_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post…

Comment: FlashCache: tpcc workload with FusionIO card as cache

I forgot to mention on the topic that I’m *extremely* excited to test FlashCache soon. We have several DB’s that are too large to fit on an affordable amount of FusionIO storage, but that probably have *working* sets that would fit in the FusionIO card in a cached manner. *drools*

Comment: How many fsync / sec FusionIO can handle

… for this test. What we wanted to check if whenever FusionIO is good enough to keep transactional logs on it. For… compared to writes to the RAID cache (with BBU) It looks like it is not the case for FusionIO which is great.

Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks

… and FusionIO in durable mode? I mean this: http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/ http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too…

Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks

… and FusionIO in durable mode? I mean this: http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/ http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too…

Post: FlashCache: tpcc workload

… simply test the case when data does not fit into cache partition). Please note in this configuration the benchmark is very… trash, but after restart FlashCache was able to attach previous cache, and MySQL was able to start and finish crash recovery… next rounds I am looking to run similar benchmarks on FusionIO card. P.S. And if CentOS team reads this post…