Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
When monitoring MariaDB all tools are using queries like
SHOW GLOBAL STATUS
SHOW VARIABLES
SHOW SLAVE STATUS
SHOW PROCESSLIST | SELECT * from information.processlist;
These queries are sent very often (once a minute in some cases) to the server and uses notable resources to parse and provide the result.
The idea is that instead of sending queries instead request which variables/status variables are of interested, if processlist should be provided and how often to send result. One can also ask to get results incremental (like mariadb-ladmin)
The server will then send the results to the client contentiously at the requested interval.
What can also be done is that if the server notices increased resource usage, it starts for a time send things more often. If there is less resource issue, the server could change this less often.
Attachments
Issue Links
- relates to
-
MDEV-37146 mariadb-dump: Replace SHOW SLAVE STATUS usage with information_schema.SLAVE_STATUS
-
- In Review
-