Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-196

alloc_root is about 4 times slower (compared to libmysql)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.0, 2.3.0
    • 3.0.1, 2.3.1
    • None
    • None

    Description

      Due to unnecessary loops alloc_root() function is about 4 times slower.
      For a complete description and test case please check ODBC-31

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. ODBC-31 High CPU usage and low network utilization when processing a huge result set

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            georg Georg Richter created issue -
            georg Georg Richter made changes -
            Field Original Value New Value
            georg Georg Richter added a comment -

            Fixed in revisions:
            C/C 3.0.1: 7b146034383085bff38b19d9f6399a90896faf02
            C/C 2.3.1: ac6078066c26473009fbea2f29cabed87a4f4466

            georg Georg Richter added a comment - Fixed in revisions: C/C 3.0.1: 7b146034383085bff38b19d9f6399a90896faf02 C/C 2.3.1: ac6078066c26473009fbea2f29cabed87a4f4466
            georg Georg Richter made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            rcannao René Cannaò added a comment -

            Georg, in ac6078066c26473009fbea2f29cabed87a4f4466 , the multiplier here was chosen randomly?
            For ProxySQL (that uses libmariadbclient) and sysbench workload, replacing

            (mem_root->block_size & ~1) * (mem_root->block_num >> 2)

            with

            (mem_root->block_size & ~1) * 2

            improves performance by 10x

            rcannao René Cannaò added a comment - Georg, in ac6078066c26473009fbea2f29cabed87a4f4466 , the multiplier here was chosen randomly? For ProxySQL (that uses libmariadbclient) and sysbench workload, replacing (mem_root->block_size & ~1) * (mem_root->block_num >> 2) with (mem_root->block_size & ~1) * 2 improves performance by 10x
            julien.fritsch Julien Fritsch made changes -
            Workflow MariaDB connectors [ 76563 ] MariaDB v4 [ 161031 ]

            People

              georg Georg Richter
              georg Georg Richter
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.