Debian Codegraph @

mysql-test/suite/perfschema/r/stmt_lock_time.result

raw
1 CREATE TABLE t1(id INT PRIMARY KEY,val INT);
2 INSERT INTO t1 VALUES (1,1);
3 BEGIN;
4 SELECT * FROM t1 WHERE id=1 FOR SHARE;
5 id val
6 1 1
7 BEGIN;
8 SELECT * FROM t1 FOR UPDATE;
9 COMMIT;
10 id val
11 1 1
12 SELECT SQL_TEXT, (LOCK_TIME >= 4900000000000) as locked_5_sec
13 FROM performance_schema.events_statements_current;
14 SQL_TEXT locked_5_sec
15 SELECT SQL_TEXT, (LOCK_TIME >= 4900000000000) as locked_5_sec
16 FROM performance_schema.events_statements_current 0
17 SELECT * FROM t1 FOR UPDATE 1
18 COMMIT;
19 SELECT query_sample_text, (SUM_LOCK_TIME >= 4900000000000) as locked_5_sec
20 FROM performance_schema.events_statements_summary_by_digest
21 WHERE query_sample_text LIKE 'SELECT * FROM t1 %';
22 query_sample_text locked_5_sec
23 SELECT * FROM t1 WHERE id=1 FOR SHARE 0
24 SELECT * FROM t1 FOR UPDATE 1
25 DROP TABLE t1;