Using InnoDB. I've read this article about the InnoDB locking model, but I could not find the answer to this question:
Do MySQL locks expire? If a process grabs a lock, will that process still hold the lock tomorrow?
My use case is what if my program has a rogue thread running, maybe it's killed, maybe it's alive. Is there any guarantee that that the lock will be released...ever?