[MDEV-19460] userstat per query, session (currently only global) Created: 2019-05-13  Updated: 2024-01-18

Status: Open
Project: MariaDB Server
Component/s: Plugin - userstat
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: None


 Description   

Statistics should be tracked at 3 different levels, per query, per session, and globally.

Currently, we only track this globally.

Background: A patch was submitted to 5.2 in 2011 and 2012 that did this. Details are now difficult to find and involve the wayback machine. Here is some information: https://planet.mysql.com/entry/?id=28194

Discussion: https://www.mail-archive.com/search?l=maria-developers@lists.launchpad.net&q=subject:%22%5C%5BMaria%5C-developers%5C%5D+Changes+to+table_statistics+for+mariadb+5.2%22&o=newest&f=1

I am unable to locate the patch that was submitted itself, but it was not put into the codebase.

Customer continued using patched 5.2 until now and cannot upgrade without this feature.

 Comments   
Comment by Manjot Singh (Inactive) [ 2019-07-02 ]

Code is available here: https://code.launchpad.net/~ebergen/

Comment by Sergei Golubchik [ 2021-06-04 ]

Ideally this information should be in performance_schema now (and easily accessible as a sys_schema view, perhaps)

Generated at Thu Feb 08 08:51:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.