CREATE TABLE t1(id INT PRIMARY KEY,val INT); INSERT INTO t1 VALUES (1,1); BEGIN; SELECT * FROM t1 WHERE id=1 FOR SHARE; id val 1 1 BEGIN; SELECT * FROM t1 FOR UPDATE; COMMIT; id val 1 1 SELECT SQL_TEXT, (LOCK_TIME >= 4900000000000) as locked_5_sec FROM performance_schema.events_statements_current; SQL_TEXT locked_5_sec SELECT SQL_TEXT, (LOCK_TIME >= 4900000000000) as locked_5_sec FROM performance_schema.events_statements_current 0 SELECT * FROM t1 FOR UPDATE 1 COMMIT; SELECT query_sample_text, (SUM_LOCK_TIME >= 4900000000000) as locked_5_sec FROM performance_schema.events_statements_summary_by_digest WHERE query_sample_text LIKE 'SELECT * FROM t1 %'; query_sample_text locked_5_sec SELECT * FROM t1 WHERE id=1 FOR SHARE 0 SELECT * FROM t1 FOR UPDATE 1 DROP TABLE t1;