/usr/lib/mysql-testsuite/r/dynamic_tracing.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | CREATE PROCEDURE create_table_and_insert_rows()
BEGIN
DECLARE count INT;
SET count = 1;
SELECT SLEEP(10);
CREATE TABLE t1 (f1 INT);
INSERT INTO t1 VALUES (7894);
WHILE count <= 5 DO
INSERT INTO t1 SELECT * FROM t1;
SET count = count + 1;
END WHILE;
SET count = 1;
WHILE count <= 10000 DO
SELECT SQL_NO_CACHE count(*) from t1;
SET count = count + 1;
END WHILE;
END
$
CALL create_table_and_insert_rows();
SELECT SLEEP(4);
Dynamic tracing ...... started.
query-parse-start : 1
query-parse-done : 1
select-start : 1
select-done : 1
net-read-start : 1
net-read-done : 1
handler_rdlock_start : 1
handler_rdlock_done : 1
Expected probe hits : 8
Actual probe hits : 8
Dynamic tracing ...... completed.
DROP TABLE t1;
DROP PROCEDURE create_table_and_insert_rows;
|