5.8.1 mysqld DTrace Probe Reference
- 5.8.1.1 Connection Probes
- 5.8.1.2 Command Probes
- 5.8.1.3 Query Probes
- 5.8.1.4 Query Parsing Probes
- 5.8.1.5 Query Cache Probes
- 5.8.1.6 Query Execution Probes
- 5.8.1.7 Row-Level Probes
- 5.8.1.8 Read Row Probes
- 5.8.1.9 Index Probes
- 5.8.1.10 Lock Probes
- 5.8.1.11 Filesort Probes
- 5.8.1.12 Statement Probes
- 5.8.1.13 Network Probes
- 5.8.1.14 Keycache Probes
MySQL supports the following static probes, organized into groups of functionality.
Table 5.6 MySQL DTrace Probes
Group | Probes |
---|---|
Connection | connection-start , connection-done |
Command | command-start , command-done |
Query | query-start , query-done |
Query Parsing | query-parse-start , query-parse-done |
Query Cache | query-cache-hit , query-cache-miss |
Query Execution | query-exec-start , query-exec-done |
Row Level | insert-row-start , insert-row-done |
update-row-start , update-row-done |
|
delete-row-start , delete-row-done |
|
Row Reads | read-row-start , read-row-done |
Index Reads | index-read-row-start , index-read-row-done |
Lock | handler-rdlock-start , handler-rdlock-done |
handler-wrlock-start , handler-wrlock-done |
|
handler-unlock-start , handler-unlock-done |
|
Filesort | filesort-start , filesort-done |
Statement | select-start , select-done |
insert-start , insert-done |
|
insert-select-start , insert-select-done |
|
update-start , update-done |
|
multi-update-start , multi-update-done |
|
delete-start , delete-done |
|
multi-delete-start , multi-delete-done |
|
Network | net-read-start , net-read-done , net-write-start , net-write-done |
Keycache | keycache-read-start , keycache-read-block , keycache-read-done , keycache-read-hit , keycache-read-miss , keycache-write-start , keycache-write-block , keycache-write-done |
Note
When extracting the argument data from the probes, each argument is available as arg
, starting with N
arg0
. To identify each argument within the definitions they are provided with a descriptive name, but you must access the information using the corresponding arg
parameter. N