MySQL 5.5 的TPS

摘自《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 

测试用例:

使用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核数扩展的能力


Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.