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:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[11 Oct 2005 15:00] Alexey Kopytov 
Description:
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