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

improve user-statistics with more fields

    XMLWordPrintable

Details

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

    Description

      hi guys, it's a "old" MDEV, and i'm rewriting it...

      at User Statistics (https://kb.askmonty.org/en/user-statistics/), add more informations:
      1)TABLE_STATISTICS
      1.1)add queries counter (not only rows...)
      1.2) add impossible where counters ?
      1.3) add expend time reading?
      1.4) add expend time writing?
      1.5) add query cache hit counter? (maybe not, should improve query cache first... add table hits, today only query hits are 'implemented' (must be aproved) via MDEV-4682)

      2)INDEX_STATISTICS
      2.1)add "NULL" or empty ("") index, report without index queries
      2.2)add queries counter, (not only rows...)
      2.3)add expend time reading?
      2.4)add expend time writing?

      3)maybe another statistics.... when not using index, it's nice to know what columns was used in where clausule and check if we could index it, example...
      where non_indexed=1
      where (non_indexed1,non_indexed2)=(1,2)

      and others cases, well i must be more formal and more deterministic to know what to reporting in (3) but with time we can implement and understand what could help to improve some table that could be faster with a new index (the point here is know where we should create an index)

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.