MySQL Shell 9.3
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:
Use the --verbose
command-line
option when starting MySQL Shell.
Use the MySQL Shell \option
command to set
the verbose
MySQL Shell configuration
option. For instructions to use this command, see
Section 14.4, “Configuring MySQL Shell Options”.
Use the shell.options
object to set the
verbose
MySQL Shell configuration option.
For instructions to use this configuration interface, see
Section 14.4, “Configuring MySQL Shell Options”.
The available settings are as listed in
Table 13.1, “Logging levels in MySQL Shell”. The settings for the
verbose
option display messages at the
following levels of detail:
No messages. Equivalent to a logging level of 1 for the application log.
Internal error, error, warning, and informational messages. Equivalent to a logging level of 5 for the application log.
Adds debug
messages. Equivalent to a
logging level of 6 for the application log.
Adds debug2
messages. Equivalent to a
logging level of 7 for the application log.
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, which is permitted as a
command-line option when starting MySQL Shell
(--verbose
) but not with other methods of
setting the option, setting 1 (internal error, error, warning, and
informational messages) is used.