May 21, 2012

Post: 128GB or RAM finally got cheap

…, which allows to get 128GB of memory with 4GB of memory chips. This means upgrade to default configuration to 128GB of memory will cost you… 2 CPUs (just as we usually configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking to Dell Sales rep… has 4 CPU sockets which means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL to take…

Post: Is there benefit from having more memory ?

… it caused more questions, like, should we have more then 128GB of memory? If we use fast solid state drive, should we… on numbers with 120GB ( as if you have system with 128GB of RAM) and 250GB Buffer_poolread-only, tpsread-write, tps 120GB1866.872547… memory, and it is possible as nowadays systems with 300GB+ RAM already available.

Comment: 128GB or RAM finally got cheap

…. Two quad core CPU’s and 128GB of RAM (in 16 8GB sticks.. so about $25k instead of $10k). It also has 14 SAS… 2 – 3 of those 8 cores.. this is probably because of innodb’s threading issues. However.. having that much RAM means *zero* IO… have them fan out (via various methods) to the parts of the application that must scale out, means the critical parts…

Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

… can’t recall any servers setup that has 64-128GB of RAM with 128-256GB of SWAP partition. As for constraint I think InfoBright…

Comment: Scaling to 256-way the Sun way

… your sizing note and my initial intent was to have 128GB of RAM on the T5440 but I could not make it happen…

Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

… have that amount of memory ( the box is only 16GB of RAM). MonetDB experts recommended me to extended swap partition to 128GB, but my… blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB benchmark may be not good for InfoBright, the synthetic nature of benchmark does not allow InfoBright to show better results. But…

Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server

… ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load… as next step, read detailed investigation what is the reason of performance drop in next post. And last one workload I… database fits “in-memory” cases – but on other hand 64-128GB RAM per box is not something rare already and recommendation to…