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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.1
    • Fix Version/s: 5.5.2
    • Component/s: PrimProc
    • Labels:
      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

            Activity

              People

              Assignee:
              gdorman Gregory Dorman
              Reporter:
              toddstoffel Todd Stoffel
              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.