LOG_QUERY_TIME_THRESHOLD

The LOG_QUERY_TIME_THRESHOLD variable enables you to log database requests at INFO level if they run longer than a given period.

By default, database requests are logged at DEBUG level. Configuring a value for LOG_QUERY_TIME_THRESHOLD causes requests that run for a period greater than that value to be logged at the INFO level, which makes them show up in vamessages.log.

Set the value to zero to log all database queries at INFO.

Values

Integer (in milliseconds)

Default

1000