摘自《MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB》
Benchmark环境：
硬件： (CPU总核数从6核到36核都分别测过）
引用
– 4 Sockets, 4 8 cores total, 4 x 12 – core AMD Opteron 6172 “Magny – Cours” 2.1GHz CPUs.
(Note: 36 cores were allocated to MySQL and the remaining 12 the Sysbench processes).
– 64 GB DDR3 RAM
– 2 x Intel X25E SSD drives
(Note: 36 cores were allocated to MySQL and the remaining 12 the Sysbench processes).
– 64 GB DDR3 RAM
– 2 x Intel X25E SSD drives
测试用例：
使用Sysbench：
引用
Both tests(只读和读写) use a set of 10 primary key lookups together with a few variants of queries performing
index scans. Sysbench RW(读写) also adds 3 update queries, 1 delete query and 1 insert query. All
operations are performed on one table.
测试结果
下图是不同核数下MySQL的TPS，同时也是性能随CPU核数扩展的能力
