[MDEV-164] lp:941889 JOIN constructors takes a long time in 5.3 Created: 2012-02-27  Updated: 2012-03-23  Resolved: 2012-03-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.20, 5.3.4
Fix Version/s: 5.5.22

Type: Bug Priority: Critical
Reporter: Vladislav Vaintroub Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None


 Description   

According to VisualStudio CPU sampling profiler, major performance overhead in 5.3

A possible explanation along with benchmark numbers can be found in the corresponding LP bug here https://bugs.launchpad.net/maria/+bug/941889

 Comments   
Comment by Vladislav Vaintroub [ 2012-03-03 ]

To prove that it is not a Windows specific, I retested 5.2 vs 5.3 on the Linux servers used in benchmarks, accessible to anyone in MP.
Results tell me there is nothing OS specific, and there is a slowdown from 5.2 to 5.3 in the same simple sysbench test, from 8% to 16% , and that it can be reliably seen on Linuxes.

Numbers, scripts, compilation and runtime parameters are in the corresponding Launchpad bug, Please indicate if more data is necessary.

Generated at Thu Feb 08 06:26:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.