Performance Comparison of various mysql storage engines

1. test environment:

Cpu: 2 GHZ

Memory: 2 GB

Lan

Open a persistent connection to construct random query conditions.

 

2. Test Results

Data volume: 88171

Qps: query per second

 

 

 

Engine type	Domain Name	Cache (qps)	No cache (qps)
InnoDB	Innodb.Abc.com	7125.467573	11.127103
MyISAM	Myisam.Abc.com	7121.769949	15.163067
BDB	Bdb.Abc.com	7359.636813	11.939232
BDB	Index.Bdb.Abc.com	7501.889870	11.778504
Memory	Because blob type is not supported

 

 

 

Data volume: 10681

 

 

 

 

 

Engine type	Domain Name	Cache	No Cache
InnoDB	Innodb.Abc.com		105.974119
MyISAM	Myisam.Abc.com		130.401009
BDB	Bdb.Abc.com		2338.243488
BDB	Index.Bdb.Abc.com		108.794625
Memory	Because blob type is not supported

 

 

This article is from the "one party" blog