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

Support method to report on data set size

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 1.0.5
    • ?
    • None
    • 2016-21, 2016-22, 2016-23

    Description

      There should be a means to determine storage actually used by columnstore by:

      • all
      • schema
      • schema and table

      This should report by:

      • schema
      • tablename,
      • columnName
      • dataType
      • columnWidth
      • dbroot
      • partition
      • segment
      • filename
        -size (in GB compressed).
      • Uncompressed size would be desirable if possible too.

      Information_Schema tables (Table and Column etc) likely would be the best and standard ways to support this, but not all of this information may be representable in that form. What can be populated in infoschema should be done and then we can review an approach for most easily capturing the remaining attributes as either a proc, script, or mcsadmin command.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              dthompson David Thompson (Inactive)
              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.