[MDEV-33151] Add more columns to TABLE_STATISTICS and USER STATS Created: 2024-01-02  Updated: 2024-01-20

Status: In Progress
Project: MariaDB Server
Component/s: Plugin - userstat
Fix Version/s: 11.6

Type: Task Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 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

 Comments   
Comment by Michael Widenius [ 2024-01-02 ]

Commit message:

MDEV-33151 Add more columns to TABLE_STATISTICS and USER STATS

Columns added to TABLE_STATISTICS

  • ROWS_INSERTED, ROWS_DELETED, ROWS_UPDATED, KEY_READ_HITS and
    KEY_READ_MISSES.

Columns added to CLIENT_STATISTICS and USER_STATISTICS:

  • KEY_READ_HITS and KEY_READ_MISSES.

User visible changes (except new columns):

  • CLIENT_STATISTICS and USER_STATISTICS has columns KEY_READ_HITS and
    KEY_READ_MISSES added after column ROWS_UPDATED before SELECT_COMMANDS.

Other changes:

  • All row variables that are part of user_stats moved to
    'struct rows_stats' to make it easy to clear all of them at once.
  • ha_read_key_misses added to STATUS_VAR

Notes:

  • userstat.result has a change of handler_read_key. This is because
    use-stat-tables is now disabled for the test.
Comment by Michael Widenius [ 2024-01-02 ]

Code can be found in bb-11.5-monty

Generated at Thu Feb 08 10:36:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.