[MDEV-5083] Incorrect description of USER_STATISTICS.EPTY_QUERIES Created: 2013-10-01 Updated: 2014-04-09 Resolved: 2014-04-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Oleksandr Byelkin | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | documentation | ||
| Description |
|
It is about https://mariadb.com/kb/en/user-statistics/ Internally CLIENT_STATISTICS and USER_STATISTICS data format are the same (i.e they collect the same information about different objects) so description of the fields should be the same. CLIENT_STATISTICS.EPTY_QUERIES description is correct. USER_STATISTICS.EPTY_QUERIES gives description of Com_empty_query as I can see. |
| Comments |
| Comment by Oleksandr Byelkin [ 2013-10-01 ] | ||||||||||||||||||||||||||||||||||||||
|
It might be that I am wrong (CLIENT_STATISTICS description is RIGHT and USER_STATISTICS is wrong) there is EMPTY_QUERY and empty_queries, and they are different. | ||||||||||||||||||||||||||||||||||||||
| Comment by Oleksandr Byelkin [ 2013-10-01 ] | ||||||||||||||||||||||||||||||||||||||
|
It appeared to be vice verse. Sorry. | ||||||||||||||||||||||||||||||||||||||
| Comment by Elena Stepanova [ 2014-04-09 ] | ||||||||||||||||||||||||||||||||||||||
|
Apparently (empirically), EMPTY_QUERIES means "queries that returned no results to the server", even though Percona documentation http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html puts it differently. The results below are true both for Percona 5.5 and MariaDB 10.0. I've updated the page accordingly.
|