CODEWITHSUNDEEP
mysqltable-locking
neubert
neubert

Reputation: 16832

unlocking a table that someone else locked

Let's say a coworker does LOCK TABLES table_name and then leaves for the day without unlocking the table. Maybe their computer is locked so you can't just kill the process on their computer. Maybe you could unplug their computer but that might not always be an option.

UNLOCK TABLES only unlocks the tables that you locked. At least so it seems to me. SHOW FULL PROCESSLIST to get the query ID and then killing that query ID wouldn't do the trick either because LOCK TABLES table_name isn't still running.

So short of rebooting the DB server what options exist?

Upvotes: 0

Views: 345

Answers (0)

Related Questions