[MXS-1780] Provide access to current queries via REST-API Created: 2018-04-11 Updated: 2018-11-08 Resolved: 2018-11-08 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Core, REST-API |
| Affects Version/s: | None |
| Fix Version/s: | 2.3.1 |
| Type: | New Feature | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Johan Wikman |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Sprint: | MXS-SPRINT-69 |
| Description |
|
‘SHOW MAXSCALE QUERIES’ - shows the list of queries currently running through MaxScale, the service it is associated with, filters on the service, the user@client sending the query, backend server where the query is running, start time when query was received. The ability to run this command shall be configurable. |
| Comments |
| Comment by Johan Wikman [ 2018-11-07 ] | |||||||||||||||||||||||||
|
This has now been implemented so that the information is provided as part of the session information.
where
This information is available if retain_last_statements has been specified, either in the MaxScale global section or specifically for the service the session relates to. The maxctrl command show sessions shows the last statements of the sessions, but not the details. The feature can be turned on and off at runtime using maxctrl alter service. E.g.
The command above will cause new sessions related to the service RWS to retain the last 5 statements of the session. Existing sessions are not affected. |