Waiting 450 seconds before starting pt-pmp profiling... Starting stack trace collection at Wed May 6 03:40:00 PM UTC 2026 Collecting stack traces using pt-pmp (auto-detecting mysqld) ================================================ Wed May 6 03:40:01 PM UTC 2026 984 syscall,__io_getevents_0_4(libaio.so.1.0.1),LinuxAIOHandler::collect,LinuxAIOHandler::poll,os_aio_linux_handler,fil_aio_wait,std::atomic::load,std::thread::_State_impl,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 21 __futex_abstimed_wait_common64,__pthread_cond_wait_common,os_event::wait,buf_flush_page_cleaner_thread,std::thread::_State_impl,temptable::Indexed_cells_hash::operator,temptable::Hash_unique::insert,at,temptable::Table::insert,temptable::Handler::write_row,handler::ha_write_row,,,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 5 __libc_pwrite64,os_file_io,os_file_pwrite,os_file_write_func,write_blocks,log_writer,std::thread::_State_impl,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 2 Slow_log_throttle::log,log_slow_applicable,log_slow_statement,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 skip_trailing_space,Field_string::val_str,Protocol::store,THD::send_result_set_row,Query_result_send::send_data,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 skip_trailing_space,Field_string::val_str,make_sortkey_from_item,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 2 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 2 row_sel_dequeue_cached_row_for_mysql,row_search_mvcc,ha_innobase::general_fetch,handler::ha_index_next,handler::read_range_next,handler::multi_range_read_next,handler::ha_multi_range_read_next,IndexRangeScanIterator::Read,FilterIterator::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 2 rec_init_offsets_comp_ordinary,rec_get_offsets,row_search_mvcc,ha_innobase::index_read,handler::ha_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 2 parse_query_bind_params,Protocol_classic::parse_packet,Protocol_classic::get_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 os_event_wait_for,std::__atomic_base,log_t&,,trx_flush_log_if_needed_low,trx_commit_complete_for_mysql,innobase_commit,ha_commit_low,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 2 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,Protocol_classic::send_eof,THD::send_statement_status,dispatch_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 2 libssl::??(libssl.so.3),libssl::??(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 2 libssl::??(libssl.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 2 __libc_pwrite64,os_file_io,os_file_pwrite,os_file_write_func,const*,,Double_write::write_pages,dblwr::write,buf_flush_write_block_low,buf_flush_try_neighbors,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_cleaner_thread,std::thread::_State_impl,Query_terms<,std::__cxx11::basic_string::VisibleFieldsAdapter,Query_result_send::send_data,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 validate_rec_offset,rec_offs_nth_extern,row_sel_store_mysql_field,row_sel_store_mysql_rec,row_search_mvcc,ha_innobase::index_read,handler::ha_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 ut_list_insert,trx_undo_report_row_operation,btr_cur_upd_lock_and_undo,row_upd_clust_rec,row_upd_clust_step,row_upd,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 std::__insertion_sort<__gnu_cxx::__normal_iterator,PolicyMutex,buf_page_io_complete,fil_aio_wait,std::atomic::load,std::thread::_State_impl,lock_clust_rec_read_check_and_lock,row_search_mvcc,ha_innobase::index_read,handler::ha_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,std::atomic::load,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_make_young,Buf_fetch::single_page,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,row_search_mvcc,ha_innobase::index_read,handler::ha_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_start_stage_v1,THD::enter_stage,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 page_simple_validate_new,Double_write::check_block,Double_write::prepare,Double_write::write_to_datafile,Double_write::write_data_pages,dblwr::write,buf_flush_write_block_low,buf_flush_try_neighbors,buf_flush_LRU_list_batch,buf_flush_LRU_list,buf_flush_page_coordinator_thread,std::thread::_State_impl,ha_innobase::external_lock,handler::ha_external_lock,unlock_external,mysql_unlock_tables,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 mutex_enter_inline,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,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,row_search_mvcc,ha_innobase::index_read,handler::ha_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::Command::release_resources,row_search_mvcc,ha_innobase::general_fetch,handler::ha_index_next,handler::read_range_next,handler::multi_range_read_next,handler::ha_multi_range_read_next,IndexRangeScanIterator::Read,FilterIterator::Read,,,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_t::Command::release_all,mtr_t::Command::release_resources,btr_estimate_n_rows_in_range_low,btr_estimate_n_rows_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_dec,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,btr_cur_search_to_nth_level,btr_pcur_t::open_no_init,row_search_mvcc,ha_innobase::index_read,handler::ha_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 mlog_write_initial_log_record_fast,ut_align_offset,trx_undo_set_state_at_finish,trx_write_serialisation_history,trx_commit_low,trx_commit,monitor_dec,innobase_commit_low,ha_commit_low,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 mlog_write_initial_log_record_fast,ut_align_offset,flst_init,trx_undo_seg_create,trx_undo_report_row_operation,btr_cur_upd_lock_and_undo,row_upd_clust_rec,row_upd_clust_step,row_upd,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,TABLE::init,in_LTM,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 memset,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,LinuxAIOHandler::collect,LinuxAIOHandler::poll,os_aio_linux_handler,fil_aio_wait,std::atomic::load,std::thread::_State_impl,std::__atomic_base,mem_heap_create,row_ins_clust_index_entry_low,row_ins_clust_index_entry,row_ins,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 _int_malloc,__GI___libc_malloc,redirecting_allocator,MEM_ROOT::AllocBlock,MEM_ROOT::ForceNewBlock,parse_query_bind_params,Protocol_classic::parse_packet,Protocol_classic::get_command,do_command,handle_connection,pfs_spawn_thread,start_thread,__clone3 1 innobase_srv_conc_enter_innodb,ha_innobase::index_read,handler::ha_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 IndexRangeScanIterator::IndexRangeScanIterator,std::__uniq_ptr_data,buf_flush_page_coordinator_thread,std::thread::_State_impl