1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
|
/* Copyright (c) 2008, 2011, Oracle and/or its affiliates. All rights reserved.
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,
51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA */
#ifndef PFS_SERVER_H
#define PFS_SERVER_H
/**
@file storage/perfschema/pfs_server.h
Private interface for the server (declarations).
*/
#ifndef PFS_MAX_MUTEX_CLASS
#define PFS_MAX_MUTEX_CLASS 200
#endif
#ifndef PFS_MAX_MUTEX
#define PFS_MAX_MUTEX 1000000
#endif
#ifndef PFS_MAX_RWLOCK_CLASS
#define PFS_MAX_RWLOCK_CLASS 30
#endif
#ifndef PFS_MAX_RWLOCK
#define PFS_MAX_RWLOCK 1000000
#endif
#ifndef PFS_MAX_COND_CLASS
#define PFS_MAX_COND_CLASS 80
#endif
#ifndef PFS_MAX_COND
#define PFS_MAX_COND 1000
#endif
#ifndef PFS_MAX_THREAD_CLASS
#define PFS_MAX_THREAD_CLASS 50
#endif
#ifndef PFS_MAX_THREAD
#define PFS_MAX_THREAD 1000
#endif
#ifndef PFS_MAX_FILE_CLASS
#define PFS_MAX_FILE_CLASS 50
#endif
#ifndef PFS_MAX_FILE
#define PFS_MAX_FILE 10000
#endif
#ifndef PFS_MAX_FILE_HANDLE
#define PFS_MAX_FILE_HANDLE 32768
#endif
#ifndef PFS_MAX_SOCKETS
#define PFS_MAX_SOCKETS 1000
#endif
#ifndef PFS_MAX_SOCKET_CLASS
#define PFS_MAX_SOCKET_CLASS 10
#endif
#ifndef PFS_MAX_TABLE_SHARE
#define PFS_MAX_TABLE_SHARE 1000
#endif
#ifndef PFS_MAX_TABLE
#define PFS_MAX_TABLE 10000
#endif
#ifndef PFS_WAITS_HISTORY_SIZE
#define PFS_WAITS_HISTORY_SIZE 10
#endif
#ifndef PFS_WAITS_HISTORY_LONG_SIZE
#define PFS_WAITS_HISTORY_LONG_SIZE 10000
#endif
#ifndef PFS_MAX_SETUP_ACTOR
#define PFS_MAX_SETUP_ACTOR 100
#endif
#ifndef PFS_MAX_SETUP_OBJECT
#define PFS_MAX_SETUP_OBJECT 100
#endif
#ifndef PFS_MAX_HOST
#define PFS_MAX_HOST 100
#endif
#ifndef PFS_MAX_USER
#define PFS_MAX_USER 100
#endif
#ifndef PFS_MAX_ACCOUNT
#define PFS_MAX_ACCOUNT 100
#endif
#ifndef PFS_MAX_STAGE_CLASS
#define PFS_MAX_STAGE_CLASS 150
#endif
#ifndef PFS_STAGES_HISTORY_SIZE
#define PFS_STAGES_HISTORY_SIZE 10
#endif
#ifndef PFS_STAGES_HISTORY_LONG_SIZE
#define PFS_STAGES_HISTORY_LONG_SIZE 10000
#endif
#ifndef PFS_STATEMENTS_HISTORY_SIZE
#define PFS_STATEMENTS_HISTORY_SIZE 10
#endif
#ifndef PFS_STATEMENTS_HISTORY_LONG_SIZE
#define PFS_STATEMENTS_HISTORY_LONG_SIZE 10000
#endif
#ifndef PFS_STATEMENTS_STACK_SIZE
#define PFS_STATEMENTS_STACK_SIZE 10
#endif
#ifndef PFS_DIGEST_SIZE
#define PFS_DIGEST_SIZE 200
#endif
/** Performance schema global sizing parameters. */
struct PFS_global_param
{
/** True if the performance schema is enabled. */
bool m_enabled;
/** Default values for SETUP_CONSUMERS. */
bool m_consumer_events_stages_current_enabled;
bool m_consumer_events_stages_history_enabled;
bool m_consumer_events_stages_history_long_enabled;
bool m_consumer_events_statements_current_enabled;
bool m_consumer_events_statements_history_enabled;
bool m_consumer_events_statements_history_long_enabled;
bool m_consumer_events_waits_current_enabled;
bool m_consumer_events_waits_history_enabled;
bool m_consumer_events_waits_history_long_enabled;
bool m_consumer_global_instrumentation_enabled;
bool m_consumer_thread_instrumentation_enabled;
bool m_consumer_statement_digest_enabled;
/** Default instrument configuration option. */
char *m_pfs_instrument;
/**
Maximum number of instrumented mutex classes.
@sa mutex_class_lost.
*/
ulong m_mutex_class_sizing;
/**
Maximum number of instrumented rwlock classes.
@sa rwlock_class_lost.
*/
ulong m_rwlock_class_sizing;
/**
Maximum number of instrumented cond classes.
@sa cond_class_lost.
*/
ulong m_cond_class_sizing;
/**
Maximum number of instrumented thread classes.
@sa thread_class_lost.
*/
ulong m_thread_class_sizing;
/**
Maximum number of instrumented table share.
@sa table_share_lost.
*/
ulong m_table_share_sizing;
/**
Maximum number of instrumented file classes.
@sa file_class_lost.
*/
ulong m_file_class_sizing;
/**
Maximum number of instrumented mutex instances.
@sa mutex_lost.
*/
ulong m_mutex_sizing;
/**
Maximum number of instrumented rwlock instances.
@sa rwlock_lost.
*/
ulong m_rwlock_sizing;
/**
Maximum number of instrumented cond instances.
@sa cond_lost.
*/
ulong m_cond_sizing;
/**
Maximum number of instrumented thread instances.
@sa thread_lost.
*/
ulong m_thread_sizing;
/**
Maximum number of instrumented table handles.
@sa table_lost.
*/
ulong m_table_sizing;
/**
Maximum number of instrumented file instances.
@sa file_lost.
*/
ulong m_file_sizing;
/**
Maximum number of instrumented file handles.
@sa file_handle_lost.
*/
ulong m_file_handle_sizing;
/**
Maxium number of instrumented socket instances
@sa socket_lost
*/
ulong m_socket_sizing;
/**
Maximum number of instrumented socket classes.
@sa socket_class_lost.
*/
ulong m_socket_class_sizing;
/** Maximum number of rows per thread in table EVENTS_WAITS_HISTORY. */
ulong m_events_waits_history_sizing;
/** Maximum number of rows in table EVENTS_WAITS_HISTORY_LONG. */
ulong m_events_waits_history_long_sizing;
/** Maximum number of rows in table SETUP_ACTORS. */
ulong m_setup_actor_sizing;
/** Maximum number of rows in table SETUP_OBJECTS. */
ulong m_setup_object_sizing;
/** Maximum number of rows in table HOSTS. */
ulong m_host_sizing;
/** Maximum number of rows in table USERS. */
ulong m_user_sizing;
/** Maximum number of rows in table ACCOUNTS. */
ulong m_account_sizing;
/**
Maximum number of instrumented stage classes.
@sa stage_class_lost.
*/
ulong m_stage_class_sizing;
/** Maximum number of rows per thread in table EVENTS_STAGES_HISTORY. */
ulong m_events_stages_history_sizing;
/** Maximum number of rows in table EVENTS_STAGES_HISTORY_LONG. */
ulong m_events_stages_history_long_sizing;
/**
Maximum number of instrumented statement classes.
@sa statement_class_lost.
*/
ulong m_statement_class_sizing;
/** Maximum number of rows per thread in table EVENTS_STATEMENT_HISTORY. */
ulong m_events_statements_history_sizing;
/** Maximum number of rows in table EVENTS_STATEMENTS_HISTORY_LONG. */
ulong m_events_statements_history_long_sizing;
/** Maximum number of digests to be captured */
ulong m_digest_sizing;
};
/**
Performance schema sizing values for the server.
This global variable is set when parsing server startup options.
*/
extern PFS_global_param pfs_param;
/**
Initialize the performance schema.
@param param Size parameters to use.
@return A boostrap handle, or NULL.
*/
struct PSI_bootstrap*
initialize_performance_schema(const PFS_global_param *param);
/**
Initialize the performance schema ACL.
ACL is strictly enforced when the server is running in normal mode,
to enforce that only legal operations are allowed.
When running in boostrap mode, ACL restrictions are relaxed,
to allow the boostrap scripts to DROP / CREATE performance schema tables.
@sa ACL_internal_schema_registry
@param bootstrap True if the server is starting in bootstrap mode.
*/
void initialize_performance_schema_acl(bool bootstrap);
void check_performance_schema();
/**
Initialize the dynamic array holding individual instrument settings collected
from the server configuration options.
*/
void init_pfs_instrument_array();
/**
Process one PFS_INSTRUMENT configuration string.
*/
int add_pfs_instr_to_array(const char* name, const char* value);
/**
Shutdown the performance schema.
*/
void shutdown_performance_schema();
#endif
|
