Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-164

lp:941889 JOIN constructors takes a long time in 5.3

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 5.5.20, 5.3.4
        • Fix Version/s: 5.5.22
        • Component/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                wlad Vladislav Vaintroub added a comment -

                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.

                Show
                wlad Vladislav Vaintroub added a comment - 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.

                  People

                  • Assignee:
                    monty Michael Widenius
                    Reporter:
                    wlad Vladislav Vaintroub
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 6 hours
                      6h