telemetry.log_enabled

Controls whether telemetry logs are exported or not.

telemetry.otel_exporter_otlp_logs_protocol

OTLP transport protocol

telemetry.otel_exporter_otlp_logs_endpoint

Target URL to which the exporter sends logs.

telemetry.otel_exporter_otlp_logs_network_namespace

(Linux only) Network namespace to use when sending data to the logs endpoint.

telemetry.otel_exporter_otlp_logs_certificates

The trusted certificate to use when verifying a server's TLS credentials.

telemetry.otel_exporter_otlp_logs_client_key

Client's private key in PEM format.

telemetry.otel_exporter_otlp_logs_client_certificates

Client certificate/chain trust for client's private key in PEM format.

telemetry.otel_exporter_otlp_logs_headers

A list of headers to apply to all outgoing logs

telemetry.otel_exporter_otlp_logs_secret_headers

Name of a secret, that contains the sensitive data for logs headers. The data content and format depends on the secret provider implementation provided with system variable telemetry.secret_provider.

telemetry.otel_exporter_otlp_logs_compression

Compression used by log exporter.

telemetry.otel_exporter_otlp_logs_timeout

Time in milliseconds the OTLP exporter waits for each batch export.

telemetry.otel_blrp_schedule_delay

Delay interval between two consecutive exports in milliseconds.

telemetry.otel_blrp_max_queue_size

Maximum queue size.

telemetry.otel_blrp_max_export_batch_size

Maximum batch size.

telemetry.otel_exporter_otlp_logs_min_tls

The minimum accepted TLS version. If left empty, TLS 1.2 is used.

telemetry.otel_exporter_otlp_logs_max_tls

The maximum accepted TLS version. If left empty, there is no maximum TLS version.

telemetry.otel_exporter_otlp_logs_cipher

Current list of TLS 1.2 ciphers to use for logs. The current default is:

ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:
ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:
ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES256-CCM:ECDHE-ECDSA-AES128-CCM:
DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-CCM:
DHE-RSA-AES128-CCM:DHE-RSA-CHACHA20-POLY1305

telemetry.otel_exporter_otlp_logs_cipher_suite

Current list of TLS 1.3 ciphers to use for logs. The current default is:

 TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_CCM_SHA256

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.

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/error/error_log | info  | MySQL error logger |
+------------------------+-------+--------------------+
            

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

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.