[+/-]
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 |
When extracting the argument data from the probes, each argument
is available as
arg
, starting
with N
arg0
. 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
User Comments
Add your own comment.