MySQL Shell includes built-in reports to display the following information:
The results of any specified SQL query (
query, available from MySQL Shell 8.0.16).
A listing of the current threads in the connected MySQL server (
threads, available from MySQL Shell 8.0.18).
Detailed information about a specified thread (
thread, available from MySQL Shell 8.0.18).
As with user-defined reports, the built-in reports can be run once
using the MySQL Shell
\show command, or run
and then refreshed continuously in a MySQL Shell session using
\watch command. The built-in reports
support the standard options for the
\watch commands in addition to their
report-specific options, unless noted otherwise in their
descriptions. They can also be accessed as API functions using the
Section 9.1.5, “Running MySQL Shell Reports” explains how to run
reports in each of these ways.