Details
-
Type:
Task
-
Status: Open
-
Priority:
Trivial
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: None
-
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)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
hum, i found this from mariadb
https://kb.askmonty.org/en/user-statistics/
maybe with time i could improve it
i will rewrite it since user-statistics is a nice usefull and already implemented
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