Bug #13931 MySQL 5.0 is slower than 4.1 in DVD Store benchmark
Submitted: 11 Oct 2005 15:00 Modified: 29 Nov 2005 13:43
Reporter: Alexey Kopytov Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[11 Oct 2005 15:00] Alexey Kopytov
DVD Store benchmarks (http://linux.dell.com/dvdstore) shows 10% regression in 5.0 as compared to 4.1.

The final result for that benchmark is 3194 OPM (orders per minute) for 4.1, and for 5.0 it is 2683 OPM.

How to repeat:
Run the DVD Store benchmarks on 4.1 and 5.0
[12 Oct 2005 18:08] Alexey Kopytov
OProfile dump for 4.1

Attachment: test.txt (text/plain), 5 bytes.

[29 Nov 2005 13:43] Alexey Kopytov
The slowdown came from excessive "SHOW VARIABLES" and "SHOW COLLATION" queries issued by Connector/Net. "CacheServerConfig" connection string, which appeared in version 1.0.7 allows to eliminate those queries for this benchmark.

Results for DVD Store with CacheServerConfig set:

4.1.14: 5483 orders per minute
5.0.13: 5531 orders per minute

So 5.0 is slightly faster than 4.1 after removing. 

Regressions in the SHOW queries are reported in a separate bug #15314