… see what room we now have to scale up – cheap memory, fast storage, better power efficiency. There certainly are a lot… (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… RAM (are your memory slots already filled?) Does your budget allow to install SSD cards? (You may still need more than one, since…
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
…/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy small dataset, so it caused more questions… we have more then 128GB of memory? If we use fast solid state drive, should we still be looking to increase memory, or that configuration… not used) This allows as to see effect of having more memory available. The graph result is: and raw numbers are on…
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
… http://www.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: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…As time has passed, they’ve added more EBS volumes to keep up with … these EBS volumes is — some are fast, some are slow, even though we…or a good price-to-performance ratio for the database as compared to a handful of SSDs (or… set of data stops fitting in memory, or if a lot of transactional writes …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…of 100MB/sec or more. This cache is DRAM based and so much faster than Flash. SSD Drives would…with “Persistent DRAM” memory device, which would offer some small amount, say 512M memory which is battery … full table scan would be fast. Maybe the table has become fragmented? Or maybe you have not …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… keep_average). Why do we need one more? Okay, first let me start by… good job on systems based on SSD/Flash storage, but it is not…left foot. (You can’t run fast with a broken foot, right ?) And…or heavy background queries.) If we see that flushing to disk is not able to keep up with changes in memory…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…memory to buffer pool so IOs will mostly come from drives directly which means hundreds or…will put on their roadmap. With SSD coming this will be important. …known for its simplicity and so fast execution path from getting data from…capacity was over 100K IOs/sec (more than with Innodb as these are …
