[MDEV-33151] Add more columns to TABLE_STATISTICS and USER STATS - Jira

XML

Word

Printable

Details

Type: New Feature
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Fix Version/s: 11.5.1
Component/s: Plugin - userstat
Labels:
- Preview_11.5

Description

Following changes are for the userstat plugin:

Add the following columns to TABLE_STATISTICS for MariaDB monitors:

ROWS_INSERTED, ROWS_DELETED, ROWS_UPDATED, KEY_READ_HITS and KEY_READ_MISSES

Add the following statistics to CLIENT_STATISTICS and USER_STATISTICS:

KEY_READ_HITS and KEY_READ_MISSES

Attachments

Issue Links

causes

MDEV-33881 Userstat skips system tables inconsistently

Closed

MDEV-33913 TABLE_STATISTICS increments ROWS_CHANGED twice upon UPDATE and does not count DELETE

Closed

MDEV-33916 Key_read_misses in USER_STATISTICS and CLIENT_STATISTICS is unusable

Closed

MDEV-34153 Userstat Key_read_hits/Key_read_misses do not work for descending keys

Open

MDEV-34154 Userstat: Updates to system tables via DDL are reflected in client/user statistics

Open

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Michael Widenius

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2024-01-02 11:51

Updated:: 2024-06-15 13:08

Resolved:: 2024-05-27 11:23

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.