MySQL produces a number of different types of logs For this

MySQL produces a number of different types of logs. For this discussion, pick one or two of the different server logs and describe their function in the database architecture.

Solution

There are several logs which are produced by MySQL. Namely:

1. The Error Log

2. The General Query Log

3. The Binary Log

4. The Slow Query Log

5. The DDL Log

By default only Error log is enabled.

Below are the descriptions for a few:

The Error Log: Error logs contains all the information about MySQL, like when it was started, stooped and all the critical errors that occured while server was running. If mysql notices a table that needs to be automatically checked or repaired, it writes a message to the error log.

General Query Log: The general query log keeps a general record of what all is going in mysql. The server writes information to this log when users connect or disconnect, and it logs each SQL statement received from users. The general query log can be very useful when you suspect anything wrong in the SQL queries sent from users and want to know exactly what the user sent to mysql.