Q799
The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .
A.
error log
B.
general query
C.
slow query log
AnswerD.
binary log
Answer: Option C
Solution
Answer: Option C
Solution:
This question is about different types of logs in MySQL. These logs help us understand what's happening in our database and how to improve its performance.Let's break down the options:
Option A: error log - This log records errors that happen in MySQL. It's helpful for debugging problems, but it doesn't specifically target performance issues.
Option B: general query log - This log keeps track of every query that runs in MySQL. It's very detailed but can be overwhelming for large datasets. It doesn't focus on performance issues either.
Option C: slow query log - This is the key! The slow query log records queries that took longer than a certain time to execute. This log helps identify statements that might be causing performance bottlenecks, giving us a clear target for optimization.
Option D: binary log - This log records changes to your database, mainly for replication and recovery purposes. While important, it doesn't directly identify performance issues.
Therefore, the correct answer is Option C: slow query log.