FM / tracing

/usr/share/doc/bpfcc-tools/examples/tracing/

/usr/share/doc/bpfcc-tools/examples/tracing

Name	Size	Mode	Actions
biolatpcts.py	3312	0755	edit dl rm
biolatpcts_example.txt	650	0644	edit dl rm
bitehist.py	1397	0755	edit dl rm
bitehist_example.txt	1208	0644	edit dl rm
CMakeLists.txt	276	0644	edit dl rm
dddos.py	3818	0755	edit dl rm
dddos_example.txt	2112	0644	edit dl rm
disksnoop.py	1947	0755	edit dl rm
disksnoop_example.txt	1587	0644	edit dl rm
hello_fields.py	679	0755	edit dl rm
hello_perf_output.py	1270	0755	edit dl rm
hello_perf_output_using_ns.py	1843	0755	edit dl rm
kvm_hypercall.py	1520	0755	edit dl rm
kvm_hypercall.txt	1782	0644	edit dl rm
mallocstacks.py	1942	0755	edit dl rm
mysqld_query.py	1701	0755	edit dl rm
mysqld_query_example.txt	499	0644	edit dl rm
nflatency.py	6214	0755	edit dl rm
nodejs_http_server.py	1376	0755	edit dl rm
nodejs_http_server_example.txt	276	0644	edit dl rm
stacksnoop.py	3252	0755	edit dl rm
stacksnoop_example.txt	2871	0644	edit dl rm
stack_buildid_example.py	3106	0755	edit dl rm
strlen_count.py	1331	0755	edit dl rm
strlen_hist.py	1856	0755	edit dl rm
strlen_hist_ifunc.py	3800	0755	edit dl rm
strlen_snoop.py	1384	0755	edit dl rm
sync_timing.py	1390	0755	edit dl rm
task_switch.c	499	0644	edit dl rm
task_switch.py	486	0755	edit dl rm
tcpv4connect.py	2413	0755	edit dl rm
tcpv4connect_example.txt	1063	0644	edit dl rm
trace_fields.py	589	0755	edit dl rm
trace_perf_output.py	1600	0755	edit dl rm
undump.py	3602	0755	edit dl rm
undump_example.txt	886	0644	edit dl rm
urandomread-explicit.py	1511	0755	edit dl rm
urandomread.py	1032	0755	edit dl rm
urandomread_example.txt	675	0644	edit dl rm
vfsreadlat.c	896	0644	edit dl rm
vfsreadlat.py	1336	0755	edit dl rm
vfsreadlat_example.txt	3619	0644	edit dl rm

Edit: /usr/share/doc/bpfcc-tools/examples/tracing/mysqld_query.py (1701B)

#!/usr/bin/python
#
# mysqld_query    Trace MySQL server queries. Example of USDT tracing.
#                 For Linux, uses BCC, BPF. Embedded C.
#
# USAGE: mysqld_query PID
#
# This uses USDT probes, and needs a MySQL server with -DENABLE_DTRACE=1.
#
# Copyright 2016 Netflix, Inc.
# Licensed under the Apache License, Version 2.0 (the "License")

from __future__ import print_function
from bcc import BPF, USDT
from bcc.utils import printb
import sys

if len(sys.argv) < 2:
    print("USAGE: mysqld_latency PID")
    exit()
pid = sys.argv[1]
debug = 0

# load BPF program
bpf_text = """
#include <uapi/linux/ptrace.h>
int do_trace(struct pt_regs *ctx) {
    uint64_t addr;
    char query[128];
    /*
     * Read the first argument from the query-start probe, which is the query.
     * The format of this probe is:
     * query-start(query, connectionid, database, user, host)
     * see: https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-ref-query.html
     */
    bpf_usdt_readarg(1, ctx, &addr);
    bpf_probe_read_user(&query, sizeof(query), (void *)addr);
    bpf_trace_printk("%s\\n", query);
    return 0;
};
"""

# enable USDT probe from given PID
u = USDT(pid=int(pid))
u.enable_probe(probe="query__start", fn_name="do_trace")
if debug:
    print(u.get_text())
    print(bpf_text)

# initialize BPF
b = BPF(text=bpf_text, usdt_contexts=[u])

# header
print("%-18s %-16s %-6s %s" % ("TIME(s)", "COMM", "PID", "QUERY"))

# format output
while 1:
    try:
        (task, pid, cpu, flags, ts, msg) = b.trace_fields()
    except ValueError:
        print("value error")
        continue
    except KeyboardInterrupt:
        exit()
    printb(b"%-18.9f %-16s %-6d %s" % (ts, task, pid, msg))

cmd: