MySQL 8.0.29
Source Code Documentation
pfs_events_waits.h
Go to the documentation of this file.
1/* Copyright (c) 2008, 2022, Oracle and/or its affiliates.
2
3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License, version 2.0,
5 as published by the Free Software Foundation.
6
7 This program is also distributed with certain software (including
8 but not limited to OpenSSL) that is licensed under separate terms,
9 as designated in a particular file or component or in included license
10 documentation. The authors of MySQL hereby grant you an additional
11 permission to link the program and your derivative works with the
12 separately licensed software that they have included with MySQL.
13
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License, version 2.0, for more details.
18
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22
23#ifndef PFS_EVENTS_WAITS_H
24#define PFS_EVENTS_WAITS_H
25
26/**
27 @file storage/perfschema/pfs_events_waits.h
28 Events waits data structures (declarations).
29*/
30
31#include <sys/types.h>
32#include <atomic>
33
34#include "my_inttypes.h"
39
40struct PFS_mutex;
41struct PFS_rwlock;
42struct PFS_cond;
43struct PFS_table;
44struct PFS_file;
45struct PFS_thread;
46struct PFS_socket;
47struct PFS_instr_class;
48struct PFS_table_share;
49struct PFS_account;
50struct PFS_user;
51struct PFS_host;
53
54/** Class of a wait event. */
65};
66
67/** A wait event record. */
69 /**
70 The type of wait.
71 Readers:
72 - the consumer threads.
73 Writers:
74 - the producer threads, in the instrumentation.
75 Out of bound Writers:
76 - TRUNCATE EVENTS_WAITS_CURRENT
77 - TRUNCATE EVENTS_WAITS_HISTORY
78 - TRUNCATE EVENTS_WAITS_HISTORY_LONG
79 */
81 /** Object type */
83 /** Table share, for table operations only. */
85 /** File, for file operations only. */
87 /** Socket, for socket operations only. */
89 /** Metadata lock, for MDL operations only. */
91 /** For weak pointers, target object version. */
93 /** Address in memory of the object instance waited on. */
95 /** Operation performed. */
97 /**
98 Number of bytes/rows read/written.
99 This member is populated for FILE READ/WRITE operations, with a number of
100 bytes.
101 This member is populated for TABLE I/O operations, with a number of rows.
102 */
104 /**
105 Index used.
106 This member is populated for TABLE I/O operations only.
107 */
109 /** Flags */
110 ulong m_flags;
111};
112
113/** TIMED bit in the state flags bitfield. */
114#define STATE_FLAG_TIMED (1 << 0)
115/** THREAD bit in the state flags bitfield. */
116#define STATE_FLAG_THREAD (1 << 1)
117/** EVENT bit in the state flags bitfield. */
118#define STATE_FLAG_EVENT (1 << 2)
119/** DIGEST bit in the state flags bitfield. */
120#define STATE_FLAG_DIGEST (1 << 3)
121/** CPU bit in the state flags bitfield. */
122#define STATE_FLAG_CPU (1 << 4)
123/** SECONDARY_ENGINE bit in the state flags bitfield. */
124#define STATE_FLAG_SECONDARY (1 << 5)
125
127
129
130extern bool flag_events_waits_current;
131extern bool flag_events_waits_history;
135
140
141int init_events_waits_history_long(uint events_waits_history_long_sizing);
143
155
162
163#endif
Some integer typedefs for easier portability.
uint32_t uint32
Definition: my_inttypes.h:66
char * user
Definition: mysqladmin.cc:59
const char * host
Definition: mysqladmin.cc:58
stdx::expected< size_t, std::error_code > wait(int epfd, epoll_event *fd_events, size_t num_fd_events, std::chrono::milliseconds timeout)
Definition: linux_epoll.h:82
Data types for columns used in the performance schema tables (declarations)
enum_object_type
Enum values for the various OBJECT_TYPE columns.
Definition: pfs_column_types.h:221
enum_operation_type
Enum values for the various OPERATION columns.
Definition: pfs_column_types.h:124
Events data structures (declarations).
void reset_table_lock_waits_by_table()
Definition: pfs_events_waits.cc:249
bool flag_events_waits_current
Consumer flag for table EVENTS_WAITS_CURRENT.
Definition: pfs_events_waits.cc:46
void reset_events_waits_by_thread()
Reset table EVENTS_WAITS_SUMMARY_BY_THREAD_BY_EVENT_NAME data.
Definition: pfs_events_waits.cc:196
void reset_events_waits_global()
void reset_table_lock_waits_by_table_handle()
Definition: pfs_events_waits.cc:273
ulong events_waits_history_long_size
Definition: pfs_events_waits.cc:44
bool flag_global_instrumentation
Consumer flag for the global instrumentation.
Definition: pfs_events_waits.cc:52
void reset_events_waits_by_account()
Reset table EVENTS_WAITS_SUMMARY_BY_ACCOUNT_BY_EVENT_NAME data.
Definition: pfs_events_waits.cc:207
void reset_table_waits_by_table_handle()
Definition: pfs_events_waits.cc:257
void reset_events_waits_history()
Reset table EVENTS_WAITS_HISTORY data.
Definition: pfs_events_waits.cc:172
bool flag_events_waits_history_long
Consumer flag for table EVENTS_WAITS_HISTORY_LONG.
Definition: pfs_events_waits.cc:50
void reset_events_waits_current()
Reset table EVENTS_WAITS_CURRENT data.
Definition: pfs_events_waits.cc:156
PFS_cacheline_atomic_uint32 events_waits_history_long_index
Index in EVENTS_WAITS_HISTORY_LONG circular buffer.
Definition: pfs_events_waits.cc:59
void insert_events_waits_history(PFS_thread *thread, PFS_events_waits *wait)
Insert a wait record in table EVENTS_WAITS_HISTORY.
Definition: pfs_events_waits.cc:101
void aggregate_account_waits(PFS_account *account)
bool flag_thread_instrumentation
Consumer flag for the per thread instrumentation.
Definition: pfs_events_waits.cc:54
void reset_table_io_waits_by_table()
Definition: pfs_events_waits.cc:241
void aggregate_host_waits(PFS_host *host)
void reset_events_waits_history_long()
Reset table EVENTS_WAITS_HISTORY_LONG data.
Definition: pfs_events_waits.cc:177
void insert_events_waits_history_long(PFS_events_waits *wait)
Insert a wait record in table EVENTS_WAITS_HISTORY_LONG.
Definition: pfs_events_waits.cc:130
int init_events_waits_history_long(uint events_waits_history_long_sizing)
Initialize table EVENTS_WAITS_HISTORY_LONG.
Definition: pfs_events_waits.cc:67
void cleanup_events_waits_history_long()
Cleanup table EVENTS_WAITS_HISTORY_LONG.
Definition: pfs_events_waits.cc:84
bool events_waits_history_long_full
True if EVENTS_WAITS_HISTORY_LONG circular buffer is full.
Definition: pfs_events_waits.cc:57
void aggregate_user_waits(PFS_user *user)
void reset_events_waits_by_host()
Reset table EVENTS_WAITS_SUMMARY_BY_HOST_BY_EVENT_NAME data.
Definition: pfs_events_waits.cc:225
PFS_events_waits * events_waits_history_long_array
EVENTS_WAITS_HISTORY_LONG circular buffer.
Definition: pfs_events_waits.cc:61
void reset_table_waits_by_table()
Definition: pfs_events_waits.cc:233
events_waits_class
Class of a wait event.
Definition: pfs_events_waits.h:55
@ WAIT_CLASS_MUTEX
Definition: pfs_events_waits.h:57
@ NO_WAIT_CLASS
Definition: pfs_events_waits.h:56
@ WAIT_CLASS_FILE
Definition: pfs_events_waits.h:61
@ WAIT_CLASS_COND
Definition: pfs_events_waits.h:59
@ WAIT_CLASS_SOCKET
Definition: pfs_events_waits.h:62
@ WAIT_CLASS_METADATA
Definition: pfs_events_waits.h:64
@ WAIT_CLASS_TABLE
Definition: pfs_events_waits.h:60
@ WAIT_CLASS_IDLE
Definition: pfs_events_waits.h:63
@ WAIT_CLASS_RWLOCK
Definition: pfs_events_waits.h:58
void reset_events_waits_by_user()
Reset table EVENTS_WAITS_SUMMARY_BY_USER_BY_EVENT_NAME data.
Definition: pfs_events_waits.cc:216
void reset_table_io_waits_by_table_handle()
Definition: pfs_events_waits.cc:265
bool flag_events_waits_history
Consumer flag for table EVENTS_WAITS_HISTORY.
Definition: pfs_events_waits.cc:48
Miscellaneous global dependencies (declarations).
Performance schema internal locks (declarations).
Per account statistics.
Definition: pfs_account.h:66
An atomic uint32 variable, guaranteed to be alone in a CPU cache line.
Definition: pfs_global.h:74
Instrumented condition implementation.
Definition: pfs_instr.h:159
A wait event record.
Definition: pfs_events_waits.h:68
uint32 m_weak_version
For weak pointers, target object version.
Definition: pfs_events_waits.h:92
size_t m_number_of_bytes
Number of bytes/rows read/written.
Definition: pfs_events_waits.h:103
PFS_table_share * m_weak_table_share
Table share, for table operations only.
Definition: pfs_events_waits.h:84
PFS_socket * m_weak_socket
Socket, for socket operations only.
Definition: pfs_events_waits.h:88
PFS_file * m_weak_file
File, for file operations only.
Definition: pfs_events_waits.h:86
events_waits_class m_wait_class
The type of wait.
Definition: pfs_events_waits.h:80
enum_operation_type m_operation
Operation performed.
Definition: pfs_events_waits.h:96
ulong m_flags
Flags.
Definition: pfs_events_waits.h:110
uint m_index
Index used.
Definition: pfs_events_waits.h:108
enum_object_type m_object_type
Object type.
Definition: pfs_events_waits.h:82
PFS_metadata_lock * m_weak_metadata_lock
Metadata lock, for MDL operations only.
Definition: pfs_events_waits.h:90
const void * m_object_instance_addr
Address in memory of the object instance waited on.
Definition: pfs_events_waits.h:94
An event record.
Definition: pfs_events.h:37
Instrumented File and FILE implementation.
Definition: pfs_instr.h:176
Per host statistics.
Definition: pfs_host.h:62
Information for all instrumentation.
Definition: pfs_instr_class.h:204
Instrumented metadata lock implementation.
Definition: pfs_instr.h:315
Instrumented mutex implementation.
Definition: pfs_instr.h:100
Instrumented rwlock implementation.
Definition: pfs_instr.h:126
Instrumented socket implementation.
Definition: pfs_instr.h:286
Instrumentation metadata for a table share.
Definition: pfs_instr_class.h:387
Instrumented table implementation.
Definition: pfs_instr.h:192
Instrumented thread implementation.
Definition: pfs_instr.h:372
Per user statistics.
Definition: pfs_user.h:61
unsigned int uint
Definition: uca-dump.cc:29