O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing the error log

As per the MySQL documentation:

The error log contains a record of mysqld startup and shutdown times. It also contains diagnostic messages such as errors, warnings, and notes that occur during server startup and shutdown, and while the server is running.

The error log subsystem consists of components that perform log event filtering and writing, as well as a system variable called log_error_services that configures which components to enable to achieve the desired logging result. The default value of global.log_error_services is log_filter_internal; log_sink_internal:

mysql> SELECT @@global.log_error_services;+----------------------------------------+| @@global.log_error_services            |+----------------------------------------+ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required