…still significantly slower (and more CPU-intensive under high load) than PCIe flash For example, see http://www… Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD …(not actual RAM, that’s true, but much closer to memory speed than a regular SSD or HDD…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA SSD: Kingston HyperX …InnoDB performance on this size will be the same or worse, but will require 1TB in size. Now …2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages =…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… we usually configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking to Dell … factor for such application, or would allow them to delay sharding. This box also has 4 CPU sockets which means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL… on OS level or RAID controller so …RAM and I’m running Percona Server 5.5.28-29.1 on it with 6GB allocated for….2.0-35-generic Architecture | CPU = 64-bit, OS = 64-…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL …results – MySQL 6.0 still does not have hash or merge join which are frequently used for these …for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last 10 years I… make optimizer in MySQL, MariaDB or Drizzle better. Make it Plugable Every Major optimizer change causes a lot of pain for some of…% in RAM (even for Disk tables such MyISAM or Innodb) others keep database on SSD which has completely different ratio between CPU and IO…
Comment: Predicting how long data load would take
December 1, 2007 By 14 Comments
…for this wonder blog on the load performance. It is so timely. I was trying to evaluate MySql… speed completely. It will happen sooner or later. My question is that is… how large the CPU and RAM are? The result of larger CPU and RAM can only …this test on MySql 5.0 and my laptop has 2.6 GHZ CPU and 2GB…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…forget about spinlocks wasting CPU time on single CPU boxes without much …for row cache instead of single size, this is complicated. If I have 8GB of RAM…been implemented outside of MySQL Storage Engine level for MySQL – reading rows in…which is expensive or it will be possible for your transaction …
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had… or may be thousands of IOs per system for the whole system which allows to waste some CPU…run Innodb from the RAM drive 
Next I tested MyISAM which is well known for its simplicity and …
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 24, 2007 By 117 Comments
…!!! Is it multithreaded version of PHP, or pre-fork 
The most important test scenario for the enterprise: maximum number of concurrent users… about 20000 concurrent users (2Mhz CPU, 2Gb RAM, 20kb static HTML, mem-cache, keep-alive, …). Can MySQL back-end support 20000 concurrent users…
