Documentation Home
MySQL Shell 8.0
Related Documentation Download this Manual
PDF (US Ltr) - 491.7Kb
PDF (A4) - 492.0Kb
HTML Download (TGZ) - 98.8Kb
HTML Download (Zip) - 110.5Kb


MySQL Shell 8.0  /  MySQL Shell Logging and Debug  /  Verbose Output

8.2 Verbose Output

From MySQL 8.0.17, you can send MySQL Shell logging information to the console to help with debugging. Logging messages sent to the console are given the verbose: prefix. When you send logging information to the console, it is still sent to the application log file.

To send logging information to the console as verbose output, choose one of these options:

The available settings are as listed in Table 8.1, “Logging levels in MySQL Shell”. The settings for the verbose option display messages at the following levels of detail:

0

No messages. Equivalent to a logging level of 1 for the application log.

1

Internal error, error, warning, and informational messages. Equivalent to a logging level of 5 for the application log.

2

Adds debug messages. Equivalent to a logging level of 6 for the application log.

3

Adds debug2 messages. Equivalent to a logging level of 7 for the application log.

4

Adds debug3 messages, the highest level of detail. Equivalent to a logging level of 8 for the application log.

If the verbose option is not set on the command line or in the configuration file, or if you specify a setting of 0 for the option, verbose output to the console is disabled. All other values enable verbose output and set the level of detail for the messages sent to the console. If you specify the option without a value, setting 1 (internal error, error, warning, and informational messages) is used.