Waiting 450 seconds before starting pt-pmp profiling... Starting stack trace collection at Thu Apr 30 03:33:23 PM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Thu Apr 30 03:33:23 PM UTC 2026 982 syscall,libaio::??(libaio.so.1t64.0.2),libaio::??(libaio.so.1t64.0.2),io_getevents(libaio.so.1t64.0.2),LinuxAIOHandler::collect,LinuxAIOHandler::poll,os_aio_linux_handler,fil_aio_wait,std::atomic::load,std::__shared_ptr,Sort_param::make_sortkey,alloc_and_make_sortkey,read_all_rows,SortingIterator::DoSort,SortingIterator::Init,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 49 __libc_pread64,os_file_io,os_file_pread,os_file_read_func,pfs_os_aio_func,fil_io,buf_read_page_low,buf_read_page,Buf_fetch::read_page,Buf_fetch_other::get,Buf_fetch::single_page,buf_page_get_gen,btr_estimate_n_rows_in_range_on_level,ha_innobase::records_in_range,int,,int,,check_quick_select,get_key_scans_params,test_quick_select,get_quick_record_count,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 30 __GI___sigtimedwait,signal_hand,pfs_spawn_thread,start_thread,__clone3 30 __GI___poll,Mysqld_socket_listener::listen_for_connection_event,Connection_acceptor::connection_event_loop,__libc_start_call_main,call_init,_start(mysqld) 30 __GI___clock_nanosleep,__GI___nanosleep,std::this_thread::sleep_for,temptable::Cell_calculator::hash,my_hash_combine,std::_Hashtable,std::__atomic_base,SortBufferIterator::Read,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 escape_string_for_mysql,append_query_string,Item_param::query_val_str,Prepared_statement::insert_parameters,Prepared_statement::set_parameters,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 do_ssl3_write.localalias.0(libssl.so.3),ssl3_write_bytes(libssl.so.3),ssl3_write(libssl.so.3),ssl_write_internal(libssl.so.3),SSL_write(libssl.so.3),vio_ssl_write,net_write_raw_loop,net_flush,net_send_ok,String::shrink,THD::send_statement_status,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 compare_between_int_result,trx_prepare,innobase_xa_prepare,ha_prepare_low,MYSQL_BIN_LOG::prepare,ha_commit_trans,trans_commit,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 std::_Hashtable,CRYPTO_malloc(libcrypto.so.3),CRYPTO_zalloc(libcrypto.so.3),wpacket_intern_init_len(libssl.so.3),WPACKET_init_static_len(libssl.so.3),tls13_enc(libssl.so.3),do_ssl3_write.localalias.0(libssl.so.3),ssl3_write_bytes(libssl.so.3),ssl3_write(libssl.so.3),ssl_write_internal(libssl.so.3),SSL_write(libssl.so.3),vio_ssl_write,net_write_raw_loop,net_flush,net_send_ok,String::shrink,THD::send_statement_status,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_internal_free,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_hash_sort_uca,Collation_hasher::operator,Session_sysvars_tracker::vars_list::search,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_convert,Protocol_classic::net_store_data_with_conversion,Protocol_classic::send_field_metadata,THD::send_result_metadata,Query_result_send::send_result_set_metadata,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_charpos,Sort_param::make_sortkey,alloc_and_make_sortkey,read_all_rows,SortingIterator::DoSort,SortingIterator::Init,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 mtr_t::Command::release_all,mtr_t::commit,row_search_mvcc,ha_innobase::index_read,handler::index_read_map,Index_lookup*),POSITION*),JOIN::extract_func_dependent_tables,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 mtr_t::check_nolog_and_mark,row_search_mvcc,ha_innobase::general_fetch,handler::ha_index_next,handler::read_range_next,ut::bool_scope_guard_t::~bool_scope_guard_t,handler::multi_range_read_next,handler::ha_multi_range_read_next,IndexRangeScanIterator::Read,FilterIterator::Read,read_next_row,Init,filesort,SortingIterator::DoSort,SortingIterator::Init,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 mtr_memo_slot_t*,page_offset,ha_innobase::records_in_range,int,,int,,check_quick_select,get_key_scans_params,test_quick_select,get_quick_record_count,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 monitor_atomic_inc,os_file_read_func,pfs_os_aio_func,fil_io,buf_read_page_low,buf_read_page,Buf_fetch::read_page,Buf_fetch_normal::get,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,ha_innobase::index_read,handler::index_read_map,Index_lookup*),POSITION*),JOIN::extract_func_dependent_tables,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 mlog_open_and_write_index,page_cur_insert_rec_write_log,page_cur_insert_rec_low,btr_cur_optimistic_insert,row_ins_sec_index_entry_low,row_ins_sec_index_entry,row_upd_sec_index_entry_low,row_upd_sec_index_entry,row_update_for_mysql_using_upd_graph,ha_innobase::update_row,handler::ha_update_row,Sql_cmd_update::update_single_table,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 __memset_evex_unaligned_erms,buf_block_t::mark_for_read_io,buf_read_page_low,buf_read_page,Buf_fetch::read_page,Buf_fetch_normal::get,Buf_fetch::single_page,buf_page_get_gen,btr_pcur_t::move_to_next_page,btr_pcur_t::move_to_next,row_search_mvcc,ha_innobase::index_read,handler::index_read_map,Index_lookup*),POSITION*),JOIN::extract_func_dependent_tables,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 __memset_evex_unaligned_erms,buf_block_t::mark_for_read_io,buf_read_page_low,buf_read_page,Buf_fetch::read_page,Buf_fetch_normal::get,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,ha_innobase::index_read,handler::index_read_map,Index_lookup*),POSITION*),JOIN::extract_func_dependent_tables,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 mem_root_deque::add_block_back,mem_root_deque::push_back,add_loose_index_scan_and_skip_scan_keys,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 Mem_root_array_YY::begin,read_next_row,Init,filesort,SortingIterator::DoSort,SortingIterator::Init,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 MEM_ROOT::Alloc,get_mm_parts,get_full_func_mm_tree,get_mm_tree,Opt_trace_struct::~Opt_trace_struct,MEM_ROOT::~MEM_ROOT,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 memo_slot_release,Iterate::operator,mtr_t::commit,row_search_mvcc,ha_innobase::index_read,handler::index_read_map,handler::read_range_first,ut::bool_scope_guard_t::~bool_scope_guard_t,handler::multi_range_read_next,handler::ha_multi_range_read_next,IndexRangeScanIterator::Read,FilterIterator::Read,Query_expression::ExecuteIteratorQuery,LEX::set_current_query_block,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 memory_free_noop,my_internal_free,bitmap_free,Table_columns_view,std::atomic::load,std::__shared_ptr,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,page_offset,ha_innobase::records_in_range,int,,int,,check_quick_select,get_key_scans_params,test_quick_select,get_quick_record_count,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 buf_flush_ready_for_replace,buf_LRU_free_from_common_LRU_list,buf_LRU_get_free_block,buf_page_init_for_read,buf_read_page_low,buf_read_page,Buf_fetch::read_page,Buf_fetch_normal::get,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,ha_innobase::index_read,handler::index_read_map,Index_lookup*),POSITION*),JOIN::extract_func_dependent_tables,JOIN::make_join_plan,JOIN::optimize,Query_block::optimize,Query_expression::optimize,Sql_cmd_dml::execute_inner,Sql_cmd_dml::execute,mysql_execute_command,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 buf_flush_page,buf_flush_try_neighbors,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_coordinator_thread,std::__shared_ptr