Is it possible to have MySQL log queries or transactions where lock waits occur? Once can debug specific application errors generated from lock wait timeout errors from the DB but without the ability to see the occurrences of lock waits that don't hit the timeout are occurring, it seems difficult to anticipate where the next timeout error may be lurking.
Is there a way to have MySQL log these?
Aucun commentaire:
Enregistrer un commentaire