FileMgr

✏️ /usr/share/doc/bpfcc-tools/examples/doc/dbstat_example.txt

✕ Tutup

Demonstrations of dbstat, the Linux eBPF/bcc version.

dbstat traces queries performed by a MySQL or PostgreSQL database process, and
displays a histogram of query latencies. For example:

# dbstat mysql
Tracing database queries for pids 25776 slower than 0 ms...
     query latency (ms)  : count     distribution
         0 -> 1          : 990      |****************************************|
         2 -> 3          : 7        |                                        |
         4 -> 7          : 0        |                                        |
         8 -> 15         : 0        |                                        |
        16 -> 31         : 0        |                                        |
        32 -> 63         : 0        |                                        |
        64 -> 127        : 0        |                                        |
       128 -> 255        : 0        |                                        |
       256 -> 511        : 0        |                                        |
       512 -> 1023       : 0        |                                        |
      1024 -> 2047       : 2        |                                        |
^C

It's immediately evident that the vast majority of queries finish very quickly,
in under 1ms, but there are some super-slow queries occasionally, in the 1-2
seconds bucket.

We can filter out the shorter queries with the -m switch:

# dbstat mysql -m 1000
Tracing database queries for pids 25776 slower than 1000 ms...
     query latency (ms)  : count     distribution
         0 -> 1          : 0        |                                        |
         2 -> 3          : 0        |                                        |
         4 -> 7          : 0        |                                        |
         8 -> 15         : 0        |                                        |
        16 -> 31         : 0        |                                        |
        32 -> 63         : 0        |                                        |
        64 -> 127        : 0        |                                        |
       128 -> 255        : 0        |                                        |
       256 -> 511        : 0        |                                        |
       512 -> 1023       : 0        |                                        |
      1024 -> 2047       : 8        |****************************************|
^C

By default, dbstat will try to detect mysqld and postgres processes, but if
necessary, you can specify the process ids with the -p switch. Here, the -i
switch is also used to request histograms at 3 second intervals:

# dbstat mysql -p $(pidof mysql) -i 3
Tracing database queries for pids 25776 slower than 0 ms...
[06:14:36]
     query latency (ms)  : count     distribution
         0 -> 1          : 758      |****************************************|
         2 -> 3          : 1        |                                        |
         4 -> 7          : 0        |                                        |
         8 -> 15         : 0        |                                        |
        16 -> 31         : 0        |                                        |
        32 -> 63         : 0        |                                        |
        64 -> 127        : 0        |                                        |
       128 -> 255        : 0        |                                        |
       256 -> 511        : 0        |                                        |
       512 -> 1023       : 0        |                                        |
      1024 -> 2047       : 1        |                                        |

[06:14:39]
     query latency (ms)  : count     distribution
         0 -> 1          : 436      |****************************************|
         2 -> 3          : 2        |                                        |
         4 -> 7          : 0        |                                        |
         8 -> 15         : 0        |                                        |
        16 -> 31         : 0        |                                        |
        32 -> 63         : 0        |                                        |
        64 -> 127        : 0        |                                        |
       128 -> 255        : 0        |                                        |
       256 -> 511        : 0        |                                        |
       512 -> 1023       : 0        |                                        |
      1024 -> 2047       : 1        |                                        |

[06:14:42]
     query latency (ms)  : count     distribution
         0 -> 1          : 399      |****************************************|
         2 -> 3          : 0        |                                        |
         4 -> 7          : 0        |                                        |
         8 -> 15         : 0        |                                        |
        16 -> 31         : 0        |                                        |
        32 -> 63         : 0        |                                        |
        64 -> 127        : 0        |                                        |
       128 -> 255        : 0        |                                        |
       256 -> 511        : 0        |                                        |
       512 -> 1023       : 0        |                                        |
      1024 -> 2047       : 1        |                                        |
^C

USAGE:
# dbstat -h
usage: dbstat.py [-h] [-v] [-p [PID [PID ...]]] [-m THRESHOLD] [-u]
                 [-i INTERVAL]
                 {mysql,postgres}

positional arguments:
  {mysql,postgres}      the database engine to use

optional arguments:
  -h, --help            show this help message and exit
  -v, --verbose         print the BPF program
  -p [PID [PID ...]], --pid [PID [PID ...]]
                        the pid(s) to trace
  -m THRESHOLD, --threshold THRESHOLD
                        trace queries slower than this threshold (ms)
  -u, --microseconds    display query latencies in microseconds (default:
                        milliseconds)
  -i INTERVAL, --interval INTERVAL
                        print summary at this interval (seconds)

dbstat postgres     # display a histogram of PostgreSQL query latencies
    dbstat mysql -v     # display MySQL latencies and print the BPF program
    dbstat mysql -u     # display query latencies in microseconds (default: ms)
    dbstat mysql -m 5   # trace only queries slower than 5ms
    dbstat mysql -p 408 # trace queries in a specific process

Batal

⬅ examples 132 item

