… 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 54 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…
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…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…”, is doing a very good job on systems based on SSD/Flash storage, but it is not so good for regular… backup or heavy background queries.) If we see that flushing to disk is not able to keep up with changes in memory… throttling mechanism that will limit the rate of changes in memory. Optimize the flushing of sequential neighbor pages in a way…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage… to allocate cache memory to buffer pool so IOs will mostly come from drives directly which means hundreds or may be thousands… scaling which Innodb team will put on their roadmap. With SSD coming this will be important. And it is also very…
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
….mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/ and there http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusionio/
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… leveling is used for flash memories. I looked up some information on the web about flash memories, and noticed that random writes… rate of 100MB/sec or more. This cache is DRAM based and so much faster than Flash. SSD Drives would be big… come up with “Persistent DRAM” memory device, which would offer some small amount, say 512M memory which is battery backed up just…
