… both need plenty of) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends…. (All ZFS systems should max ram slots with 16gb dual rank dimms, which are relatively cheap these days, that means 288GB for Xeon 5600 series servers, and 384GB for Xeon E5-2600 servers, so sacrificing 10% ram…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run a few slave instances each of… can compress data on the fly and it is surprisingly cheap. In fact the best tpcc results I got were when…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… (just as we usually configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking to Dell Sales rep…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… for the sake of BBU. As Jeremy mentioned RAID is cheap these days if you buy right one and can offer… I see people using 2*2 Opterons with 32GB of RAM and 10-14 hard drives. Both solutions have comparable price… vendors. Dell for example for some reason failed to provide cheap 32GB of memory option even with their new Opteron servers…
Comment: What CPU Architecture do you prefer for running MySQL In production
December 15, 2012 By 13 Comments
… (in private clouds, on AWS, etc.), usually 8-64Gb of RAM or more. Usually batter-backed PERC raid on 15K SAS… R420s with 24 HT cores, 128-256GB of RAM, 8TB of disk are cheap and powerful machines for MySQL, even in virtualized…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… to see what room we now have to scale up – cheap memory, fast storage, better power efficiency. There certainly are… where your C point is when you have 32GB of RAM and 100GB of data. Than it gets interesting: Can you easily add another 32G RAM (are your memory slots already filled?) Does your budget allow…
Comment: L2 cache for MySQL
November 18, 2012 By 13 Comments
… data that will fit inside an SSD but not in RAM then this will probably be a great solution. Of course… have persistent storage with the performance characteristics of DDR4 for cheap but we don’t live in that world.
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… be on http://forums.mysql.com/list.php?24 ) > 8GB RAM > key_buffer_size=512M I would recommend (if you stick… MERGE UNION every week? That should have been a _very_ cheap way to drop a whole _week_ at a time. (reformatting…
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 4, 2010 By 20 Comments
… depending on your workload you my be able to get cheap gains using SSD disks rather than cards. The other benefit… the longer warmup will take. Also no matter how much RAM you have you still have to do writes which can…
Post: "Shard early, shard often"
November 16, 2009 By 6 Comments
… to explain that hardware advances such as 128G of RAM being so cheap is changing the point at which you need to…
