Waiting 450 seconds before starting pt-pmp profiling... Starting stack trace collection at Thu Apr 30 05:36:22 PM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Thu Apr 30 05:36:22 PM UTC 2026 978 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 27 __futex_abstimed_wait_common64,__pthread_cond_wait_common,os_event::wait,buf_flush_await_no_flushing,buf_LRU_get_free_block,buf_page_init_for_read,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 24 __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_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_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 24 __GI_fdatasync,os_file_fsync_posix,os_file_flush_func,pfs_os_file_flush_func,log_flush_low,operator,std::__shared_ptr,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 __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,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 3 __libc_pwrite64,os_file_io,os_file_pwrite,os_file_write_func,pfs_os_aio_func,fil_io,Double_write::write_to_datafile,Double_write::sync_page_flush,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,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 3 __futex_abstimed_wait_common64,__pthread_cond_wait_common,os_event::wait,sync_array_wait_event,rw_lock_s_lock_spin,std::this_thread::get_id,Buf_fetch::single_page,buf_page_get_gen,btr_block_get_func,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,std::__atomic_base,fil_space_get,buf_page_t::space_id_changed,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 pfs_rw_lock_x_lock_func,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 pfs_rw_lock_s_lock_func,run_with_hint,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 monitor_inc_value_nocheck,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,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_inc_value_nocheck,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 1 _mm_crc32_u64,buf_calc_page_crc32,buf_flush_init_for_writing,buf_flush_write_block_low,buf_flush_try_neighbors,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_coordinator_thread,std::__shared_ptr