[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: 2)INDEX_STATISTICS 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... 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 |
| Comment by roberto spadim [ 2013-06-05 ] |
|
and this too |
| Comment by roberto spadim [ 2013-07-15 ] |
|
hum, i found this from mariadb 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 |