[MXS-1333] Provide optional query execution time in qlafilter log Created: 2017-07-27 Updated: 2020-08-25 Resolved: 2017-11-15 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | qlafilter |
| Affects Version/s: | None |
| Fix Version/s: | 2.2.1 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Valerii Kravchuk | Assignee: | Esa Korhonen |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Sprint: | 2017-44, 2017-45 |
| Description |
|
MaxScale's qlafilter as of version 2.1 allows to optionally include several useful columns in the qlafilter log using log_data parameter. Please, add column for either query end timestamp or query execution time as it is seen by MaxScale. This will allow to use this filter to create a slow query log of a kind, and to aggregate data to find out the total time spent on queries logged per user or any other filter. |
| Comments |
| Comment by Valerii Kravchuk [ 2017-08-04 ] |
|
Millisecond precision would be enough. |