35.5.1 Configuring Log Telemetry

This section describes the configuration for server.

For information on the configured loggers, see Section 29.12.21.1, “The setup_loggers Table”.

• Server Configuration Status Variables

• Server Configuration Command Line

Server Configuration Status Variables

This section describes the logger-related status variables.

• Telemetry_logs_supported: displays whether the server was compiled with Telemetry logging support.

• Performance_schema_logger_lost: Displays the number of logger instruments which failed to be created.

Server Configuration Command Line

This section describes the logger-related command line configuration options.

• performance-schema-logger: defines the default values for loggers. This can be defined multiple times, similarly to --performance-schema-instrument.

  In the following example, all loggers are configured with the error level ERROR, except foo and bar which are configured to error level INFO and WARNING, respectively:

                --performance-schema-logger = 'logger/% = Level:ERROR' --performance-schema-logger = 'logger/foo/% = Level:INFO' 
                --performance-schema-logger = 'logger/bar/% = Level:WARNING'

  To see the configured loggers, run the following:

  select * from performance_schema.setup_loggers;
  +------------------------+-------+-------------------------+
  | NAME                   | LEVEL | DESCRIPTION             |
  +------------------------+-------+-------------------------+
  | logger/sql/error_log   | info  | MySQL error logger      |
  | logger/sql/slow_log    | info  | MySQL slow query logger |
  | logger/sql/general_log | info  | MySQL general logger    |
  +------------------------+-------+-------------------------+

  This example shows the default MySQL error logger. This can be set to one of the following values:

  • none

  • error

  • warn

  • info

  • debug

  The following example changes the error logging level to WARNING:

  mysql> UPDATE performance_schema.setup_loggers
         SET LEVEL='WARN'

• performance_schema_max_logger_classes: this system variable can also be set from the command line. For example:

                --performance_schema_max_logger_classes=100

  Editing this value requires a server restart.