# To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 4K of event 'cycles:u' # Event count (approx.): 81135576962 # # Children Self Command Shared Object Symbol # ........ ........ ............... ................... ................................................................. # 98.90% 0.00% one_connection libc.so.6 [.] clone3 | ---clone3 start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.38%--do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.90% 0.00% one_connection libc.so.6 [.] start_thread | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.38%--do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.90% 0.00% one_connection mariadbd [.] pfs_spawn_thread | ---pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.38%--do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.90% 0.00% one_connection mariadbd [.] handle_one_connection | ---handle_one_connection do_handle_one_connection | --98.38%--do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.90% 0.00% one_connection mariadbd [.] do_handle_one_connection | ---do_handle_one_connection | --98.38%--do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.38% 0.00% one_connection mariadbd [.] do_command | ---do_command | --98.33%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.33% 0.02% one_connection mariadbd [.] dispatch_command | --98.31%--dispatch_command | --98.00%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 98.00% 0.02% one_connection mariadbd [.] mysql_parse | --97.98%--mysql_parse | --97.44%--mysql_execute_command | --97.25%--execute_sqlcom_select | --97.15%--handle_select mysql_select | --95.90%--JOIN::exec JOIN::exec_inner | |--94.30%--sub_select | | | |--68.62%--evaluate_join_record | | | | | |--56.25%--sub_select | | | | | | | |--31.84%--join_read_key2 | | | | | | | | | |--29.97%--handler::ha_index_read_map | | | | | | | | | | | --29.52%--ha_innobase::index_read | | | | | | | | | | | --28.61%--row_search_mvcc | | | | | | | | | | | |--19.71%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.14%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 97.48% 0.00% one_connection mariadbd [.] mysql_execute_command | ---mysql_execute_command | --97.29%--execute_sqlcom_select | --97.19%--handle_select mysql_select | --95.94%--JOIN::exec JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 97.29% 0.00% one_connection mariadbd [.] execute_sqlcom_select | ---execute_sqlcom_select | --97.19%--handle_select mysql_select | --95.94%--JOIN::exec JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 97.19% 0.00% one_connection mariadbd [.] handle_select | ---handle_select mysql_select | --95.94%--JOIN::exec JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 97.19% 0.00% one_connection mariadbd [.] mysql_select | ---mysql_select | --95.94%--JOIN::exec JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 95.94% 0.00% one_connection mariadbd [.] JOIN::exec | ---JOIN::exec JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 95.94% 0.00% one_connection mariadbd [.] JOIN::exec_inner | ---JOIN::exec_inner | |--94.34%--sub_select | | | |--68.66%--evaluate_join_record | | | | | |--56.29%--sub_select | | | | | | | |--31.88%--join_read_key2 | | | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | | | --1.16%--cp_buffer_from_ref | | | | | | | --23.74%--evaluate_join_record | | | | | | | --22.98%--end_update | | | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | | | --12.61%--heap_rkey | | | | | | | | | --12.17%--hp_search | | | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | | | --5.60%--ha_heap::write_row | | | | | | | | | --5.33%--heap_write | | | | | | | | | --4.85%--hp_write_key | | | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.72%--Field::save_in_field_str | | | | | | | --1.56%--Field_varstring::store | | | | | --10.28%--Item_cond_and::val_bool | | | | | --9.12%--Item_func_between::val_bool | | | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | | | --6.07%--Field::val_datetime_packed | | | | | --4.45%--Field_timestamp::get_date | | | | | --3.89%--THD::timestamp_to_TIME | | | | | --3.37%--sec_to_TIME | | | --25.55%--rr_sequential | | | --25.36%--handler::ha_rnd_next | | | --24.30%--ha_innobase::general_fetch | | | --23.40%--row_search_mvcc | | | |--8.32%--row_sel_store_mysql_rec | | | | | |--5.27%--row_sel_store_mysql_field | | | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--4.69%--rec_get_offsets_func | | | | | --4.17%--rec_init_offsets_comp_ordinary | | | --1.19%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 94.48% 0.64% one_connection mariadbd [.] sub_select | --93.84%--sub_select | |--68.14%--evaluate_join_record | | | |--55.77%--sub_select | | | | | |--31.88%--join_read_key2 | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | --1.16%--cp_buffer_from_ref | | | | | --23.74%--evaluate_join_record | | | | | --22.98%--end_update | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | --12.61%--heap_rkey | | | | | | | --12.17%--hp_search | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | --5.60%--ha_heap::write_row | | | | | | | --5.33%--heap_write | | | | | | | --4.85%--hp_write_key | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | --1.72%--Field::save_in_field_str | | | | | --1.56%--Field_varstring::store | | | --10.28%--Item_cond_and::val_bool | | | --9.12%--Item_func_between::val_bool | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | --6.07%--Field::val_datetime_packed | | | --4.45%--Field_timestamp::get_date | | | --3.89%--THD::timestamp_to_TIME | | | --3.37%--sec_to_TIME | --25.69%--rr_sequential | --25.36%--handler::ha_rnd_next | --24.30%--ha_innobase::general_fetch | --23.40%--row_search_mvcc | |--8.32%--row_sel_store_mysql_rec | | | |--5.27%--row_sel_store_mysql_field | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | --1.33%--fts_get_doc_id_from_rec | |--4.69%--rec_get_offsets_func | | | --4.17%--rec_init_offsets_comp_ordinary | --1.19%--sel_restore_position_for_mysql btr_pcur_t::restore_position 68.77% 2.32% one_connection mariadbd [.] evaluate_join_record | |--66.44%--evaluate_join_record | | | |--55.96%--sub_select | | | | | |--31.88%--join_read_key2 | | | | | | | |--29.99%--handler::ha_index_read_map | | | | | | | | | --29.54%--ha_innobase::index_read | | | | | | | | | --28.63%--row_search_mvcc | | | | | | | | | |--19.73%--btr_cur_t::search_leaf | | | | | | | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | | | | | | | |--4.59%--buf_page_get_gen | | | | | | | | | | | |--4.07%--page_cur_search_with_match | | | | | | | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | | | | | | | --1.77%--cmp_data | | | | | | | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | | | | | | | --1.12%--mtr_memo_slot_t::release | | | | | | | | | |--1.72%--row_sel_store_mysql_rec | | | | | | | | | | | --1.08%--row_sel_store_mysql_field | | | | | | | | | |--1.64%--rec_get_offsets_func | | | | | | | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | | | | | | | --1.20%--cmp_dtuple_rec_with_match_low | | | | | | | --1.16%--cp_buffer_from_ref | | | | | --23.41%--evaluate_join_record | | | | | --22.98%--end_update | | | | | |--12.94%--handler::ha_index_read_map | | | | | | | --12.61%--heap_rkey | | | | | | | --12.17%--hp_search | | | | | | | |--6.86%--hp_key_cmp | | | | | | | | | |--3.26%--my_charpos_mb | | | | | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | --3.14%--my_uca_hash_sort_utf8mb4 | | | | | |--5.66%--handler::ha_write_tmp_row | | | | | | | --5.60%--ha_heap::write_row | | | | | | | --5.33%--heap_write | | | | | | | --4.85%--hp_write_key | | | | | | | --3.09%--hp_rec_hashnr | | | | | | | --2.07%--my_uca_hash_sort_utf8mb4 | | | | | --1.72%--Field::save_in_field_str | | | | | --1.56%--Field_varstring::store | | | --10.32%--Item_cond_and::val_bool | | | --9.12%--Item_func_between::val_bool | | | --8.12%--Item_func_between::val_int_cmp_datetime | | | --6.07%--Field::val_datetime_packed | | | --4.45%--Field_timestamp::get_date | | | --3.89%--THD::timestamp_to_TIME | | | --3.37%--sec_to_TIME | --2.32%--clone3 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 52.26% 7.33% one_connection mariadbd [.] row_search_mvcc | |--44.93%--row_search_mvcc | | | |--19.73%--btr_cur_t::search_leaf | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | |--4.59%--buf_page_get_gen | | | | | |--4.07%--page_cur_search_with_match | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | --1.77%--cmp_data | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | --1.12%--mtr_memo_slot_t::release | | | |--10.08%--row_sel_store_mysql_rec | | | | | |--6.38%--row_sel_store_mysql_field | | | | | | | |--2.39%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.29%--__memmove_avx512_unaligned_erms | | | | | --1.33%--fts_get_doc_id_from_rec | | | |--6.34%--rec_get_offsets_func | | | | | --5.48%--rec_init_offsets_comp_ordinary | | | |--1.20%--cmp_dtuple_rec_with_match_low | | | |--1.19%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | |--1.18%--mtr_t::commit | | | --1.14%--btr_pcur_store_position | --7.33%--clone3 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 | |--5.03%--rr_sequential | handler::ha_rnd_next | ha_innobase::general_fetch | row_search_mvcc | --2.30%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 42.93% 0.64% one_connection mariadbd [.] handler::ha_index_read_map | --42.29%--handler::ha_index_read_map | |--29.54%--ha_innobase::index_read | | | --28.63%--row_search_mvcc | | | |--19.73%--btr_cur_t::search_leaf | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | |--4.59%--buf_page_get_gen | | | | | |--4.07%--page_cur_search_with_match | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | --1.77%--cmp_data | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | --1.12%--mtr_memo_slot_t::release | | | |--1.72%--row_sel_store_mysql_rec | | | | | --1.08%--row_sel_store_mysql_field | | | |--1.64%--rec_get_offsets_func | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | --1.20%--cmp_dtuple_rec_with_match_low | --12.61%--heap_rkey | --12.17%--hp_search | |--6.86%--hp_key_cmp | | | |--3.26%--my_charpos_mb | | | | | --1.67%--my_charlen_utf8mb4 | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | --3.14%--my_uca_hash_sort_utf8mb4 31.88% 0.15% one_connection mariadbd [.] join_read_key2 | --31.74%--join_read_key2 | |--29.99%--handler::ha_index_read_map | | | --29.54%--ha_innobase::index_read | | | --28.63%--row_search_mvcc | | | |--19.73%--btr_cur_t::search_leaf | | | | | |--7.13%--page_cur_search_with_match_bytes | | | | | | | --4.70%--cmp_dtuple_rec_bytes | | | | | |--4.59%--buf_page_get_gen | | | | | |--4.07%--page_cur_search_with_match | | | | | | | --2.91%--page_cur_dtuple_cmp | | | | | | | --1.77%--cmp_data | | | | | --1.45%--mtr_t::rollback_to_savepoint | | | | | --1.12%--mtr_memo_slot_t::release | | | |--1.72%--row_sel_store_mysql_rec | | | | | --1.08%--row_sel_store_mysql_field | | | |--1.64%--rec_get_offsets_func | | | | | --1.31%--rec_init_offsets_comp_ordinary | | | --1.20%--cmp_dtuple_rec_with_match_low | --1.16%--cp_buffer_from_ref 29.58% 0.42% one_connection mariadbd [.] ha_innobase::index_read | --29.16%--ha_innobase::index_read | --28.67%--row_search_mvcc | |--19.73%--btr_cur_t::search_leaf | | | |--7.13%--page_cur_search_with_match_bytes | | | | | --4.70%--cmp_dtuple_rec_bytes | | | |--4.59%--buf_page_get_gen | | | |--4.07%--page_cur_search_with_match | | | | | --2.91%--page_cur_dtuple_cmp | | | | | --1.77%--cmp_data | | | --1.45%--mtr_t::rollback_to_savepoint | | | --1.12%--mtr_memo_slot_t::release | |--1.74%--row_sel_store_mysql_rec | | | --1.10%--row_sel_store_mysql_field | |--1.64%--rec_get_offsets_func | | | --1.31%--rec_init_offsets_comp_ordinary | --1.20%--cmp_dtuple_rec_with_match_low 25.69% 0.33% one_connection mariadbd [.] rr_sequential | --25.36%--rr_sequential handler::ha_rnd_next | --24.30%--ha_innobase::general_fetch | --23.40%--row_search_mvcc | |--8.32%--row_sel_store_mysql_rec | | | |--5.27%--row_sel_store_mysql_field | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | --1.33%--fts_get_doc_id_from_rec | |--4.69%--rec_get_offsets_func | | | --4.17%--rec_init_offsets_comp_ordinary | --1.19%--sel_restore_position_for_mysql btr_pcur_t::restore_position 25.66% 0.95% one_connection mariadbd [.] handler::ha_rnd_next | --24.71%--handler::ha_rnd_next | --24.34%--ha_innobase::general_fetch | --23.40%--row_search_mvcc | |--8.32%--row_sel_store_mysql_rec | | | |--5.27%--row_sel_store_mysql_field | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | --1.33%--fts_get_doc_id_from_rec | |--4.69%--rec_get_offsets_func | | | --4.17%--rec_init_offsets_comp_ordinary | --1.19%--sel_restore_position_for_mysql btr_pcur_t::restore_position 24.34% 0.94% one_connection mariadbd [.] ha_innobase::general_fetch | --23.40%--ha_innobase::general_fetch row_search_mvcc | |--8.32%--row_sel_store_mysql_rec | | | |--5.27%--row_sel_store_mysql_field | | | | | --2.08%--row_sel_field_store_in_mysql_format_func | | | --1.33%--fts_get_doc_id_from_rec | |--4.69%--rec_get_offsets_func | | | --4.17%--rec_init_offsets_comp_ordinary | --1.19%--sel_restore_position_for_mysql btr_pcur_t::restore_position 22.98% 0.27% one_connection mariadbd [.] end_update | --22.70%--end_update | |--12.94%--handler::ha_index_read_map | | | --12.61%--heap_rkey | | | --12.17%--hp_search | | | |--6.86%--hp_key_cmp | | | | | |--3.26%--my_charpos_mb | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | --3.14%--my_uca_hash_sort_utf8mb4 | |--5.66%--handler::ha_write_tmp_row | | | --5.60%--ha_heap::write_row | | | --5.33%--heap_write | | | --4.85%--hp_write_key | | | --3.09%--hp_rec_hashnr | | | --2.07%--my_uca_hash_sort_utf8mb4 | --1.72%--Field::save_in_field_str | --1.56%--Field_varstring::store 19.77% 1.68% one_connection mariadbd [.] btr_cur_t::search_leaf | |--18.09%--btr_cur_t::search_leaf | | | |--7.15%--page_cur_search_with_match_bytes | | | | | --4.70%--cmp_dtuple_rec_bytes | | | |--4.61%--buf_page_get_gen | | | |--4.07%--page_cur_search_with_match | | | | | --2.91%--page_cur_dtuple_cmp | | | | | --1.77%--cmp_data | | | --1.45%--mtr_t::rollback_to_savepoint | | | --1.12%--mtr_memo_slot_t::release | --1.66%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf 12.63% 0.33% one_connection mariadbd [.] heap_rkey | --12.29%--heap_rkey | --12.17%--hp_search | |--6.86%--hp_key_cmp | | | |--3.26%--my_charpos_mb | | | | | --1.67%--my_charlen_utf8mb4 | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | --3.14%--my_uca_hash_sort_utf8mb4 12.21% 1.39% one_connection mariadbd [.] hp_search | |--10.82%--hp_search | | | |--6.86%--hp_key_cmp | | | | | |--3.26%--my_charpos_mb | | | | | | | --1.67%--my_charlen_utf8mb4 | | | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | | | --3.14%--my_uca_hash_sort_utf8mb4 | --1.39%--clone3 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 sub_select evaluate_join_record end_update handler::ha_index_read_map heap_rkey hp_search 10.38% 0.91% one_connection mariadbd [.] Item_cond_and::val_bool | --9.47%--Item_cond_and::val_bool | --9.16%--Item_func_between::val_bool | --8.12%--Item_func_between::val_int_cmp_datetime | --6.07%--Field::val_datetime_packed | --4.45%--Field_timestamp::get_date | --3.89%--THD::timestamp_to_TIME | --3.37%--sec_to_TIME 10.25% 2.38% one_connection mariadbd [.] row_sel_store_mysql_rec | |--7.87%--row_sel_store_mysql_rec | | | |--6.54%--row_sel_store_mysql_field | | | | | |--2.39%--row_sel_field_store_in_mysql_format_func | | | | | --1.29%--__memmove_avx512_unaligned_erms | | | --1.33%--fts_get_doc_id_from_rec | --2.36%--clone3 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 | --1.72%--rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec 9.16% 0.60% one_connection mariadbd [.] Item_func_between::val_bool | --8.56%--Item_func_between::val_bool | --8.12%--Item_func_between::val_int_cmp_datetime | --6.07%--Field::val_datetime_packed | --4.45%--Field_timestamp::get_date | --3.89%--THD::timestamp_to_TIME | --3.37%--sec_to_TIME 8.12% 0.66% one_connection mariadbd [.] Item_func_between::val_int_cmp_datetime | --7.46%--Item_func_between::val_int_cmp_datetime | --6.07%--Field::val_datetime_packed | --4.45%--Field_timestamp::get_date | --3.89%--THD::timestamp_to_TIME | --3.37%--sec_to_TIME 7.17% 2.45% one_connection mariadbd [.] page_cur_search_with_match_bytes | |--4.72%--page_cur_search_with_match_bytes | cmp_dtuple_rec_bytes | --2.43%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf page_cur_search_with_match_bytes 6.92% 1.44% one_connection mariadbd [.] rec_get_offsets_func | |--5.48%--rec_get_offsets_func | rec_init_offsets_comp_ordinary | --1.42%--clone3 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 6.86% 1.02% one_connection mariadbd [.] hp_key_cmp | |--5.84%--hp_key_cmp | | | |--3.26%--my_charpos_mb | | | | | --1.67%--my_charlen_utf8mb4 | | | --2.42%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.20%--my_uca_scanner_next_utf8mb4.part.0 | --1.02%--clone3 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 sub_select evaluate_join_record end_update handler::ha_index_read_map heap_rkey hp_search hp_key_cmp 6.54% 2.86% one_connection mariadbd [.] row_sel_store_mysql_field | |--3.68%--row_sel_store_mysql_field | | | |--2.39%--row_sel_field_store_in_mysql_format_func | | | --1.29%--__memmove_avx512_unaligned_erms | --2.69%--clone3 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 | --2.22%--rr_sequential handler::ha_rnd_next | --2.20%--ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec row_sel_store_mysql_field 6.07% 0.56% one_connection mariadbd [.] Field::val_datetime_packed | --5.51%--Field::val_datetime_packed | --4.45%--Field_timestamp::get_date | --3.89%--THD::timestamp_to_TIME | --3.37%--sec_to_TIME 5.66% 0.06% one_connection mariadbd [.] handler::ha_write_tmp_row | --5.60%--handler::ha_write_tmp_row ha_heap::write_row | --5.33%--heap_write | --4.85%--hp_write_key | --3.09%--hp_rec_hashnr | --2.07%--my_uca_hash_sort_utf8mb4 5.60% 0.27% one_connection mariadbd [.] ha_heap::write_row | --5.33%--ha_heap::write_row heap_write | --4.85%--hp_write_key | --3.09%--hp_rec_hashnr | --2.07%--my_uca_hash_sort_utf8mb4 5.48% 5.48% one_connection mariadbd [.] rec_init_offsets_comp_ordinary | ---clone3 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 | |--4.17%--rr_sequential | handler::ha_rnd_next | ha_innobase::general_fetch | row_search_mvcc | rec_get_offsets_func | rec_init_offsets_comp_ordinary | --1.31%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc rec_get_offsets_func rec_init_offsets_comp_ordinary 5.33% 0.27% one_connection mariadbd [.] heap_write | --5.06%--heap_write | --4.85%--hp_write_key | --3.09%--hp_rec_hashnr | --2.07%--my_uca_hash_sort_utf8mb4 5.21% 3.68% one_connection mariadbd [.] my_uca_hash_sort_utf8mb4 | |--3.68%--clone3 | 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 | sub_select | evaluate_join_record | end_update | | | |--2.24%--handler::ha_index_read_map | | heap_rkey | | hp_search | | my_uca_hash_sort_utf8mb4 | | | --1.43%--handler::ha_write_tmp_row | ha_heap::write_row | heap_write | hp_write_key | hp_rec_hashnr | my_uca_hash_sort_utf8mb4 | --1.53%--my_uca_hash_sort_utf8mb4 my_uca_scanner_next_utf8mb4.part.0 4.89% 2.17% one_connection mariadbd [.] my_charpos_mb | |--2.72%--my_charpos_mb | my_charlen_utf8mb4 | --2.17%--clone3 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 sub_select evaluate_join_record end_update | --1.82%--handler::ha_index_read_map heap_rkey hp_search | --1.59%--hp_key_cmp my_charpos_mb 4.85% 1.51% one_connection mariadbd [.] hp_write_key | |--3.34%--hp_write_key | | | --3.09%--hp_rec_hashnr | | | --2.07%--my_uca_hash_sort_utf8mb4 | --1.51%--clone3 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 sub_select evaluate_join_record end_update handler::ha_write_tmp_row ha_heap::write_row heap_write hp_write_key 4.80% 3.82% one_connection mariadbd [.] buf_page_get_gen | --3.80%--clone3 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 | --3.62%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf buf_page_get_gen 4.72% 4.45% one_connection mariadbd [.] cmp_dtuple_rec_bytes | --4.43%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf page_cur_search_with_match_bytes cmp_dtuple_rec_bytes 4.45% 0.27% one_connection mariadbd [.] Field_timestamp::get_date | --4.18%--Field_timestamp::get_date | --3.89%--THD::timestamp_to_TIME | --3.37%--sec_to_TIME 4.07% 1.16% one_connection mariadbd [.] page_cur_search_with_match | |--2.91%--page_cur_search_with_match | page_cur_dtuple_cmp | | | --1.77%--cmp_data | --1.16%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf page_cur_search_with_match 3.95% 0.33% one_connection mariadbd [.] THD::timestamp_to_TIME | --3.62%--THD::timestamp_to_TIME | --3.44%--sec_to_TIME 3.44% 3.44% one_connection mariadbd [.] sec_to_TIME | --3.37%--clone3 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 Item_cond_and::val_bool Item_func_between::val_bool Item_func_between::val_int_cmp_datetime Field::val_datetime_packed Field_timestamp::get_date THD::timestamp_to_TIME sec_to_TIME 3.17% 3.17% one_connection libc.so.6 [.] __memmove_avx512_unaligned_erms | ---clone3 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 | --3.13%--JOIN::exec JOIN::exec_inner | --3.05%--sub_select | |--2.01%--rr_sequential | handler::ha_rnd_next | ha_innobase::general_fetch | row_search_mvcc | --1.04%--evaluate_join_record sub_select 3.09% 0.27% one_connection mariadbd [.] hp_rec_hashnr | --2.82%--hp_rec_hashnr | --2.07%--my_uca_hash_sort_utf8mb4 2.95% 1.14% one_connection mariadbd [.] page_cur_dtuple_cmp | |--1.81%--page_cur_dtuple_cmp | cmp_data | --1.14%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc btr_cur_t::search_leaf page_cur_search_with_match page_cur_dtuple_cmp 2.81% 2.81% one_connection mariadbd [.] my_uca_scanner_next_utf8mb4.part.0 | ---clone3 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 sub_select evaluate_join_record end_update | --2.09%--handler::ha_index_read_map heap_rkey hp_search | --1.20%--hp_key_cmp my_uca_strnncollsp_onelevel_utf8mb4 my_uca_scanner_next_utf8mb4.part.0 2.74% 2.74% one_connection mariadbd [.] my_charlen_utf8mb4 | ---clone3 start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command mysql_parse | --2.72%--mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner sub_select evaluate_join_record sub_select evaluate_join_record end_update | --2.02%--handler::ha_index_read_map heap_rkey hp_search | --1.67%--hp_key_cmp my_charpos_mb my_charlen_utf8mb4 2.67% 0.64% one_connection mariadbd [.] my_uca_strnncollsp_onelevel_utf8mb4 | --2.02%--my_uca_strnncollsp_onelevel_utf8mb4 | --1.28%--my_uca_scanner_next_utf8mb4.part.0 2.47% 1.10% one_connection mariadbd [.] cmp_data | |--1.37%--cmp_data | | | --1.28%--__memcmp_evex_movbe | --1.06%--clone3 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 sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 2.39% 2.35% one_connection mariadbd [.] row_sel_field_store_in_mysql_format_func | --2.35%--clone3 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 | --2.08%--rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec row_sel_store_mysql_field row_sel_field_store_in_mysql_format_func 2.20% 2.20% one_connection mariadbd [.] mtr_memo_slot_t::release | --2.14%--clone3 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 | --1.82%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc | --1.12%--btr_cur_t::search_leaf mtr_t::rollback_to_savepoint mtr_memo_slot_t::release 2.00% 2.00% one_connection libc.so.6 [.] __memcmp_evex_movbe | ---clone3 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 | --1.62%--sub_select evaluate_join_record sub_select join_read_key2 | --1.28%--handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 1.72% 0.12% one_connection mariadbd [.] Field::save_in_field_str | --1.60%--Field::save_in_field_str | --1.56%--Field_varstring::store 1.60% 0.06% one_connection mariadbd [.] sub_select_postjoin_aggr | --1.54%--sub_select_postjoin_aggr AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 1.60% 0.33% one_connection mariadbd [.] Field_varstring::store | --1.27%--Field_varstring::store 1.54% 0.00% one_connection mariadbd [.] AGGR_OP::end_send | ---AGGR_OP::end_send | --1.47%--join_init_read_record st_join_table::sort_table create_sort_index filesort 1.51% 0.33% one_connection mariadbd [.] mtr_t::rollback_to_savepoint | --1.18%--mtr_t::rollback_to_savepoint mtr_memo_slot_t::release 1.50% 1.50% one_connection mariadbd [.] buf_pool_t::page_guess | ---clone3 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 1.47% 0.02% one_connection mariadbd [.] filesort | --1.45%--filesort 1.47% 0.00% one_connection mariadbd [.] join_init_read_record | ---join_init_read_record st_join_table::sort_table create_sort_index filesort 1.47% 0.00% one_connection mariadbd [.] st_join_table::sort_table | ---st_join_table::sort_table create_sort_index filesort 1.47% 0.00% one_connection mariadbd [.] create_sort_index | ---create_sort_index filesort 1.33% 1.33% one_connection mariadbd [.] fts_get_doc_id_from_rec | ---clone3 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 rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec fts_get_doc_id_from_rec 1.20% 0.54% one_connection mariadbd [.] cmp_dtuple_rec_with_match_low 1.20% 0.72% one_connection mariadbd [.] cp_buffer_from_ref 1.20% 0.18% one_connection mariadbd [.] mtr_t::commit | --1.01%--mtr_t::commit mtr_memo_slot_t::release 1.19% 0.08% one_connection mariadbd [.] btr_pcur_t::restore_position | --1.10%--btr_pcur_t::restore_position 1.19% 0.00% one_connection mariadbd [.] sel_restore_position_for_mysql | ---sel_restore_position_for_mysql btr_pcur_t::restore_position 1.14% 0.35% one_connection mariadbd [.] btr_pcur_store_position # # (Cannot load tips.txt file, please install perf!) #