Question

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

(d) binary log

The question was posed to me during an internship interview.

The origin of the question is Maintaining Logs in section General MySQL Administration of MySQL

Answer 1

Correct choice is (c) slow query log

Easiest explanation: The purpose of the slow-query log is to help the identification of statements that may be in need of being rewritten for better performance. This helps in query optimizations.