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
|
/* Copyright (c) 2016, 2025, Oracle and/or its affiliates.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License, version 2.0,
as published by the Free Software Foundation.
This program is designed to work with certain software (including
but not limited to OpenSSL) that is licensed under separate terms,
as designated in a particular file or component or in included license
documentation. The authors of MySQL hereby grant you an additional
permission to link the program and your derivative works with the
separately licensed software that they have either included with
the program or referenced in the documentation.
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, version 2.0, 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-1301 USA */
/**
@file storage/perfschema/pfs_error.cc
Server error instrument data structures (implementation).
*/
#include "storage/perfschema/pfs_error.h"
#include "my_sys.h"
#include "mysql_com.h"
#include "storage/perfschema/pfs_account.h"
#include "storage/perfschema/pfs_buffer_container.h"
#include "storage/perfschema/pfs_builtin_memory.h"
#include "storage/perfschema/pfs_global.h"
#include "storage/perfschema/pfs_host.h"
#include "storage/perfschema/pfs_instr.h"
#include "storage/perfschema/pfs_instr_class.h"
#include "storage/perfschema/pfs_user.h"
uint max_global_server_errors;
uint max_session_server_errors;
uint pfs_to_server_error_map[PFS_MAX_GLOBAL_SERVER_ERRORS];
static void fct_reset_events_errors_by_thread(PFS_thread *thread) {
PFS_account *account = sanitize_account(thread->m_account);
PFS_user *user = sanitize_user(thread->m_user);
PFS_host *host = sanitize_host(thread->m_host);
aggregate_thread_errors(thread, account, user, host);
}
/**
Names of all errors defined in err_msg.txt.
This includes all names, instrumented or not.
*/
server_error error_names_array[] = {
#ifndef IN_DOXYGEN
{nullptr, 0, nullptr, nullptr, nullptr, 0}, // NULL ROW
#include <mysqld_ername.h>
{nullptr, 0, nullptr, nullptr, nullptr, 0} // DUMMY ROW
#endif /* IN_DOXYGEN */
};
int init_error(const PFS_global_param *param) {
/* Set the number of errors to be instrumented */
if (param->m_error_sizing != 0) {
/*
For global statistics,
restrict the number of instrumented errors
to the errors actually defined in share/errmsg-utf8.txt
TODO: provide a way for plugin / components to provide global errors.
*/
max_global_server_errors = param->m_error_sizing;
if (max_global_server_errors > PFS_MAX_GLOBAL_SERVER_ERRORS) {
max_global_server_errors = PFS_MAX_GLOBAL_SERVER_ERRORS;
}
/*
For sessions statistics,
restrict the number of instrumented errors
to the errors actually defined in share/errmsg-utf8.txt
TODO: provide a way for plugin / components to provide session errors.
*/
max_session_server_errors = param->m_error_sizing;
if (max_session_server_errors > PFS_MAX_SESSION_SERVER_ERRORS) {
max_session_server_errors = PFS_MAX_SESSION_SERVER_ERRORS;
}
} else {
/* Instrumentation is disabled. */
max_global_server_errors = 0;
max_session_server_errors = 0;
}
/* initialize global stats for errors */
global_error_stat.init(&builtin_memory_global_errors,
max_global_server_errors);
/* Initialize error index mapping */
for (int i = 0; i < total_error_count + 1; i++) {
if (error_names_array[i].error_index != 0) {
pfs_to_server_error_map[error_names_array[i].error_index] = i;
}
}
return 0;
}
void cleanup_error() {
/* cleanup global stats for errors */
global_error_stat.cleanup(&builtin_memory_global_errors);
}
/** Reset table EVENTS_ERRORS_SUMMARY_BY_THREAD_BY_ERROR data. */
void reset_events_errors_by_thread() {
global_thread_container.apply(fct_reset_events_errors_by_thread);
}
static void fct_reset_events_errors_by_account(PFS_account *pfs) {
PFS_user *user = sanitize_user(pfs->m_user);
PFS_host *host = sanitize_host(pfs->m_host);
pfs->aggregate_errors(user, host);
}
/** Reset table EVENTS_ERRORS_SUMMARY_BY_ACCOUNT_BY_ERROR data. */
void reset_events_errors_by_account() {
global_account_container.apply(fct_reset_events_errors_by_account);
}
static void fct_reset_events_errors_by_user(PFS_user *pfs) {
pfs->aggregate_errors();
}
/** Reset table EVENTS_ERRORS_SUMMARY_BY_USER_BY_ERROR data. */
void reset_events_errors_by_user() {
global_user_container.apply(fct_reset_events_errors_by_user);
}
static void fct_reset_events_errors_by_host(PFS_host *pfs) {
pfs->aggregate_errors();
}
/** Reset table EVENTS_ERRORS_SUMMARY_BY_HOST_BY_ERROR data. */
void reset_events_errors_by_host() {
global_host_container.apply(fct_reset_events_errors_by_host);
}
/** Reset table EVENTS_ERRORS_GLOBAL_BY_ERROR data. */
void reset_events_errors_global() { global_error_stat.reset(); }
/*
Function to lookup for the index of this particular error
in errors' stats array.
*/
uint lookup_error_stat_index(uint mysql_errno) {
uint offset = 0; /* Position where the current section starts in the array. */
uint index = 0;
if (mysql_errno < (uint)errmsg_section_start[0]) {
return error_names_array[0].error_index;
}
for (uint i = 0; i < NUM_SECTIONS; i++) {
if (mysql_errno >= (uint)errmsg_section_start[i] &&
mysql_errno <
(uint)(errmsg_section_start[i] + errmsg_section_size[i])) {
/* Following +1 is to accommodate NULL row in error_names_array */
index = mysql_errno - errmsg_section_start[i] + offset + 1;
break;
}
offset += errmsg_section_size[i];
}
return error_names_array[index].error_index;
}
|