# To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 1K of event 'cycles' # Event count (approx.): 40354533516 # # Children Self Command Shared Object Symbol # ........ ........ ....... .................. .................................................... # 99.88% 0.00% mysqld libpthread-2.31.so [.] start_thread | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command | --99.88%--dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] pfs_spawn_thread | ---pfs_spawn_thread handle_one_connection do_handle_one_connection do_command | --99.88%--dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] handle_one_connection | ---handle_one_connection do_handle_one_connection do_command | --99.88%--dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] do_handle_one_connection | ---do_handle_one_connection do_command | --99.88%--dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] do_command | ---do_command | --99.88%--dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] dispatch_command | ---dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] mysql_parse | ---mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] mysql_execute_command | ---mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] execute_sqlcom_select | ---execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] handle_select | ---handle_select mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] mysql_select | ---mysql_select JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] JOIN::exec | ---JOIN::exec JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.88% 0.00% mysqld mariadbd [.] JOIN::exec_inner | ---JOIN::exec_inner | --99.52%--sub_select | |--92.67%--join_read_next | | | --92.12%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --6.03%--evaluate_join_record | --4.57%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 99.79% 1.01% mysqld mariadbd [.] sub_select | |--98.78%--sub_select | | | |--92.67%--join_read_next | | | | | --92.12%--handler::ha_index_next | | | | | |--77.71%--ha_innobase::index_next | | | | | | | --65.21%--row_search_mvcc | | | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | | | --1.10%--buf_page_optimistic_get | | | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.01%--rec_get_offsets_func | | | | | |--7.01%--gettimeofday@plt | | | | | --6.39%--my_timer_microseconds | | | | | |--2.65%--0x7fff8eeb0658 | | | | | --1.64%--__vdso_gettimeofday | | | --6.03%--evaluate_join_record | | | --4.57%--end_send_group | | | |--1.19%--Item_sum_count::add | | | | | --1.10%--Aggregator_simple::arg_is_null | | | --0.55%--test_if_group_changed | --1.01%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --0.73%--sub_select 92.76% 0.46% mysqld mariadbd [.] join_read_next | --92.30%--join_read_next | --92.12%--handler::ha_index_next | |--77.71%--ha_innobase::index_next | | | --65.21%--row_search_mvcc | | | |--48.09%--sel_restore_position_for_mysql | | | | | --48.00%--btr_pcur_t::restore_position | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | --1.10%--buf_page_optimistic_get | | | |--3.94%--row_sel_store_mysql_rec | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | --1.01%--rec_get_offsets_func | |--7.01%--gettimeofday@plt | --6.39%--my_timer_microseconds | |--2.65%--0x7fff8eeb0658 | --1.64%--__vdso_gettimeofday 92.21% 1.01% mysqld mariadbd [.] handler::ha_index_next | |--91.21%--handler::ha_index_next | | | |--77.71%--ha_innobase::index_next | | | | | --65.21%--row_search_mvcc | | | | | |--48.09%--sel_restore_position_for_mysql | | | | | | | --48.00%--btr_pcur_t::restore_position | | | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | | | --1.10%--buf_page_optimistic_get | | | | | |--3.94%--row_sel_store_mysql_rec | | | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | | | --1.01%--rec_get_offsets_func | | | |--7.01%--gettimeofday@plt | | | --6.39%--my_timer_microseconds | | | |--2.65%--0x7fff8eeb0658 | | | --1.64%--__vdso_gettimeofday | --1.01%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next | --0.92%--handler::ha_index_next 77.71% 10.95% mysqld mariadbd [.] ha_innobase::index_next | |--66.76%--ha_innobase::index_next | | | --65.21%--row_search_mvcc | | | |--48.09%--sel_restore_position_for_mysql | | | | | --48.00%--btr_pcur_t::restore_position | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | --1.10%--buf_page_optimistic_get | | | |--3.94%--row_sel_store_mysql_rec | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | --1.01%--rec_get_offsets_func | --10.95%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next 65.30% 8.52% mysqld mariadbd [.] row_search_mvcc | |--56.78%--row_search_mvcc | | | |--48.09%--sel_restore_position_for_mysql | | | | | --48.00%--btr_pcur_t::restore_position | | | | | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | | | | | --1.10%--buf_page_optimistic_get | | | |--3.94%--row_sel_store_mysql_rec | | | | | --1.28%--row_sel_field_store_in_mysql_format_func | | | --1.01%--rec_get_offsets_func | --8.52%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next | --8.43%--row_search_mvcc 48.09% 0.09% mysqld mariadbd [.] sel_restore_position_for_mysql | --48.00%--sel_restore_position_for_mysql btr_pcur_t::restore_position | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | --1.10%--buf_page_optimistic_get 48.00% 0.27% mysqld mariadbd [.] btr_pcur_t::restore_position | --47.72%--btr_pcur_t::restore_position | |--46.62%--buf::Block_hint::buffer_fix_block_if_still_valid | --1.10%--buf_page_optimistic_get 46.62% 46.53% mysqld mariadbd [.] buf::Block_hint::buffer_fix_block_if_still_valid | --46.53%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next row_search_mvcc sel_restore_position_for_mysql btr_pcur_t::restore_position buf::Block_hint::buffer_fix_block_if_still_valid 13.50% 9.02% mysqld mariadbd [.] my_timer_microseconds | |--9.02%--start_thread | pfs_spawn_thread | handle_one_connection | do_handle_one_connection | do_command | dispatch_command | mysql_parse | mysql_execute_command | execute_sqlcom_select | handle_select | mysql_select | JOIN::exec | JOIN::exec_inner | sub_select | join_read_next | handler::ha_index_next | | | |--7.01%--gettimeofday@plt | | | --2.01%--my_timer_microseconds | --4.48%--my_timer_microseconds | |--2.65%--0x7fff8eeb0658 | --1.64%--__vdso_gettimeofday 7.10% 0.09% mysqld mariadbd [.] gettimeofday@plt | --7.01%--gettimeofday@plt 6.39% 0.91% mysqld mariadbd [.] evaluate_join_record | |--5.48%--evaluate_join_record | | | --4.57%--end_send_group | | | |--1.19%--Item_sum_count::add | | | | | --1.10%--Aggregator_simple::arg_is_null | | | --0.55%--test_if_group_changed | --0.91%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select | --0.82%--evaluate_join_record 5.21% 3.20% mysqld mariadbd [.] end_send_group | |--3.20%--start_thread | pfs_spawn_thread | handle_one_connection | do_handle_one_connection | do_command | dispatch_command | mysql_parse | mysql_execute_command | execute_sqlcom_select | handle_select | mysql_select | JOIN::exec | JOIN::exec_inner | sub_select | evaluate_join_record | | | --2.56%--end_send_group | --2.01%--end_send_group | |--1.19%--Item_sum_count::add | | | --1.10%--Aggregator_simple::arg_is_null | --0.55%--test_if_group_changed 4.12% 2.84% mysqld mariadbd [.] row_sel_store_mysql_rec | |--2.84%--start_thread | pfs_spawn_thread | handle_one_connection | do_handle_one_connection | do_command | dispatch_command | mysql_parse | mysql_execute_command | execute_sqlcom_select | handle_select | mysql_select | JOIN::exec | JOIN::exec_inner | sub_select | join_read_next | handler::ha_index_next | ha_innobase::index_next | row_search_mvcc | | | --2.66%--row_sel_store_mysql_rec | --1.28%--row_sel_store_mysql_rec row_sel_field_store_in_mysql_format_func 2.65% 2.65% mysqld [vdso] [.] 0x0000000000000655 | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next my_timer_microseconds 0x7fff8eeb0658 2.65% 0.00% mysqld [vdso] [.] 0x00007fff8eeb0658 | ---0x7fff8eeb0658 1.83% 0.27% mysqld mariadbd [.] Item_sum_count::add | --1.56%--Item_sum_count::add | --1.10%--Aggregator_simple::arg_is_null 1.73% 1.64% mysqld [vdso] [.] __vdso_gettimeofday | --1.64%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next my_timer_microseconds __vdso_gettimeofday 1.46% 1.46% mysqld mariadbd [.] row_sel_field_store_in_mysql_format_func | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next row_search_mvcc | --1.28%--row_sel_store_mysql_rec row_sel_field_store_in_mysql_format_func 1.28% 1.01% mysqld mariadbd [.] Aggregator_simple::arg_is_null | --1.01%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select evaluate_join_record end_send_group Item_sum_count::add Aggregator_simple::arg_is_null 1.10% 0.92% mysqld mariadbd [.] buf_page_optimistic_get | --0.92%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next row_search_mvcc sel_restore_position_for_mysql btr_pcur_t::restore_position buf_page_optimistic_get 1.01% 1.01% mysqld mariadbd [.] rec_get_offsets_func | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next row_search_mvcc rec_get_offsets_func 0.82% 0.64% mysqld mariadbd [.] test_if_group_changed | --0.64%--start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select evaluate_join_record end_send_group | --0.55%--test_if_group_changed 0.82% 0.82% mysqld libc-2.31.so [.] 0x000000000016eb4a | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next 0.82% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233cb4e | ---0x7f9c5233cb4e 0.64% 0.18% mysqld mariadbd [.] trx_is_interrupted 0.55% 0.55% mysqld mariadbd [.] thd_kill_level | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select join_read_next handler::ha_index_next ha_innobase::index_next row_search_mvcc 0.46% 0.09% mysqld mariadbd [.] btr_pcur_store_position 0.37% 0.09% mysqld mariadbd [.] mtr_t::commit 0.37% 0.37% mysqld libc-2.31.so [.] 0x000000000016eb44 0.37% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233cb48 0.37% 0.37% mysqld mariadbd [.] row_sel_enqueue_cache_row_for_mysql 0.36% 0.36% mysqld libc-2.31.so [.] 0x000000000016eb4e 0.36% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233cb50 0.28% 0.28% mysqld mariadbd [.] mtr_memo_slot_t::release 0.27% 0.18% mysqld mariadbd [.] row_search_idx_cond_check 0.27% 0.27% mysqld mariadbd [.] rec_copy_prefix_to_buf 0.27% 0.27% mysqld libc-2.31.so [.] 0x000000000016eb07 0.27% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233cb44 0.27% 0.27% mysqld mariadbd [.] handler_rowid_filter_is_active 0.27% 0.18% mysqld mariadbd [.] memcpy@plt 0.27% 0.27% mysqld mariadbd [.] mtr_t::mtr_t 0.18% 0.00% mysqld [kernel.kallsyms] [k] asm_sysvec_apic_timer_interrupt 0.18% 0.00% mysqld [kernel.kallsyms] [k] sysvec_apic_timer_interrupt 0.18% 0.00% mysqld [kernel.kallsyms] [k] __sysvec_apic_timer_interrupt 0.18% 0.00% mysqld [kernel.kallsyms] [k] hrtimer_interrupt 0.18% 0.00% mysqld [kernel.kallsyms] [k] __hrtimer_run_queues 0.18% 0.00% mysqld [kernel.kallsyms] [k] tick_sched_timer 0.18% 0.18% mysqld mariadbd [.] buf_page_make_young_if_needed 0.18% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233ca90 0.12% 0.12% mysqld [kernel.kallsyms] [k] syscall_return_via_sysret 0.12% 0.00% mysqld libc-2.31.so [.] clock_gettime 0.12% 0.00% mysqld [vdso] [.] __vdso_clock_gettime 0.09% 0.09% mysqld mariadbd [.] process_gap_time_tracker 0.09% 0.09% mysqld libc-2.31.so [.] 0x000000000016ea97 0.09% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233cafa 0.09% 0.09% mysqld [kernel.kallsyms] [k] native_read_msr 0.09% 0.00% mysqld [kernel.kallsyms] [k] tick_sched_handle 0.09% 0.00% mysqld [kernel.kallsyms] [k] update_process_times 0.09% 0.00% mysqld [kernel.kallsyms] [k] scheduler_tick 0.09% 0.00% mysqld [kernel.kallsyms] [k] arch_scale_freq_tick 0.09% 0.09% mysqld [kernel.kallsyms] [k] tick_do_update_jiffies64 0.09% 0.00% mysqld [kernel.kallsyms] [k] tick_sched_do_timer 0.09% 0.09% mysqld mariadbd [.] buf_page_get_low 0.09% 0.00% mysqld mariadbd [.] Row_sel_get_clust_rec_for_mysql::operator() 0.09% 0.00% mysqld mariadbd [.] btr_cur_t::search_leaf 0.09% 0.09% mysqld libc-2.31.so [.] 0x000000000016ea90 0.09% 0.00% mysqld libc-2.31.so [.] 0x00007f9c5233ca93 0.09% 0.09% mysqld [vdso] [.] 0x000000000000065e 0.09% 0.00% mysqld [vdso] [.] 0x00007fff8eeb0661 0.00% 0.00% mysqld [kernel.kallsyms] [k] native_write_msr 0.00% 0.00% mysqld mariadbd [.] my_net_read_packet 0.00% 0.00% mysqld mariadbd [.] my_net_read_packet_reallen 0.00% 0.00% mysqld mariadbd [.] my_real_read 0.00% 0.00% mysqld mariadbd [.] vio_read 0.00% 0.00% mysqld mariadbd [.] vio_socket_io_wait 0.00% 0.00% mysqld libc-2.31.so [.] __poll 0.00% 0.00% mysqld [kernel.kallsyms] [k] entry_SYSCALL_64_after_hwframe 0.00% 0.00% mysqld [kernel.kallsyms] [k] do_syscall_64 0.00% 0.00% mysqld [kernel.kallsyms] [k] __x64_sys_poll 0.00% 0.00% mysqld [kernel.kallsyms] [k] do_sys_poll 0.00% 0.00% mysqld [kernel.kallsyms] [k] schedule_hrtimeout_range_clock 0.00% 0.00% mysqld [kernel.kallsyms] [k] schedule 0.00% 0.00% mysqld [kernel.kallsyms] [k] __schedule 0.00% 0.00% mysqld [kernel.kallsyms] [k] finish_task_switch 0.00% 0.00% mysqld [kernel.kallsyms] [k] __perf_event_task_sched_in 0.00% 0.00% mysqld [kernel.kallsyms] [k] __intel_pmu_enable_all.constprop.0 # # (Tip: Treat branches as callchains: perf report --branch-history) #