Nama	Tipe	Ukuran	Diubah	Perm	Aksi
📁 lib	dir	—	15/06/26 13:45	0755	📂
📝 argdist_example.txt	txt	22.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 bashreadline_example.txt	txt	882 B	08/12/23 15:36	0644	✏️ ⬇
📝 bindsnoop_example.txt	txt	4.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 biolatency_example.txt	txt	23.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 biolatpcts_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 biopattern_example.txt	txt	1.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 biosnoop_example.txt	txt	3.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 biotop_example.txt	txt	9.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 bitesize_example.txt	txt	5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 bpflist_example.txt	txt	2.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 btrfsdist_example.txt	txt	9.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 btrfsslower_example.txt	txt	6.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cachestat_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cachetop_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 capable_example.txt	txt	6.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cobjnew_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 compactsnoop_example.txt	txt	9.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cpudist_example.txt	txt	16.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cpuunclaimed_example.txt	txt	15.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 criticalstat_example.txt	txt	4.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 cthreads_example.txt	txt	2.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 dbslower_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 dbstat_example.txt	txt	6.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 dcsnoop_example.txt	txt	4.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 dcstat_example.txt	txt	3.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 deadlock_example.txt	txt	16.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 dirtop_example.txt	txt	5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 drsnoop_example.txt	txt	5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 execsnoop_example.txt	txt	6.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 exitsnoop_example.txt	txt	6.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 ext4dist_example.txt	txt	8.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 ext4slower_example.txt	txt	11.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 filegone_example.txt	txt	743 B	08/12/23 15:36	0644	✏️ ⬇
📝 filelife_example.txt	txt	2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 fileslower_example.txt	txt	5.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 filetop_example.txt	txt	6.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 funccount_example.txt	txt	13.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 funcinterval_example.txt	txt	15.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 funclatency_example.txt	txt	21 KB	08/12/23 15:36	0644	✏️ ⬇
📝 funcslower_example.txt	txt	6.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 gethostlatency_example.txt	txt	1.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 hardirqs_example.txt	txt	37 KB	08/12/23 15:36	0644	✏️ ⬇
📝 inject_example.txt	txt	6.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javacalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javaflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javagc_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javaobjnew_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javastat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 javathreads_example.txt	txt	2.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 killsnoop_example.txt	txt	1.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 klockstat_example.txt	txt	8.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 kvmexit_example.txt	txt	11.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 llcstat_example.txt	txt	3.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 mdflush_example.txt	txt	1.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 memleak_example.txt	txt	10 KB	08/12/23 15:36	0644	✏️ ⬇
📝 mountsnoop_example.txt	txt	1.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 mysqld_qslower_example.txt	txt	2.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 netqtop_example.txt	txt	12.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 nfsdist_example.txt	txt	8.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 nfsslower_example.txt	txt	7.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 nodegc_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 nodestat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 offcputime_example.txt	txt	19.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 offwaketime_example.txt	txt	37.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 oomkill_example.txt	txt	1.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 opensnoop_example.txt	txt	10.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 perlcalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 perlflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 perlstat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 phpcalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 phpflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 phpstat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 pidpersec_example.txt	txt	677 B	08/12/23 15:36	0644	✏️ ⬇
📝 ppchcalls_example.txt	txt	6.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 profile_example.txt	txt	31.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 pythoncalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 pythonflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 pythongc_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 pythonstat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rdmaucma_example.txt	txt	1.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 readahead_example.txt	txt	3.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 reset-trace_example.txt	txt	9.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rubycalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rubyflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rubygc_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rubyobjnew_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 rubystat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 runqlat_example.txt	txt	31.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 runqlen_example.txt	txt	11.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 runqslower_example.txt	txt	2.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 shmsnoop_example.txt	txt	2.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 slabratetop_example.txt	txt	5.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 sofdsnoop_example.txt	txt	3.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 softirqs_example.txt	txt	11 KB	08/12/23 15:36	0644	✏️ ⬇
📝 solisten_example.txt	txt	2.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 sslsniff_example.txt	txt	6.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 stackcount_example.txt	txt	21.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 statsnoop_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 swapin.txt	txt	2.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 swapin_example.txt	txt	1.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 syncsnoop_example.txt	txt	387 B	08/12/23 15:36	0644	✏️ ⬇
📝 syscount_example.txt	txt	6.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tclcalls_example.txt	txt	3.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tclflow_example.txt	txt	5.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tclobjnew_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tclstat_example.txt	txt	3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpaccept_example.txt	txt	2.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpcong_example.txt	txt	33.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpconnect_example.txt	txt	6.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpconnlat_example.txt	txt	2.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpdrop_example.txt	txt	2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcplife_example.txt	txt	6.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpretrans_example.txt	txt	3.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcprtt_example.txt	txt	9.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpstates_example.txt	txt	2.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpsubnet_example.txt	txt	5.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcpsynbl_example.txt	txt	1.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcptop_example.txt	txt	5.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tcptracer_example.txt	txt	2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 threadsnoop_example.txt	txt	1.1 KB	08/12/23 15:36	0644	✏️ ⬇
📝 tplist_example.txt	txt	4.4 KB	08/12/23 15:36	0644	✏️ ⬇
📝 trace_example.txt	txt	21.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 ttysnoop_example.txt	txt	3.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 vfscount_example.txt	txt	2.2 KB	08/12/23 15:36	0644	✏️ ⬇
📝 vfsstat_example.txt	txt	1.7 KB	08/12/23 15:36	0644	✏️ ⬇
📝 virtiostat_example.txt	txt	2.6 KB	08/12/23 15:36	0644	✏️ ⬇
📝 wakeuptime_example.txt	txt	33.3 KB	08/12/23 15:36	0644	✏️ ⬇
📝 xfsdist_example.txt	txt	6.8 KB	08/12/23 15:36	0644	✏️ ⬇
📝 xfsslower_example.txt	txt	6.9 KB	08/12/23 15:36	0644	✏️ ⬇
📝 zfsdist_example.txt	txt	9.5 KB	08/12/23 15:36	0644	✏️ ⬇
📝 zfsslower_example.txt	txt	7.4 KB	08/12/23 15:36	0644	✏️ ⬇

✏️ Rename

🔑 Ubah Permission