Examine these my.cnf settings: Examine this entry from /data/slow.log Which option is also set in my.cnf?

Question

Exhibit

Options

• Alog_queries_not_using_indexes
• Blog__slow_admin_statements=1
• Clog_queries_not_using_indexes=ON
• Dlog_throttle_queries_not_using_indexes=100

• A
  3% (1)
• B
  74% (29)
• C
  15% (6)
• D
  8% (3)

Explanation

Option B is correct because log_slow_admin_statements=1 is the properly formed my.cnf directive that would also appear reflected in the slow log header, which mysqld writes at startup to record active options - matching what the slow.log entry displays. The =1 syntax is the standard integer/boolean form used in my.cnf to enable this option, which causes administrative commands (ALTER TABLE, ANALYZE TABLE, etc.) to be written to the slow query log.

Option A is wrong because log_queries_not_using_indexes has no assignment operator or value - it's an incomplete directive and not valid my.cnf syntax on its own. Option C is wrong because while =ON is a valid MySQL syntax, the variable shown (log_queries_not_using_indexes) is a different variable from what the slow log entry reflects, making it a mismatch. Option D is wrong for the same reason - log_throttle_queries_not_using_indexes=100 is an entirely separate variable controlling rate-limiting, not what the slow log entry references.

Memory tip: Think of the slow log header as mysqld's "startup receipt" - it prints what options it was given. Match the variable name and value format exactly to my.cnf; if the name or value differs from what's in the log entry, it's a distractor.

No community discussion yet for this question.