| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/std_data/ |
Upload File : |
/*
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);
}