MySQL 8.0.31
Source Code Documentation
psi_statement_service.h
Go to the documentation of this file.
1/* Copyright (c) 2017, 2022, Oracle and/or its affiliates.
2
3This program is free software; you can redistribute it and/or modify
4it under the terms of the GNU General Public License, version 2.0,
5as published by the Free Software Foundation.
6
7This program is also distributed with certain software (including
8but not limited to OpenSSL) that is licensed under separate terms,
9as designated in a particular file or component or in included license
10documentation. The authors of MySQL hereby grant you an additional
11permission to link the program and your derivative works with the
12separately licensed software that they have included with MySQL.
13
14This program is distributed in the hope that it will be useful,
15but WITHOUT ANY WARRANTY; without even the implied warranty of
16MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17GNU General Public License, version 2.0, for more details.
18
19You should have received a copy of the GNU General Public License
20along with this program; if not, write to the Free Software
21Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22
23#ifndef COMPONENTS_SERVICES_PSI_STATEMENT_SERVICE_H
24#define COMPONENTS_SERVICES_PSI_STATEMENT_SERVICE_H
25
28
29/*
30 Version 1.
31 Introduced in MySQL 8.0.3
32 Deprecated in MySQL 8.0.14
33 Obsoleted in MySQL 8.0.31
34 Status: Obsolete, use version 4 instead.
35*/
36
37/*
38 Version 2.
39 Introduced in MySQL 8.0.14
40 Deprecated in MySQL 8.0.28
41 Obsoleted in MySQL 8.0.31
42 Status: Obsolete, use version 4 instead.
43*/
44
45/*
46 Version 3.
47 Introduced in MySQL 8.0.28
48 Obsoleted in MySQL 8.0.31
49 Status: Obsolete, use version 4 instead.
50*/
51
52/*
53 Version 4.
54 Introduced in MySQL 8.0.31
55 Status: active
56 Changes compared to version 3:
57 - get_thread_statement_locker_v4_t,
58 the state structure is bigger.
59*/
60BEGIN_SERVICE_DEFINITION(psi_statement_v4)
61/** @sa register_statement_v1_t. */
62register_statement_v1_t register_statement;
63/** @sa get_thread_statement_locker_v1_t. */
64get_thread_statement_locker_v4_t get_thread_statement_locker;
65/** @sa refine_statement_v1_t. */
66refine_statement_v1_t refine_statement;
67/** @sa start_statement_v1_t. */
68start_statement_v1_t start_statement;
69/** @sa set_statement_text_v1_t. */
70set_statement_text_v1_t set_statement_text;
71/** @sa set_statement_query_id_t. */
72set_statement_query_id_t set_statement_query_id;
73/** @sa set_statement_lock_time_t. */
74set_statement_lock_time_t set_statement_lock_time;
75/** @sa set_statement_rows_sent_t. */
76set_statement_rows_sent_t set_statement_rows_sent;
77/** @sa set_statement_rows_examined_t. */
78set_statement_rows_examined_t set_statement_rows_examined;
79/** @sa inc_statement_created_tmp_disk_tables. */
80inc_statement_created_tmp_disk_tables_t inc_statement_created_tmp_disk_tables;
81/** @sa inc_statement_created_tmp_tables. */
82inc_statement_created_tmp_tables_t inc_statement_created_tmp_tables;
83/** @sa inc_statement_select_full_join. */
84inc_statement_select_full_join_t inc_statement_select_full_join;
85/** @sa inc_statement_select_full_range_join. */
86inc_statement_select_full_range_join_t inc_statement_select_full_range_join;
87/** @sa inc_statement_select_range. */
88inc_statement_select_range_t inc_statement_select_range;
89/** @sa inc_statement_select_range_check. */
90inc_statement_select_range_check_t inc_statement_select_range_check;
91/** @sa inc_statement_select_scan. */
92inc_statement_select_scan_t inc_statement_select_scan;
93/** @sa inc_statement_sort_merge_passes. */
94inc_statement_sort_merge_passes_t inc_statement_sort_merge_passes;
95/** @sa inc_statement_sort_range. */
96inc_statement_sort_range_t inc_statement_sort_range;
97/** @sa inc_statement_sort_rows. */
98inc_statement_sort_rows_t inc_statement_sort_rows;
99/** @sa inc_statement_sort_scan. */
100inc_statement_sort_scan_t inc_statement_sort_scan;
101/** @sa set_statement_no_index_used. */
102set_statement_no_index_used_t set_statement_no_index_used;
103/** @sa set_statement_no_good_index_used. */
104set_statement_no_good_index_used_t set_statement_no_good_index_used;
105/** @sa set_statement_secondary_engine_v3_t. */
106set_statement_secondary_engine_v3_t set_statement_secondary_engine;
107/** @sa end_statement_v1_t. */
108end_statement_v1_t end_statement;
109
110/** @sa create_prepared_stmt_v1_t. */
112/** @sa destroy_prepared_stmt_v1_t. */
113destroy_prepared_stmt_v1_t destroy_prepared_stmt;
114/** @sa reprepare_prepared_stmt_v1_t. */
115reprepare_prepared_stmt_v1_t reprepare_prepared_stmt;
116/** @sa execute_prepared_stmt_v1_t. */
117execute_prepared_stmt_v1_t execute_prepared_stmt;
118/** @sa set_prepared_stmt_text_v1_t. */
119set_prepared_stmt_text_v1_t set_prepared_stmt_text;
120/** @sa set_prepared_stmt_secondary_engine_v3_t */
121set_prepared_stmt_secondary_engine_v3_t set_prepared_stmt_secondary_engine;
122
123/** @sa digest_start_v1_t. */
124digest_start_v1_t digest_start;
125/** @sa digest_end_v1_t. */
127
128/** @sa get_sp_share_v1_t. */
129get_sp_share_v1_t get_sp_share;
130/** @sa release_sp_share_v1_t. */
131release_sp_share_v1_t release_sp_share;
132/** @sa start_sp_v1_t. */
134/** @sa start_sp_v1_t. */
136/** @sa drop_sp_v1_t. */
138END_SERVICE_DEFINITION(psi_statement_v4)
139
140#endif /* COMPONENTS_SERVICES_PSI_STATEMENT_SERVICE_H */
void(* destroy_prepared_stmt_v1_t)(PSI_prepared_stmt *prepared_stmt)
destroy a prepare statement.
Definition: psi_statement_bits.h:470
void(* inc_statement_sort_merge_passes_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "sort merge passes" metric.
Definition: psi_statement_bits.h:393
void(* inc_statement_sort_rows_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "sort rows" metric.
Definition: psi_statement_bits.h:409
void(* inc_statement_select_full_range_join_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "select full range join" metric.
Definition: psi_statement_bits.h:361
void(* set_statement_text_v1_t)(struct PSI_statement_locker *locker, const char *text, unsigned int text_len)
Set the statement text for a statement event.
Definition: psi_statement_bits.h:295
void(* inc_statement_select_range_check_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "select range check" metric.
Definition: psi_statement_bits.h:377
struct PSI_digest_locker *(* digest_start_v1_t)(struct PSI_statement_locker *locker)
Get a digest locker for the current statement.
Definition: psi_statement_bits.h:508
void(* inc_statement_select_scan_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "select scan" metric.
Definition: psi_statement_bits.h:385
void(* set_prepared_stmt_secondary_engine_v3_t)(PSI_prepared_stmt *prepared_stmt, bool secondary)
Set a prepared statement EXECUTION_ENGINE attribute.
Definition: psi_statement_bits.h:501
void(* register_statement_v1_t)(const char *category, struct PSI_statement_info_v1 *info, int count)
Statement registration API.
Definition: psi_statement_bits.h:248
void(* reprepare_prepared_stmt_v1_t)(PSI_prepared_stmt *prepared_stmt)
reprepare a prepare statement.
Definition: psi_statement_bits.h:476
void(* inc_statement_sort_scan_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "sort scan" metric.
Definition: psi_statement_bits.h:417
void(* execute_prepared_stmt_v1_t)(PSI_statement_locker *locker, PSI_prepared_stmt *prepared_stmt)
Record a prepare statement instrumentation execute event.
Definition: psi_statement_bits.h:483
void(* set_statement_no_index_used_t)(struct PSI_statement_locker *locker)
Set a statement event "no index used" metric.
Definition: psi_statement_bits.h:424
struct PSI_sp_share *(* get_sp_share_v1_t)(unsigned int object_type, const char *schema_name, unsigned int schema_name_length, const char *object_name, unsigned int object_name_length)
Acquire a sp share instrumentation.
Definition: psi_statement_bits.h:528
void(* inc_statement_sort_range_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "sort range" metric.
Definition: psi_statement_bits.h:401
void(* start_statement_v1_t)(struct PSI_statement_locker *locker, const char *db, unsigned int db_length, const char *src_file, unsigned int src_line)
Start a new statement event.
Definition: psi_statement_bits.h:282
void(* release_sp_share_v1_t)(struct PSI_sp_share *share)
Release a stored program share.
Definition: psi_statement_bits.h:537
void(* set_statement_query_id_t)(struct PSI_statement_locker *locker, unsigned long long query_id)
Set a statement query id.
Definition: psi_statement_bits.h:305
void(* set_statement_secondary_engine_v3_t)(struct PSI_statement_locker *locker, bool secondary)
Set a statement EXECUTION_ENGINE attribute.
Definition: psi_statement_bits.h:439
struct PSI_statement_locker *(* get_thread_statement_locker_v4_t)(struct PSI_statement_locker_state_v4 *state, PSI_statement_key key, const void *charset, PSI_sp_share *sp_share)
Get a statement instrumentation locker.
Definition: psi_statement_bits.h:260
void(* drop_sp_v1_t)(unsigned int object_type, const char *schema_name, unsigned int schema_name_length, const char *object_name, unsigned int object_name_length)
Definition: psi_statement_bits.h:544
void(* set_statement_rows_examined_t)(struct PSI_statement_locker *locker, unsigned long long count)
Set a statement event rows examined metric.
Definition: psi_statement_bits.h:329
void(* set_statement_no_good_index_used_t)(struct PSI_statement_locker *locker)
Set a statement event "no good index used" metric.
Definition: psi_statement_bits.h:431
void(* digest_end_v1_t)(struct PSI_digest_locker *locker, const struct sql_digest_storage *digest)
Add a computed digest to the current digest instrumentation.
Definition: psi_statement_bits.h:516
void(* inc_statement_select_range_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "select range join" metric.
Definition: psi_statement_bits.h:369
void(* set_prepared_stmt_text_v1_t)(PSI_prepared_stmt *prepared_stmt, const char *text, unsigned int text_len)
Set the statement text for a prepared statement event.
Definition: psi_statement_bits.h:492
void(* end_sp_v1_t)(struct PSI_sp_locker *locker)
Definition: psi_statement_bits.h:542
void(* inc_statement_select_full_join_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "select full join" metric.
Definition: psi_statement_bits.h:353
void(* end_statement_v1_t)(struct PSI_statement_locker *locker, void *stmt_da)
End a statement event.
Definition: psi_statement_bits.h:448
void(* set_statement_lock_time_t)(struct PSI_statement_locker *locker, unsigned long long lock_time)
Set a statement event lock time.
Definition: psi_statement_bits.h:313
void(* set_statement_rows_sent_t)(struct PSI_statement_locker *locker, unsigned long long count)
Set a statement event rows sent metric.
Definition: psi_statement_bits.h:321
struct PSI_statement_locker *(* refine_statement_v1_t)(struct PSI_statement_locker *locker, PSI_statement_key key)
Refine a statement locker to a more specific key.
Definition: psi_statement_bits.h:271
PSI_prepared_stmt *(* create_prepared_stmt_v1_t)(void *identity, unsigned int stmt_id, PSI_statement_locker *locker, const char *stmt_name, size_t stmt_name_length, const char *sql_text, size_t sql_text_length)
Get a prepare statement.
Definition: psi_statement_bits.h:461
PSI_sp_locker *(* start_sp_v1_t)(struct PSI_sp_locker_state_v1 *state, struct PSI_sp_share *sp_share)
Definition: psi_statement_bits.h:539
void(* inc_statement_created_tmp_disk_tables_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "created tmp disk tables" metric.
Definition: psi_statement_bits.h:337
void(* inc_statement_created_tmp_tables_t)(struct PSI_statement_locker *locker, unsigned long count)
Increment a statement event "created tmp tables" metric.
Definition: psi_statement_bits.h:345
PFS_prepared_stmt * create_prepared_stmt(void *identity, PFS_thread *thread, PFS_program *pfs_program, PFS_events_statements *pfs_stmt, uint stmt_id, const char *stmt_name, uint stmt_name_length, const char *sqltext, uint sqltext_length)
Definition: pfs_prepared_stmt.cc:72
Performance schema instrumentation interface.
#define END_SERVICE_DEFINITION(name)
A macro to end the last Service definition started with the BEGIN_SERVICE_DEFINITION macro.
Definition: service.h:90
#define BEGIN_SERVICE_DEFINITION(name)
Declares a new Service.
Definition: service.h:85