… 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… deliver good QoS or a good price-to-performance ratio for the database as compared to a handful of SSDs (or traditional disks… that if the active set of data stops fitting in memory, or if a lot of transactional writes are required, then performance…
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…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… was separate device in this case (though it was not SSD or memory). I would expect the overhead is still to be significant…
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: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… also surprising how many cases of people with reasonable sharded or replicated architecture suffer from wrong balance. Balancing can be simple… done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing questions you have to solve too such as SSD may not need so good in memory caching any more etc. There is no…
