… store all my data on SSD when some of that data might just be sitting idle? Or what if my database is… be able to get enough SSD storage in my server at a cost-effective price point, or I might end up saturating… to run in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD or HDD RAID), I…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After… We call this configuration B. The next one contained four SSD-specific optimizations based partially on some earlier work that I… available buffer pool memory but still fits into the cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… not be able to justify the cost of the memory, but an SSD might be a good fit: Where the C arrow… (or 2x with an Intel SSD). To get the same improvement with memory, you would have needed to add 60% more memory -or- 260% more memory for…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… database’s working set is bigger than the server’s memory, or b) the workload is write-heavy. If this is the… ratio for the database as compared to a handful of SSDs (or traditional disks, for that matter, which would show writes in… that if the active set of data stops fitting in memory, or if a lot of transactional writes are required, then performance…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… afford 128GB of memory or so on the server too which will make read caching more efficient in its memory while write buffering… to scale (ie attempt to scale replication) or was a poor choice, with adding memory or SSD being a better choice. High Availability Some… SAN you should also evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as a scaling…
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
….mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy small… then 128GB of memory? If we use fast solid state drive, should we still be looking to increase memory, or that configuration provides… same – you should try to fit your active dataset into memory, and it is possible as nowadays systems with 300GB+ RAM…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… Memory: 192GB Storage: Hardware RAID10 over 8 disks, card: Perc H710, disks: Seagate ST9750420AS 750GB, 2.5″, 7200RPM, 16MB, SATA. Intel SSD… to have different memory/data ration. And we test it on two storages: HDD RAID10 and Intel SSD 910 Results There is… is the main contributor into that: the card of itself or MySQL internals + flushing logic. Now, all these results are received…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
…) CPU E5-2660 0 @ 2.20GHz Memory: 192GB Storage: Fusion-io ioDrive 640GB, Intel SSD 910 (software RAID over 2x200GB devices) Filesystem… to have different memory/data ration. And we test it on two storages: Fusion-io ioDrive and Intel SSD 910 Results There is graph of Throughput taken every 10 sec: Jitter graph: Or to have final…
Comment: RAID vs SSD vs FusionIO
May 2, 2009 By 17 Comments
… opinion that a database truly designed for SSD simply doesn’t exist. Also realize that SSD is a Flash device with a…’ve got a vast pool of memory” than “I’ve got memory and hard drive” or “memory plus SSD.” SSD might only be an interim technology… need filesystems for? What is I/O and what is memory access, and why do we differentiate the two? It’s…
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
…: 045C8621) * SSD-2: Intel X25-M 160GB ( 2 gen ) ( Model Number: INTEL SSDSA2M160G2GC, Firmware Revision: 2CV102HA ) * FlashCache: build over SSD-1 or SSD-2…_logfile* are placed on separate RAID partition ( not on FlashCache or SSD) * Benchmark: sysbench oltp ( read-only and read-write modes), 80mln… kernel 
. I will do more benchmarks especially when data exceeds memory, and also it will be interesting to see how it…
