Waiting 300 seconds before starting pt-pmp profiling... Starting stack trace collection at Fri May 1 01:35:20 PM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Fri May 1 01:35:20 PM UTC 2026 972 syscall,io_getevents(libaio.so.1.0.1),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 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,std::__atomic_base,my_hash_combine,std::__detail::_Mod_range_hashing::operator,temptable::Hash_unique::insert,at,temptable::Table::insert,temptable::Handler::write_row,handler::ha_write_row,MaterializeOperand,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 3 log_sync_point<46>,log_t&,,trx_flush_log_if_needed_low,trx_commit_complete_for_mysql,innobase_commit,ha_commit_low,trx_coordinator::commit_in_engines,TC_LOG_DUMMY::commit,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 3 __libc_pwrite64,os_file_io,os_file_pwrite,os_file_write_func,pfs_os_file_write_func,const*,,dblwr::Buffer::size,Double_write::write_pages,dblwr::Buffer::size,Double_write::submit,buf_flush_write_block_low,buf_flush_try_neighbors,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_cleaner_thread,std::__shared_ptr,my_lsearch,MDL_map::find,MDL_context::acquire_lock,MDL_context::set_force_dml_deadlock_weight,open_and_process_table,open_tables_for_query,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 ___pthread_mutex_lock,Prepared_statement::execute,String::mem_free,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 ___pthread_mutex_lock,OSMutex::enter,sync_array_reserve_cell,sync_array_get_and_reserve_cell,TTASEventMutex::spin_and_try_lock,page_id_t::hash,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_estimate_n_rows_in_range_low,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 ___pthread_mutex_lock,OSMutex::enter,LinuxAIOHandler::find_completed_slot,LinuxAIOHandler::poll,os_aio_linux_handler,fil_aio_wait,std::atomic::load,std::__shared_ptr,trx_commit_in_memory,trx_commit,monitor_dec,innobase_commit_low,innobase_commit,ha_commit_low,trx_coordinator::commit_in_engines,TC_LOG_DUMMY::commit,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 pfs_rw_lock_s_unlock_func,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open,row_purge_remove_sec_if_poss_tree,row_purge_remove_sec_if_poss,que_thr_step,trx_purge_wait_for_workers_to_complete,srv_do_purge,std::__shared_ptr,CRYPTO_zalloc(libcrypto.so.3),libssl::??(libssl.so.3),libssl::??(libssl.so.3),libssl::??(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_hash_sort_any_uca,Collation_hasher::operator,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_charpos_mb4,Field_string::pack,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 MVCC::get_oldest_view,MVCC::clone_oldest_view,trx_purge,srv_do_purge,std::__shared_ptr,lock_clust_rec_read_check_and_lock,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,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 mutex_enter_inline,latch_peeked_shard_and_do,ha_innobase::external_lock,handler::ha_external_lock,lock_external,lock_tables,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 __GI___pthread_self,std::__atomic_base,mem_heap_create,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 __GI___libc_malloc,std_allocator,String::real_alloc,String::set_int,String::length,Prepared_statement::insert_parameters,Prepared_statement::set_parameters,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 __GI___libc_malloc,std_allocator,String::mem_realloc,String::mem_realloc_exp,String::append,Opt_trace_struct::add_utf8,Optimize_table_order::calculate_scan_cost,Optimize_table_order::best_access_path,const,Optimize_table_order::greedy_search,Optimize_table_order::choose_table_order,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 __GI___libc_malloc,std_allocator,std::__uniq_ptr_impl,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,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,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 Encryption::is_encrypted_page,Encryption::decrypt,os_file_io_complete,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_normal::get,Buf_fetch::single_page,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open,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 dtuple_t::compare,page_cur_search_with_match,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 do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 do_add,check_result_and_overflow,AggregateIterator::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 dirname_length,dirname_part,fn_format,TABLE::init_tmp_table,create_tmp_table,JOIN::create_intermediate_table,JOIN::make_tmp_tables_info,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 dict_table_t::get_col,ha_innobase::build_template,ha_innobase::change_active_index,handler::ha_index_init,InitIndexRangeScan,IndexRangeScanIterator::shared_reset,IndexRangeScanIterator::Init,Sql_cmd_delete::delete_from_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 dict_table_t::get_col,ha_innobase::build_template,ha_innobase::change_active_index,handler::ha_index_init,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 dict_table_copy_types,row_build_low,row_build,row_upd_store_row,row_upd_del_mark_clust_rec,row_upd,row_update_for_mysql_using_upd_graph,ha_innobase::delete_row,handler::ha_delete_row,DeleteCurrentRowAndProcessTriggers,Sql_cmd_delete::delete_from_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 dict_index_t::get_field,rec_get_offsets,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,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 dict_index_t::get_field,btr_cur_del_mark_set_clust_rec,row_upd_del_mark_clust_rec,row_upd,row_update_for_mysql_using_upd_graph,ha_innobase::delete_row,handler::ha_delete_row,DeleteCurrentRowAndProcessTriggers,Sql_cmd_delete::delete_from_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 dict_index_get_n_fields,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,AggregateIterator::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 dict_index_get_n_fields,buf_block_t::get_page_zip,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 dict_index_copy_types,ha_innobase::change_active_index,handler::ha_index_init,InitIndexRangeScan,IndexRangeScanIterator::shared_reset,IndexRangeScanIterator::Init,Sql_cmd_delete::delete_from_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 dict_col_t::is_virtual,row_ins_index_entry_step,row_insert_for_mysql_using_ins_graph,row_insert_for_mysql,ha_innobase::write_row,handler::ha_write_row,write_record,Sql_cmd_insert_values::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 dict_col_t::copy_type,row_prebuilt_t::init_tuple_types,handler::ha_index_init,InitIndexRangeScan,IndexRangeScanIterator::shared_reset,IndexRangeScanIterator::Init,init_table_iterator,std::__uniq_ptr_impl,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_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,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,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 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,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 Buf_fetch::check_state,buf_page_get_gen,page_size_t::physical,buf_page_io_complete,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 1 Buf_fetch::check_state,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_fetch::check_state,buf_page_get_gen,btr_cur_search_to_nth_level,btr_pcur_t::open,row_purge_remove_sec_if_poss_leaf,row_purge_remove_sec_if_poss,que_thr_step,std::__atomic_base