[MCOL-447] enhancement to querystats collection Created: 2016-12-06 Updated: 2023-07-03 Resolved: 2023-07-02 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | 1.0.5 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Minor |
| Reporter: | David Hill (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | None | ||
| Sprint: | 2017-16, 2017-17, 2017-20 |
| Description |
|
The querystats table does not record which schema the query was executed against. Making it very difficult or impossible to determine this critical piece of information to determine where a problem may reside. |
| Comments |
| Comment by David Hill (Inactive) [ 2016-12-06 ] |
|
InfiniDB Issue #9764 |
| Comment by David Thompson (Inactive) [ 2017-06-05 ] |
|
This is related to the query stats history feature: https://mariadb.com/kb/en/mariadb/analyzing-queries-in-columnstore/#query-statistics-history Add a new column named databaseName to capture the active database in use while the query was run. We should not try to parse this out from the query as you potentially might have multiple databases referenced. The audit query plugin already captures this but please confirm this works correctly as well. |
| Comment by David Hill (Inactive) [ 2020-11-27 ] |
|
Need an update on which version this is planned for. thanks |
| Comment by Todd Stoffel (Inactive) [ 2020-11-27 ] |
|
hill The Fix Version/s above indicates that this ticket is in the Icebox. This means it is not currently in the roadmap. For each new release, we look through the tickets in the Icebox and assign to new versions based on business value. No further update will be available at this time. |
| Comment by Todd Stoffel (Inactive) [ 2023-07-02 ] |
|
The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket. |