Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4522

calGetTrace shows double LIO from Community 5.4.1 to Enterprise 5.5.1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.1
    • 5.5.2
    • PrimProc
    • None

    Description

      SELECT calSetTrace(1);


      SELECT addresskey,
      		 
             cityname,
      		 
             statecode,
      		 
             zip
      		 
      FROM   mailing_addresses_cis
      		 
      WHERE  zip = '33776';


      SELECT calGetTrace();

      Community 5.4.1 Results:

      Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
      BPS PM mailing_addresses_cis 4390 (addresskey,cityname,statecode,zip) 0 109325 49152 0.815 5679
      TNS UM - - - - - - 0.801 5679

      Enterprise 5.5.1 Results:

      Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
      BPS PM mailing_addresses_cis 4390 (addresskey,cityname,statecode,zip) 0 288623 0 1.604 5679
      TNS UM - - - - - - 1.585 5679

      It appears that the Logical I/O is more than double in enterprise, we see 0 Partition Blocks Eliminated, and the query time is almost double.

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4527 Simple query performace is degraded between 5.4 and 5.5

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is blocked by

          Task - A task that needs to be done. MCOL-4529 Design the proper way of doing extent elimination on varchars with utf8 or utf8mb4

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MCOL-4580 Extent's approximate range keeping for dictionaries

          • Major - Major loss of function.
          • Closed

          Activity

            People

              gdorman Gregory Dorman (Inactive)
              toddstoffel Todd Stoffel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.