[MDEV-279] improve user-statistics with more fields Created: 2012-05-17  Updated: 2013-07-15

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

Type: Task Priority: Trivial
Reporter: roberto spadim Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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)



 Comments   
Comment by roberto spadim [ 2013-06-05 ]

from twitter, i think this is near what i'm talking about
https://github.com/twitter/mysql/wiki/The-TABLE_STATISTICS-table
https://github.com/twitter/mysql/commit/237a6ff8d0d4cd6056aacb5e7012a89364eb8109

Comment by roberto spadim [ 2013-06-05 ]

and this too
https://github.com/twitter/mysql/commit/8b60767a46e0d2517923171ef85207b61c0ea5f8

Comment by roberto spadim [ 2013-07-15 ]

hum, i found this from mariadb
https://kb.askmonty.org/en/user-statistics/

maybe with time i could improve it

Comment by roberto spadim [ 2013-07-15 ]

i will rewrite it since user-statistics is a nice usefull and already implemented

Generated at Thu Feb 08 06:27:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.