Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31884

Implement Information_schema.files on MariaDB

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      It is well known within the MySQL community that the outputs of information_schema.tables is inaccurate as the data is based on statistics. This was solved in MySQL by implementing the IS.FILES table which allows us to see the total number of extents used by a particular data file.

      While we can SSH into the underlying database to check the actual storage used by the data file, for users who do not have SSH access to the host (ex. Cloud Databases) they are unable to get an accurate depiction of the storage used by their tables even after updating their table statistics

      Attachments

        Activity

          People

            Unassigned Unassigned
            ShadyZ Shaahid
            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.