/usr/lib/mysql-testsuite/std_data/dtrace.d 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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 | /*
This Dtrace script is used by the test "dynamic_tracing.test" for
dynamic tracing. This script is executed in background by
"dynamic_tracing.test" and SQL queries are executed concurrently. When
any probe used in this script are hit then counter is incremented. After
hitting all the 8(exp_probe_hits) probes, summary containing probes enabled
and their hit state is printed.
*/
#pragma D option quiet
short query_parse_start;
short query_parse_done;
short select_start;
short select_done;
short net_read_start;
short net_read_done;
short handler_rdlock_start;
short handler_rdlock_done;
short tot_probe_hits;
short exp_probe_hits;
BEGIN
{
query_parse_start= 0;
query_parse_done= 0;
select_start= 0;
select_done= 0;
net_read_start= 0;
net_read_done= 0;
handler_rdlock_start= 0;
handler_rdlock_done= 0;
tot_probe_hits= 0;
exp_probe_hits= 8;
printf("\n Dynamic tracing ...... started.\n");
}
mysql*:::query-parse-start
/query_parse_start == 0/
{
query_parse_start++;
tot_probe_hits++;
}
mysql*:::query-parse-done
/query_parse_done == 0/
{
query_parse_done++;
tot_probe_hits++;
}
mysql*:::select-start
/select_start == 0/
{
select_start++;
tot_probe_hits++;
}
mysql*:::select-done
/select_done == 0/
{
select_done++;
tot_probe_hits++;
}
mysql*:::net-read-start
/net_read_start == 0/
{
net_read_start++;
tot_probe_hits++;
}
mysql*:::net-read-done
/net_read_done == 0/
{
net_read_done++;
tot_probe_hits++;
}
mysql*:::handler-rdlock-start
/handler_rdlock_start == 0/
{
handler_rdlock_start++;
tot_probe_hits++;
}
mysql*:::handler-rdlock-done
/handler_rdlock_done == 0/
{
handler_rdlock_done++;
tot_probe_hits++;
}
mysql*:::query-parse-start,
mysql*:::query-parse-done,
mysql*:::select-start,
mysql*:::select-done,
mysql*:::net-read-start,
mysql*:::net-read-done,
mysql*:::handler-rdlock-start,
mysql*:::handler-rdlock-done
/tot_probe_hits >= exp_probe_hits/
{
printf("\n query-parse-start : %d", query_parse_start);
printf("\n query-parse-done : %d", query_parse_done);
printf("\n select-start : %d", select_start);
printf("\n select-done : %d", select_done);
printf("\n net-read-start : %d", net_read_start);
printf("\n net-read-done : %d", net_read_done);
printf("\n handler_rdlock_start : %d", handler_rdlock_start);
printf("\n handler_rdlock_done : %d", handler_rdlock_done);
printf("\n");
printf("\n Expected probe hits : %d", exp_probe_hits);
printf("\n Actual probe hits : %d\n", tot_probe_hits);
printf("\n Dynamic tracing ...... completed.\n");
exit(0);
}
|