5.7.1. mysqld DTrace Probe Reference

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.10. 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 argN, starting with arg0. To identify each argument within the definitions they are provided with a descriptive name, but you must access the information using the corresponding argN parameter.