In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs. This part, is about what
SYS can provide us about the queries hitting the MySQL database.
Currently, 3 methods are available:
The method’s name should be self explaining.
This is an overview of the parameters for each methods:
Some methods allow a
select parameter if only
SELECT statements should be returned.
When only one query is returned (default), it’s also possible to interactively run several actions:
- EXPLAIN (Traditional MySQL Query Execution Plan)
- EXPLAIN FORMAT=JSON
- EXPLAIN FORMAT=TREE
- EXPLAIN ANALYZE
This is a video illustrating these operations:
Don’t hesitate to try those plugins and a report eventual bugs, enhancements, feature requests and your own plugins !
The github repository is https://github.com/lefred/mysqlshell-plugins