AWS RDS MySQL kill transaction by ID (without thread_id)

Got a transaction ID from SHOW ENGINE INNODB STATUS or a lock-wait report, but no thread ID to pass to KILL? You can still end it. InnoDB already knows which connection owns every open transaction, so the job is one lookup and one procedure call. This is the usual AWS RDS MySQL kill transaction by ID (without thread_id) workflow, plus what to do... Weiterlesen: AWS RDS MySQL kill transaction by ID (without thread_id)