Skip navigation links
5.7.1.1 Connection Probes »
Section Navigation      [Toggle]

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, starting with MySQL 5.4.0.

Table 5.8. 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 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.