312-49 · Question #514
Which MySQL log file contains information on server start and stop?
The correct answer is D. Error log file. The MySQL Error Log records critical server events including server startup and shutdown messages, along with errors, warnings, and diagnostic information. It is the primary log to check for server lifecycle events. The General Query Log records all SQL statements received by…
Question
Which MySQL log file contains information on server start and stop?
Options
- ASlow query log file
- BGeneral query log file
- CBinary log
- DError log file
How the community answered
(55 responses)- A7% (4)
- B4% (2)
- C2% (1)
- D87% (48)
Explanation
The MySQL Error Log records critical server events including server startup and shutdown messages, along with errors, warnings, and diagnostic information. It is the primary log to check for server lifecycle events. The General Query Log records all SQL statements received by the server. The Slow Query Log captures queries that exceed a defined execution time threshold. The Binary Log (binlog) records data-changing SQL statements for replication and point-in-time recovery but does not log server start/stop events. For any investigation into when a MySQL server was started or stopped, the Error Log is the correct source.
Topics
Community Discussion
No community discussion yet for this question.