62
62
* add the query string to most other DTrace probes as well. Hostname is
63
63
* either the hostname or the IP address of the Drizzle client.
65
probe query__start(char *query,
65
probe query__start(const char *query,
66
66
unsigned long conn_id,
68
68
probe query__done(int status);
70
70
/* Fire at the start/end of SQL query parsing */
71
probe query__parse__start(char *query);
71
probe query__parse__start(const char *query);
72
72
probe query__parse__done(int status);
75
75
* This probe fires when the actual query execution starts
77
probe query__exec__start(char *query,
77
probe query__exec__start(const char *query,
78
78
unsigned long connid,
80
80
probe query__exec__done(int status);
82
82
/* These probes fire when performing write operations towards any handler */
83
probe insert__row__start(char *db, char *table);
83
probe insert__row__start(const char *db, const char *table);
84
84
probe insert__row__done(int status);
85
probe update__row__start(char *db, char *table);
85
probe update__row__start(const char *db, const char *table);
86
86
probe update__row__done(int status);
87
probe delete__row__start(char *db, char *table);
87
probe delete__row__start(const char *db, const char *table);
88
88
probe delete__row__done(int status);
91
91
* These probes fire when calling external_lock for any handler
92
92
* depending on the lock type being acquired or released.
94
probe handler__rdlock__start(char *db, char *table);
95
probe handler__wrlock__start(char *db, char *table);
96
probe handler__unlock__start(char *db, char *table);
94
probe handler__rdlock__start(const char *db, const char *table);
95
probe handler__wrlock__start(const char *db, const char *table);
96
probe handler__unlock__start(const char *db, const char *table);
97
97
probe handler__rdlock__done(int status);
98
98
probe handler__wrlock__done(int status);
99
99
probe handler__unlock__done(int status);
102
102
* These probes fire when a filesort activity happens in a query.
104
probe filesort__start(char *db, char *table);
104
probe filesort__start(const char *db, const char *table);
105
105
probe filesort__done(int status, unsigned long rows);
107
107
* The query types SELECT, INSERT, INSERT AS SELECT, UPDATE, DELETE
108
108
* are all probed.
109
109
* The start probe always contains the query text.
111
probe select__start(char *query);
111
probe select__start(const char *query);
112
112
probe select__done(int status, unsigned long rows);
113
probe insert__start(char *query);
113
probe insert__start(const char *query);
114
114
probe insert__done(int status, unsigned long rows);
115
probe insert__select__start(char *query);
115
probe insert__select__start(const char *query);
116
116
probe insert__select__done(int status, unsigned long rows);
117
probe update__start(char *query);
117
probe update__start(const char *query);
118
118
probe update__done(int status,
119
119
unsigned long rowsmatches, unsigned long rowschanged);
120
probe delete__start(char *query);
120
probe delete__start(const char *query);
121
121
probe delete__done(int status, unsigned long rows);