Waiting 450 seconds before starting pt-pmp profiling... Starting stack trace collection at Thu May 7 06:17:07 AM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Thu May 7 06:17:08 AM UTC 2026 986 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 29 __futex_abstimed_wait_common64,__pthread_cond_wait_common,os_event::timed_wait,os_event::wait_time_low,os_event_wait_for,temptable::Cell_calculator::hash,my_hash_combine,std::_Hashtable,std::__atomic_base,PolicyMutex,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 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,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 PolicyMutex,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 plugin_unlock,close_tmp_table,QEP_TAB::cleanup,JOIN::destroy,Query_block::cleanup,Query_terms<,std::__cxx11::basic_string,TrxInInnoDB::exit,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 mutex_enter_inline,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_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 mutex_enter_inline,buf_pool_t::is_flushing,buf_page_io_complete,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 1 mutex_enter_inline,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_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 mutex_enter_inline,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_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 mtr_t::Command::release_all,mtr_t::commit,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 monitor_atomic_dec,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 1 _mm_crc32_u64,buf_calc_page_crc32,buf_flush_init_for_writing,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 1 __memset_evex_unaligned_erms,unsigned,get_ranges_from_tree_given_base,get_ranges_from_tree,get_key_scans_params,test_quick_select,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 __memset_evex_unaligned_erms,std::_Sp_counted_base<,std::_Hashtable,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 1 lock_clust_rec_cons_read_sees,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 lob::undo_vers_t::reset,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 lll_mutex_unlock_optimized,OSMutex::exit,sync_array_get_and_reserve_cell,TTASEventMutex::spin_and_try_lock,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_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 lll_mutex_unlock_optimized,OSMutex::exit,log_write_notifier,std::__shared_ptr,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 futex_wake,os_event::broadcast,rw_lock_x_unlock_func,PolicyMutex,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 futex_wait,__pthread_mutex_cond_lock,__pthread_cond_wait_common,os_event::wait,sync_array_wait_event,TTASEventMutex::wait,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,trx_purge_rseg_get_next_history_log,trx_purge_choose_next_log,trx_purge,srv_do_purge,std::__shared_ptr