MySQL 8 server provides the following different type of logs that enable users to track the activity of the server in various situations:
|
Log type |
Information written to log |
|
Error log |
Problems encountered starting, running, or stopping mysqld |
|
General query log |
Established client connections and statements received from clients |
|
Binary log |
Statements that change data (also used for replication) |
|
Relay log |
Data changes received from a replication master server |
|
Slow query log |
Queries that took more than long_query_time seconds to execute |
|
DDL log (metadata log) |
Metadata operations performed by DDL statements |
You can learn more about the different type of logs at https://dev.mysql.com/doc/refman/8.0/en/server-logs.html.
MySQL 8 will not generate the logs in MySQL 8, except in error logs in Windows, unless we enable...
