The configuration community:
long_query_time
Information
If a query takes longer than this many seconds the server increments the Slow_queries status variable. If you are using the --log-slow-queries option the query is logged to the slow query log file. This value is measured in real time not CPU time so a query that is under the threshold on a lightly loaded system might be above the threshold on a heavily loaded one. The minimum value is 1. The default is 10.
Syntax
Example



