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

Account for queries handled by query-cache in USER_STATISTICS (and in HOST_STATISTICS)

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      [Affected version: at least 5.5.28a-MariaDB-log]

      When a user performs queries handled by query-cache theses are not taken into account by USER_STATISTICS (and probably neither by HOST_STATISTICS).

      They should properly increment COMMAND_SELECT, SENT_ROWS and when appropriate EMPTY_QUERIES.

      Without updating those a user that performs the same SELECT over and over, each time hitting query cache will appear as performing no queries, just burning CPU time and exchanging bytes.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              bprest Bruno Prémont (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.