MySQL 8 Cookbook

Using the system log for logging

To use the system log for logging, you need to load the system log writer called log_sink_syseventlog. You can use the built-in filter, log_filter_internal, for filtering:

1. Load the system log writer:

mysql> INSTALL COMPONENT 'file://component_log_sink_syseventlog';Query OK, 0 rows affected (0.43 sec)

2. Make it persistent across restarts:

mysql> SET PERSIST log_error_services = 'log_filter_internal; log_sink_syseventlog';Query OK, 0 rows affected (0.00 sec)mysql> SHOW VARIABLES LIKE 'log_error_services';+--------------------+-------------------------------------------+| Variable_name      | Value                                     |+--------------------+-------------------------------------------+| log_error_services | log_filter_internal; log_sink_syseventlog ...