MySQL Forums
Forum List  »  Delphi

Re: mjbcomp Posts: 2 Joined: Tue 13 Apr 2021 22:45 Contact: Contact mjbcomp Is it possible to find out which user has a ROWLOCK on a table?
Posted by: Peter Brawley
Date: April 14, 2021 08:02PM

select * from performance_schema.data_locks will show the thread_id corresponding to a show processlist ID, and more details are available from show engine innodb status.

Options: ReplyQuote


Subject
Written By
Posted
Re: mjbcomp Posts: 2 Joined: Tue 13 Apr 2021 22:45 Contact: Contact mjbcomp Is it possible to find out which user has a ROWLOCK on a table?
April 14, 2021 08:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.