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

Add waiting and processing lines for statements in debuglog

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.0.0, 1.2, 1.5.3, 5.5.2, 5.6.2, 6.1.1
    • Fix Version/s: Icebox
    • Component/s: None
    • Labels:

      Description

      Usually columnstore logs the start and end timepoint of a SQL statement.

      Oct 26 12:44:44  D 21 CAL0001: Start SQL statement: 
      Oct 26 12:48:12  D 21 CAL0001: End SQL statement
      

      The time between Start and End is not the processing time.
      There are also waiting time for ressources.
      You're tempted to find the error in the SQL statement himself,
      but it could also memory issues, waiting for free requests
      (MaxOutstandingRequests is reached), free memory,
      wait for a table lock etc.

      So it would helpful to add information for.

      Which ressource is shortage ?
      When the sql processing starts

      Oct 26 12:44:44  D 21 CAL0001: Start SQL statement: 
      Oct 26 12:44:44  D 21 CAL0001: Wait for free xxxxxx
      Oct 26 12:48:10  D 21 CAL0001: SQL Processing started
      Oct 26 12:48:12  D 21 CAL0001: End SQL statement
      

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            Richard Richard Stracke
            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.