MySQL Forums
Forum List  »  Delphi

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
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?
Michael Britt
April 14, 2021 05:56PM
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?
Peter Brawley
April 14, 2021 08:02PM
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?
Michael Britt
April 14, 2021 08:37PM


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.