Question

The default value in seconds in the system variable ‘long_query_time’ is ______________

(a) 5

(b) 10

(c) 20

(d) 60

This question was addressed to me during an interview.

This is a very interesting question from Maintaining Logs in section General MySQL Administration of MySQL

Answer 1

Right option is (b) 10

The explanation is: The server maintains a ‘long_query_time’ system variable that defines slow queries (10 seconds by default). If a query takes more than these seconds of real time it is considered slow.