MySQL 8 Administrator???s Guide

The error log

This log is used to record diagnostic messages like error, warnings and notes that occur from the startup of MySQL 8 through till its end. MySQL 8 provides various configurations and components for users to generate log files as per their requirements. When we start writing into files some basics questions come to mind; what do we write? How do we write it? Where do we write it to? Let's start with first question. MySQL 8 uses the log_error_verbosity system variable and assigns the below filtering options to decide what type of messages should be written into the error log file:

• Error Only
• Errors and Warnings
• Errors, Warnings and Notes

To write at the destination place MySQL uses the below format where the time stamp depends ...