5.4.1 mysqld DTrace Probe Reference

5.4.1.1 Connection Probes
5.4.1.2 Command Probes
5.4.1.3 Query Probes
5.4.1.4 Query Parsing Probes
5.4.1.5 Query Cache Probes
5.4.1.6 Query Execution Probes
5.4.1.7 Row-Level Probes
5.4.1.8 Read Row Probes
5.4.1.9 Index Probes
5.4.1.10 Lock Probes
5.4.1.11 Filesort Probes
5.4.1.12 Statement Probes
5.4.1.13 Network Probes
5.4.1.14 Keycache Probes

MySQL supports the following static probes, organized into groups of functionality.

Table 5.6 MySQL DTrace Probes

GroupProbes
Connectionconnection-start, connection-done
Commandcommand-start, command-done
Queryquery-start, query-done
Query Parsingquery-parse-start, query-parse-done
Query Cachequery-cache-hit, query-cache-miss
Query Executionquery-exec-start, query-exec-done
Row Levelinsert-row-start, insert-row-done
 update-row-start, update-row-done
 delete-row-start, delete-row-done
Row Readsread-row-start, read-row-done
Index Readsindex-read-row-start, index-read-row-done
Lockhandler-rdlock-start, handler-rdlock-done
 handler-wrlock-start, handler-wrlock-done
 handler-unlock-start, handler-unlock-done
Filesortfilesort-start, filesort-done
Statementselect-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
Networknet-read-start, net-read-done, net-write-start, net-write-done
Keycachekeycache-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.