5.8.1 mysqld DTrace 探针参考

MySQL 支持以下静态探针,这些探针按功能分组。

table5.6 MySQL DTrace 探针

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

从探测器中提取参数数据时,每个参数都以argN的形式提供,从arg0开始。为了在定义中标识每个自变量,将为它们提供一个描述性名称,但是您必须使用相应的argN参数来访问信息。