Spec-Zone .ru
спецификации, руководства, описания, API

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.