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

query execution time takes much longer in 5.5.x than 1.2.5

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5.1
    • Icebox
    • None
    • None
    • CentOS, Virtualized, On Premise

    Description

      Customer reported that query time takes much long in v5.5.x than v1.2.5.
      Here is calSetTrace result after calFlushCache from v1.2.5 and v.5.5.1.
      [v1.2.5]

      Old System Columnstore:
      select calFlushCache();
      select calSetTrace(1);
      SELECT v.`WHO1_ID` AS `1102_WHO1`
      ,SUM(`VAL_61_200`) AS `VALUE_2018_01_M_200_1_1`
      ...
      ...
      select calGetStats();
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | calGetStats()                                                                                                                                                                                             |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-305648; CacheI/O-305627; BlocksTouched-305544; PartitionBlocksEliminated-0; MsgBytesIn-861KB; MsgBytesOut-19MB; Mode-Distributed   |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      select convert(calGetTrace() ,CHAR);
       
      Desc Mode Table               TableOID ReferencedColumns                                                                                                                                      PIO    LIO  PBE Elapsed Rows
      CES   UM  -                   -        -                                                                                                                                                      -       -     - 0.161 160341
      BPS   PM fact_de_nvikt_1102     888958 (PZN_ID,VAL_13_200,VAL_14_200,VAL_15_200,VAL_16_200,VAL_17_200,VAL_18_200,VAL_19_200,VAL_1_101,VAL_20_200,VAL_21_200,VAL_22_200,VAL_23_200,VAL_24_200) 305648 305627 0 9.649 1980
      HJS   PM fact_de_nvikt_1102-ct  888958 ------- -
      TAS   UM -                    -        -                                                                                                                                                      -       -     - 8.646 15
      TNS   UM -                    -        -                                                                                                                                                      -       -     - 0.000 15
      

      [v5.5.1]

      select calFlushCache();
      select calSetTrace(1);
      SELECT v.`WHO1_ID` AS `1102_WHO1`
      ,SUM(`VAL_61_200`) AS `VALUE_2018_01_M_200_1_1`
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | calGetStats()                                                                                                                                                                                             |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-305606; CacheI/O-305588; BlocksTouched-305528; PartitionBlocksEliminated-0; MsgBytesIn-801KB; MsgBytesOut-14MB; Mode-Distributed |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
       
      select convert(calGetTrace() ,CHAR);
      Desc Mode Table                 TableOID  ReferencedColumns                                                                                                                                     PIO     LIO   PBE Elapsed Rows
      CES   UM  -                     -         -                                                                                                                                                     -       -     -     0.101 160341
      BPS   PM fact_de_nvikt_1102     23610     (pzn_id,val_13_200,val_14_200,val_15_200,val_16_200,val_17_200,val_18_200,val_19_200,val_1_101,val_20_200,val_21_200,val_22_200,val_23_200,val_24_200) 305606 305588 0  115.846 1485
      HJS   PM fact_de_nvikt_1102-ct  23610 - - - - ----- -
      TAS   UM -                      -         -                                                                                                                                                      -      -      -  113.812 15
      TNS   UM -                      -         -                                                                                                                                                      -      -      -    0.000 15
      |
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            allen.lee@mariadb.com Allen Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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