/* Copyright (c) 2015, 2024, 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 */ #include "sql/sql_thd_internal_api.h" #include #include "my_config.h" #include #include #include "m_string.h" #include "mysql/components/services/bits/psi_stage_bits.h" #include "pfs_thread_provider.h" #ifdef HAVE_UNISTD_H #include #endif #include "my_compiler.h" #include "my_dbug.h" #include "my_inttypes.h" #include "my_io.h" #include "my_macros.h" #include "my_psi_config.h" #include "my_sys.h" #include "mysql/psi/mysql_file.h" #include "mysql/psi/mysql_mutex.h" #include "mysql/psi/mysql_socket.h" #include "mysql/thread_type.h" #include "nulls.h" #include "sql/binlog.h" // mysql_bin_log #include "sql/current_thd.h" // current_thd #include "sql/mysqld.h" #include "sql/mysqld_thd_manager.h" // Global_THD_manager #include "sql/protocol_classic.h" #include "sql/query_options.h" #include "sql/rpl_filter.h" // binlog_filter #include "sql/sql_class.h" // THD #include "sql/sql_lex.h" #include "sql/sql_parse.h" // sqlcom_can_generate_row_events #include "sql/system_variables.h" #include "sql/transaction_info.h" #include "violite.h" struct CHARSET_INFO; struct mysql_cond_t; struct mysql_mutex_t; THD *create_internal_thd() { /* For internal threads, use enabled_plugins = false. */ THD *thd = new THD(false); thd->system_thread = SYSTEM_THREAD_BACKGROUND; // Skip grants and set the system_user flag in THD. thd->security_context()->skip_grants(); thd->thread_stack = reinterpret_cast(&thd); thd->store_globals(); #ifdef HAVE_PSI_THREAD_INTERFACE PSI_thread *psi; psi = PSI_THREAD_CALL(get_thread)(); if (psi != nullptr) { /* Associate this THD to the background thread instrumentation, so that system variables and status variables are visible for the background thread. */ PSI_THREAD_CALL(set_thread_THD)(psi, thd); thd->set_psi(psi); } #endif /* HAVE_PSI_THREAD_INTERFACE */ return thd; } void destroy_internal_thd(THD *thd) { assert(thd->system_thread == SYSTEM_THREAD_BACKGROUND); #ifdef HAVE_PSI_THREAD_INTERFACE PSI_thread *psi; psi = PSI_THREAD_CALL(get_thread)(); if (psi != nullptr) { /* Dissociate this THD from the background thread instrumentation. */ PSI_THREAD_CALL(set_thread_THD)(psi, nullptr); thd->set_psi(nullptr); } #endif /* HAVE_PSI_THREAD_INTERFACE */ thd->release_resources(); delete thd; } void thd_init(THD *thd, char *stack_start) { DBUG_TRACE; // TODO: Purge threads currently terminate too late for them to be added. // Note that P_S interprets all threads with thread_id != 0 as // foreground threads. And THDs need thread_id != 0 to be added // to the global THD list. if (thd->system_thread != SYSTEM_THREAD_BACKGROUND) { thd->set_new_thread_id(); Global_THD_manager *thd_manager = Global_THD_manager::get_instance(); thd_manager->add_thd(thd); } if (!thd->system_thread) { DBUG_PRINT("info", ("init new connection. thd: %p fd: " MY_SOCKET_FMT, thd, mysql_socket_getfd( thd->get_protocol_classic()->get_vio()->mysql_socket))); } thd_set_thread_stack(thd, stack_start); thd->store_globals(); } void thd_init(THD *thd, char *stack_start, bool bound [[maybe_unused]], PSI_thread_key psi_key [[maybe_unused]], unsigned int psi_seqnum [[maybe_unused]]) { DBUG_TRACE; thd_init(thd, stack_start); #ifdef HAVE_PSI_THREAD_INTERFACE PSI_thread *psi; psi = PSI_THREAD_CALL(new_thread)(psi_key, psi_seqnum, thd, thd->thread_id()); if (bound) { PSI_THREAD_CALL(set_thread_os_id)(psi); } PSI_THREAD_CALL(set_thread_THD)(psi, thd); thd->set_psi(psi); #endif /* HAVE_PSI_THREAD_INTERFACE */ } THD *create_thd(bool enable_plugins, bool background_thread, bool bound, PSI_thread_key psi_key, unsigned int psi_seqnum) { THD *thd = new THD(enable_plugins); if (background_thread) { thd->system_thread = SYSTEM_THREAD_BACKGROUND; // Skip grants and set the system_user flag in THD. thd->security_context()->skip_grants(); } (void)thd_init(thd, reinterpret_cast(&thd), bound, psi_key, psi_seqnum); return thd; } void destroy_thd(THD *thd, bool clear_pfs_events [[maybe_unused]]) { thd->release_resources(); #ifdef HAVE_PSI_THREAD_INTERFACE if (clear_pfs_events) PSI_THREAD_CALL(delete_thread)(thd->get_psi()); thd->set_psi(nullptr); #endif /* HAVE_PSI_THREAD_INTERFACE */ // TODO: Purge threads currently terminate too late for them to be added. if (thd->system_thread != SYSTEM_THREAD_BACKGROUND) { Global_THD_manager *thd_manager = Global_THD_manager::get_instance(); thd_manager->remove_thd(thd); } delete thd; } void destroy_thd(THD *thd) { return destroy_thd(thd, true); } void thd_set_thread_stack(THD *thd, const char *stack_start) { thd->thread_stack = stack_start; } extern "C" void thd_enter_cond(void *opaque_thd, mysql_cond_t *cond, mysql_mutex_t *mutex, const PSI_stage_info *stage, PSI_stage_info *old_stage, const char *src_function, const char *src_file, int src_line) { THD *thd = static_cast(opaque_thd); if (!thd) thd = current_thd; return thd->enter_cond(cond, mutex, stage, old_stage, src_function, src_file, src_line); } extern "C" void thd_exit_cond(void *opaque_thd, const PSI_stage_info *stage, const char *src_function, const char *src_file, int src_line) { THD *thd = static_cast(opaque_thd); if (!thd) thd = current_thd; thd->exit_cond(stage, src_function, src_file, src_line); } extern "C" void thd_enter_stage(void *opaque_thd, const PSI_stage_info *new_stage, PSI_stage_info *old_stage, const char *src_function, const char *src_file, int src_line) { THD *thd = static_cast(opaque_thd); if (!thd) thd = current_thd; thd->enter_stage(new_stage, old_stage, src_function, src_file, src_line); } extern "C" void thd_set_waiting_for_disk_space(void *opaque_thd, const bool waiting) { THD *thd = static_cast(opaque_thd); if (!thd) thd = current_thd; thd->set_waiting_for_disk_space(waiting); } void thd_increment_bytes_sent(size_t length) { THD *thd = current_thd; if (likely(thd != nullptr)) { /* current_thd==NULL when close_connection() calls net_send_error() */ thd->status_var.bytes_sent += length; global_aggregated_stats.get_shard(thd->thread_id()).bytes_sent += length; } } void thd_increment_bytes_received(size_t length) { THD *thd = current_thd; if (likely(thd != nullptr)) { thd->status_var.bytes_received += length; global_aggregated_stats.get_shard(thd->thread_id()).bytes_received += length; } } partition_info *thd_get_work_part_info(THD *thd) { return thd->work_part_info; } enum_tx_isolation thd_get_trx_isolation(const THD *thd) { return thd->tx_isolation; } const CHARSET_INFO *thd_charset(THD *thd) { return (thd->charset()); } LEX_CSTRING thd_query_unsafe(THD *thd) { assert(current_thd == thd); return thd->query(); } size_t thd_query_safe(THD *thd, char *buf, size_t buflen) { mysql_mutex_lock(&thd->LOCK_thd_query); const LEX_CSTRING query_string = thd->query(); size_t len = std::min(buflen - 1, query_string.length); if (len > 0) strncpy(buf, query_string.str, len); buf[len] = '\0'; mysql_mutex_unlock(&thd->LOCK_thd_query); return len; } int thd_slave_thread(const THD *thd) { return (thd->slave_thread); } int thd_non_transactional_update(const THD *thd) { return thd->get_transaction()->has_modified_non_trans_table( Transaction_ctx::SESSION); } int thd_binlog_format(const THD *thd) { if (mysql_bin_log.is_open() && (thd->variables.option_bits & OPTION_BIN_LOG)) return (int)thd->variables.binlog_format; else return BINLOG_FORMAT_UNSPEC; } bool thd_binlog_filter_ok(const THD *thd) { return binlog_filter->db_ok(thd->db().str); } bool thd_sqlcom_can_generate_row_events(const THD *thd) { return sqlcom_can_generate_row_events(thd->lex->sql_command); } enum durability_properties thd_get_durability_property(const THD *thd) { enum durability_properties ret = HA_REGULAR_DURABILITY; if (thd != nullptr) ret = thd->durability_property; return ret; } void thd_get_autoinc(const THD *thd, ulong *off, ulong *inc) { *off = thd->variables.auto_increment_offset; *inc = thd->variables.auto_increment_increment; } size_t thd_get_tmp_table_size(const THD *thd) { // We are intentionally narrowing the unsigned long long int (type of // thd->variables.tmp_table_size) to size_t here. Issue with the former is // that it represents more memory than one can address, in particular this is // the case with 32-bit builds because unsigned long long int is guaranteed // to be _at least_ 64 bits wide. That is much larger than the available // address space. // // Given that tmp_table_size sysvar is about limiting the consumed (virtual) // memory, size_t is the type which actually only makes sense to use here as // it represents exactly the theoretical maximum sized object if (thd->variables.tmp_table_size < std::numeric_limits::max()) { return thd->variables.tmp_table_size; } else { return std::numeric_limits::max(); } } bool thd_is_strict_mode(const THD *thd) { return thd->is_strict_mode(); } bool thd_is_error(const THD *thd) { return thd->is_error(); } bool is_mysql_datadir_path(const char *path) { if (path == nullptr || strlen(path) >= FN_REFLEN) return false; char mysql_data_dir[FN_REFLEN], path_dir[FN_REFLEN]; convert_dirname(path_dir, path, NullS); convert_dirname(mysql_data_dir, mysql_unpacked_real_data_home, NullS); const size_t mysql_data_home_len = dirname_length(mysql_data_dir); const size_t path_len = dirname_length(path_dir); if (path_len < mysql_data_home_len) return true; if (!lower_case_file_system) return memcmp(mysql_data_dir, path_dir, mysql_data_home_len); return files_charset_info->coll->strnncoll( files_charset_info, reinterpret_cast(path_dir), path_len, reinterpret_cast(mysql_data_dir), mysql_data_home_len, true); } int mysql_tmpfile_path(const char *path, const char *prefix) { assert(path != nullptr); assert((strlen(path) + strlen(prefix)) <= FN_REFLEN); char filename[FN_REFLEN]; int mode = O_CREAT | O_EXCL | O_RDWR; #ifdef _WIN32 mode |= O_TRUNC | O_SEQUENTIAL; #endif const File fd = mysql_file_create_temp(PSI_NOT_INSTRUMENTED, filename, path, prefix, mode, UNLINK_FILE, MYF(MY_WME)); return fd; } bool thd_is_bootstrap_thread(THD *thd) { assert(thd); return (thd->is_bootstrap_system_thread() && !thd->is_init_file_system_thread()); } bool thd_is_dd_update_stmt(const THD *thd) { assert(thd != nullptr); /* OPTION_DD_UPDATE_CONTEXT flag is set when thread switches context to update data dictionary tables for the * DDL statements. * Administration statements as ANALYZE TABLE. * Event threads for next activation time of a event and to update status. * SDI import. ... So verifying OPTION_DD_UPDATE_CONTEXT flag value to check if thread is updating the data dictionary tables. */ return (thd->variables.option_bits & OPTION_DD_UPDATE_CONTEXT); } my_thread_id thd_thread_id(const THD *thd) { return (thd->thread_id()); }