Waiting 450 seconds before starting pt-pmp profiling... Starting stack trace collection at Thu Apr 30 11:58:25 AM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Thu Apr 30 11:58:26 AM UTC 2026 966 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 43 __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 33 uca_scanner_any::next,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,temptable::Cell_calculator::hash,my_hash_combine,std::_Hashtable,std::__atomic_base,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*,,Double_write::is_fsync_required,dblwr::write,buf_flush_write_block_low,buf_flush_single_page_from_LRU,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_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 3 Item_field::bind_fields,bind_fields,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 gcm_cipher_internal(libcrypto.so.3),ossl_gcm_stream_update(libcrypto.so.3),EVP_DecryptUpdate(libcrypto.so.3),EVP_CipherUpdate(libcrypto.so.3),tls13_enc(libssl.so.3),ssl3_get_record(libssl.so.3),ssl3_read_bytes(libssl.so.3),ssl3_read_internal(libssl.so.3),ssl3_read(libssl.so.3),ssl_read_internal(libssl.so.3),SSL_read(libssl.so.3),vio_ssl_read,net_read_raw_loop,net_read_packet_header,net_read_uncompressed_packet,Protocol_classic::read_packet,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 3 futex_wait,lll_mutex_lock_optimized,OSMutex::enter,LinuxAIOHandler::find_completed_slot,LinuxAIOHandler::poll,os_aio_linux_handler,fil_aio_wait,std::atomic::load,std::__shared_ptr,buf_LRU_scan_and_free_block,buf_LRU_get_free_block,buf_page_init_for_read,buf_read_page_low,ib_counter_t,PolicyMutex,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_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 PolicyMutex,ibuf_merge_or_delete_for_page,buf_page_io_complete,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 pfs_ssl_bio_callback_ex,bio_call_callback(libcrypto.so.3),bio_write_intern(libcrypto.so.3),BIO_write(libcrypto.so.3),ssl3_write_pending(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 pfs_rw_lock_x_lock_func,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_cleaner_thread,std::__shared_ptr,my_internal_realloc,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 my_hash_sort_any_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 mutex_enter_inline,trx_purge_rseg_get_next_history_log,trx_purge_choose_next_log,trx_purge,srv_do_purge,std::__shared_ptr,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 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 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 handler::ha_statistic_increment,temptable::Handler::rnd_next,handler::ha_rnd_next,TableScanIterator::Read,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 handler::ha_statistic_increment,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 handler::handler,create_handler,get_new_handler,setup_tmp_table_handler,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 handler::ha_is_record_buffer_wanted,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 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 handler::ha_extra,close_thread_tables,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 ha_innobase::update_thd,ha_innobase::extra,close_thread_tables,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 ha_innobase::table_flags,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 ha_innobase::reset_template,ha_innobase::extra,aggregated_stats::get_shard,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 ha_innobase::read_time,handler::read_cost,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 ha_innobase::read_range_next,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 ha_innobase::multi_range_read_next,handler::ha_multi_range_read_next,IndexRangeScanIterator::Read,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 ha_innobase::lock_count,get_lock_data,mysql_lock_tables,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 ha_innobase::innobase_get_index,ha_innobase::info_low,Table_ref::fetch_number_of_rows,JOIN::init_planner_arrays,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 ha_innobase::index_next,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,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 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 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 ha_innobase::extra,handler::ha_reset,close_thread_table,close_open_tables,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 ha_innobase::extra,aggregated_stats::get_shard,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 ha_innobase::can_reuse_mysql_template,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 ha_innobase::build_template,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,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 ha_check_and_coalesce_trx_read_only,trans_commit_stmt,Diagnostics_area::set_overwrite_status,Prepared_statement::execute,Prepared_statement::execute_loop,mysqld_stmt_execute,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 __gnu_cxx::__normal_iterator