- 5.7.1.1. Connection Probes
- 5.7.1.2. Command Probes
- 5.7.1.3. Query Probes
- 5.7.1.4. Query Parsing Probes
- 5.7.1.5. Query Cache Probes
- 5.7.1.6. Query Execution Probes
- 5.7.1.7. Row-Level Probes
- 5.7.1.8. Read Row Probes
- 5.7.1.9. Index Probes
- 5.7.1.10. Lock Probes
- 5.7.1.11. Filesort Probes
- 5.7.1.12. Statement Probes
- 5.7.1.13. Network Probes
- 5.7.1.14. Keycache Probes
MySQL supports the following static probes, organized into groups of functionality.
Table 5.13. MySQL DTrace Probes
| Group | Probes | Introduced |
|---|---|---|
| Connection | connection-start, connection-done | 5.4.0 |
| Command | command-start, command-done | 5.4.0 |
| Query | query-start, query-done | 5.4.0 |
| Query Parsing | query-parse-start,
query-parse-done | 5.4.0 |
| Query Cache | query-cache-hit, query-cache-miss | 5.4.0 |
| Query Execution | query-exec-start, query-exec-done | 5.4.0 |
| Row Level | insert-row-start, insert-row-done | 5.4.0 |
update-row-start, update-row-done | 5.4.0 | |
delete-row-start, delete-row-done | 5.4.0 | |
| Row Reads | read-row-start, read-row-done | 5.4.0 |
| Index Reads | index-read-row-start,
index-read-row-done | 5.4.0 |
| Lock | handler-rdlock-start,
handler-rdlock-done | 5.4.0 |
handler-wrlock-start,
handler-wrlock-done | 5.4.0 | |
handler-unlock-start,
handler-unlock-done | 5.4.0 | |
| Filesort | filesort-start, filesort-done | 5.4.0 |
| Statement | select-start, select-done | 5.4.0 |
insert-start, insert-done | 5.4.0 | |
insert-select-start,
insert-select-done | 5.4.0 | |
update-start, update-done | 5.4.0 | |
multi-update-start,
multi-update-done | 5.4.0 | |
delete-start, delete-done | 5.4.0 | |
multi-delete-start,
multi-delete-done | 5.4.0 | |
| Network | net-read-start, net-read-done,
net-write-start,
net-write-done | 5.4.0 |
| 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 | 5.4.0 |
Note
When extracting the argument data from the probes, each argument
is available as
arg, starting
with Narg0. 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