Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – slow query log includes even queries that are fast because it includes time spent waiting for lock

is there a way to exclude the time spent waiting for the lock so I can see only the queries that are actually expensive?

Tags:

2

Answers


  1. 0

    The slow query log does not count the lock time. It only logs a query if the execution time is at least as great as long_query_time in seconds.

    https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html says:

    The time to acquire the initial locks is not counted as execution time.

    You may have other options enabled that make queries logged even if they are quick. For example log_queries_not_using_indexes.

    Login or Signup to reply.
  2. 0

    Perhaps you have

    log_queries_not_using_indexes = ON

    I recommend OFF

    More tips: SlowLog

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search