mirror of
https://github.com/MariaDB/server.git
synced 2025-01-15 19:42:28 +01:00
177 lines
7.3 KiB
Text
177 lines
7.3 KiB
Text
/* Copyright (c) 2008, 2009 Sun Microsystems, Inc.
|
|
Use is subject to license terms.
|
|
|
|
This program is free software; you can redistribute it and/or modify
|
|
it under the terms of the GNU General Public License as published by
|
|
the Free Software Foundation; version 2 of the License.
|
|
|
|
This program is distributed in the hope that it will be useful,
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
GNU General Public License for more details.
|
|
|
|
You should have received a copy of the GNU General Public License
|
|
along with this program; if not, write to the Free Software
|
|
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA */
|
|
|
|
/*
|
|
The actual probe names in DTrace scripts will replace '__' by '-'. Thus
|
|
insert__row__start will be insert-row-start.
|
|
|
|
Recommendations for adding new probes:
|
|
|
|
- each probe should have the minimal set of arguments required to
|
|
unambiguously identify the context in which the probe fires. Redundant
|
|
arguments (i.e. the ones that can be obtained in user scripts from previous
|
|
probes' arguments or otherwise) may be added for convenience.
|
|
|
|
- try to avoid computationally expensive probe arguments. If impossible,
|
|
use *_ENABLED() macros to check if the probe is activated before
|
|
performing expensive calculations for a probe argument.
|
|
|
|
- all *-done probes should have a status argument wherever applicable to make
|
|
it possible for user scripts to figure out whether the completed operation
|
|
was successful or not.
|
|
|
|
- for all status arguments, a non-zero value should be returned on error or
|
|
failure, 0 should be returned on success.
|
|
*/
|
|
|
|
provider mysql {
|
|
|
|
/* The following ones fire when creating or closing a client connection */
|
|
probe connection__start(unsigned long conn_id, char *user, char *host);
|
|
probe connection__done(int status, unsigned long conn_id);
|
|
|
|
/*
|
|
Fire at the start/end of any client command processing (including SQL
|
|
queries).
|
|
*/
|
|
probe command__start(unsigned long conn_id, int command,
|
|
char *user, char *host);
|
|
probe command__done(int status);
|
|
|
|
/*
|
|
The following probes fire at the start/end of any SQL query processing,
|
|
respectively.
|
|
|
|
query_start() has a lot of parameters that can be used to pick up
|
|
parameters for a lot of other probes here. For simplicity reasons we also
|
|
add the query string to most other DTrace probes as well. Hostname is
|
|
either the hostname or the IP address of the MySQL Client.
|
|
*/
|
|
probe query__start(char *query,
|
|
unsigned long conn_id,
|
|
char *db_name,
|
|
char *user,
|
|
char *host);
|
|
probe query__done(int status);
|
|
|
|
/* Fire at the start/end of SQL query parsing */
|
|
probe query__parse__start(char *query);
|
|
probe query__parse__done(int status);
|
|
|
|
/* Track whether the query hits the query cache or not */
|
|
probe query__cache__hit(char *query, unsigned long rows);
|
|
probe query__cache__miss(char *query);
|
|
|
|
/*
|
|
This probe fires when the actual query execution starts, i.e. after
|
|
parsing and checking the query cache, but before privilege checks,
|
|
optimizing, etc.
|
|
|
|
Query means also all independent queries of a stored procedure and prepared
|
|
statements. Also the stored procedure itself is a query.
|
|
|
|
exec_type is:
|
|
0: Executed query from sql_parse, top-level query (sql_parse.cc)
|
|
1: Executed prepared statement (sql_prepare.cc)
|
|
2: Executed cursor statement (sql_cursor.cc)
|
|
3: Executed query in stored procedure (sp_head.cc)
|
|
*/
|
|
probe query__exec__start(char *query,
|
|
unsigned long connid,
|
|
char *db_name,
|
|
char *user,
|
|
char *host,
|
|
int exec_type);
|
|
probe query__exec__done(int status);
|
|
|
|
/* These probes fire when performing row operations towards any handler */
|
|
probe insert__row__start(char *db, char *table);
|
|
probe insert__row__done(int status);
|
|
probe update__row__start(char *db, char *table);
|
|
probe update__row__done(int status);
|
|
probe delete__row__start(char *db, char *table);
|
|
probe delete__row__done(int status);
|
|
probe read__row__start(char *db, char *table, int scan_flag);
|
|
probe read__row__done(int status);
|
|
probe index__read__row__start(char *db, char *table);
|
|
probe index__read__row__done(int status);
|
|
|
|
/*
|
|
These probes fire when calling external_lock for any handler
|
|
depending on the lock type being acquired or released.
|
|
*/
|
|
probe handler__rdlock__start(char *db, char *table);
|
|
probe handler__wrlock__start(char *db, char *table);
|
|
probe handler__unlock__start(char *db, char *table);
|
|
probe handler__rdlock__done(int status);
|
|
probe handler__wrlock__done(int status);
|
|
probe handler__unlock__done(int status);
|
|
|
|
/*
|
|
These probes fire when a filesort activity happens in a query.
|
|
*/
|
|
probe filesort__start(char *db, char *table);
|
|
probe filesort__done(int status, unsigned long rows);
|
|
/*
|
|
The query types SELECT, INSERT, INSERT AS SELECT, UPDATE, UPDATE with
|
|
multiple tables, DELETE, DELETE with multiple tables are all probed.
|
|
The start probe always contains the query text.
|
|
*/
|
|
probe select__start(char *query);
|
|
probe select__done(int status, unsigned long rows);
|
|
probe insert__start(char *query);
|
|
probe insert__done(int status, unsigned long rows);
|
|
probe insert__select__start(char *query);
|
|
probe insert__select__done(int status, unsigned long rows);
|
|
probe update__start(char *query);
|
|
probe update__done(int status,
|
|
unsigned long rowsmatches, unsigned long rowschanged);
|
|
probe multi__update__start(char *query);
|
|
probe multi__update__done(int status,
|
|
unsigned long rowsmatches,
|
|
unsigned long rowschanged);
|
|
probe delete__start(char *query);
|
|
probe delete__done(int status, unsigned long rows);
|
|
probe multi__delete__start(char *query);
|
|
probe multi__delete__done(int status, unsigned long rows);
|
|
|
|
/*
|
|
These probes can be used to measure the time waiting for network traffic
|
|
or identify network-related problems.
|
|
*/
|
|
probe net__read__start();
|
|
probe net__read__done(int status, unsigned long bytes);
|
|
probe net__write__start(unsigned long bytes);
|
|
probe net__write__done(int status);
|
|
|
|
/* MyISAM Key cache probes */
|
|
probe keycache__read__start(char *filepath, unsigned long bytes,
|
|
unsigned long mem_used, unsigned long mem_free);
|
|
probe keycache__read__block(unsigned long bytes);
|
|
probe keycache__read__hit();
|
|
probe keycache__read__miss();
|
|
probe keycache__read__done(unsigned long mem_used, unsigned long mem_free);
|
|
probe keycache__write__start(char *filepath, unsigned long bytes,
|
|
unsigned long mem_used, unsigned long mem_free);
|
|
probe keycache__write__block(unsigned long bytes);
|
|
probe keycache__write__done(unsigned long mem_used, unsigned long mem_free);
|
|
};
|
|
|
|
#pragma D attributes Evolving/Evolving/Common provider mysql provider
|
|
#pragma D attributes Evolving/Evolving/Common provider mysql module
|
|
#pragma D attributes Evolving/Evolving/Common provider mysql function
|
|
#pragma D attributes Evolving/Evolving/Common provider mysql name
|
|
#pragma D attributes Evolving/Evolving/Common provider mysql args
|