1 Answer
- Newest
- Most votes
- Most comments
0
marcoborges wrote:
Hi.we have the Mysql database with Saas in AWS and I need to know how I do an alert that after a 1minute alarm to me from email with the deadlock?
Currently there is no support for for lock alerts.
For deadlocks the engine should detect them and cancel one of the transactions.
For lock waits , something like the following can be run.
SELECT trx_id,
trx_state,
trx_wait_started,
trx_requested_lock_id,
time_to_sec(timediff(now(),trx_started)) AS time_in_state,
lock_type,
lock_table,
lock_index,
lock_data
FROM information_schema.innodb_trx
LEFT JOIN information_schema.innodb_locks
ON trx_requested_lock_id=lock_id;
Kyle
answered 3 years ago
Relevant content
- Accepted Answerasked 10 months ago
- asked 2 years ago
- asked 10 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 11 days ago