10.1.6 Built-in MySQL Shell Reports

10.1.6.1 Built-in MySQL Shell Report: Query

10.1.6.2 Built-in MySQL Shell Report: Threads

10.1.6.3 Built-in MySQL Shell Report: Thread

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 10.1.5, “Running MySQL Shell Reports” explains how to run reports in each of these ways.