MySQL Shell 9.4  /  ...  /  Built-in MySQL Shell Reports

11.1.6 Built-in MySQL Shell Reports

MySQL Shell includes built-in reports to display the following information:

  • The results of any specified SQL query (query.

  • A listing of the current threads in the connected MySQL server (threads.

  • Detailed information about a specified thread (thread.

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 the \watch command. The built-in reports support the standard options for the \show and \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 shell.reports object. Section 11.1.5, β€œRunning MySQL Shell Reports” explains how to run reports in each of these ways.