# To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 5K of event 'cycles:u' # Event count (approx.): 84559865815 # # Children Self Command Shared Object Symbol # ........ ........ ............... ................... .............................................................. # 99.21% 0.00% one_connection libc.so.6 [.] clone3 | ---clone3 start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.85%--do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 99.21% 0.00% one_connection libc.so.6 [.] start_thread | ---start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.85%--do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 99.21% 0.00% one_connection mariadbd [.] pfs_spawn_thread | ---pfs_spawn_thread handle_one_connection do_handle_one_connection | --98.85%--do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 99.21% 0.00% one_connection mariadbd [.] handle_one_connection | ---handle_one_connection do_handle_one_connection | --98.85%--do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 99.21% 0.00% one_connection mariadbd [.] do_handle_one_connection | ---do_handle_one_connection | --98.85%--do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 98.85% 0.00% one_connection mariadbd [.] do_command | ---do_command | --98.51%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 98.51% 0.02% one_connection mariadbd [.] dispatch_command | --98.49%--dispatch_command | --98.27%--mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 98.27% 0.00% one_connection mariadbd [.] mysql_parse | ---mysql_parse | --97.27%--mysql_execute_command | --97.22%--execute_sqlcom_select | --96.88%--handle_select | --96.84%--mysql_select | |--94.49%--JOIN::exec | JOIN::exec_inner | | | |--91.90%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.40%--rr_sequential | | | | | --27.22%--handler::ha_rnd_next | | | | | --25.61%--ha_innobase::general_fetch | | | | | --24.37%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | --4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 97.29% 0.02% one_connection mariadbd [.] mysql_execute_command | --97.27%--mysql_execute_command | --97.24%--execute_sqlcom_select | --96.90%--handle_select | --96.86%--mysql_select | |--94.51%--JOIN::exec | JOIN::exec_inner | | | |--91.92%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.42%--rr_sequential | | | | | --27.24%--handler::ha_rnd_next | | | | | --25.63%--ha_innobase::general_fetch | | | | | --24.39%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | |--4.54%--rec_get_offsets_func | | | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | | | --1.02%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 97.24% 0.00% one_connection mariadbd [.] execute_sqlcom_select | ---execute_sqlcom_select | --96.90%--handle_select | --96.86%--mysql_select | |--94.51%--JOIN::exec | JOIN::exec_inner | | | |--91.92%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.42%--rr_sequential | | | | | --27.24%--handler::ha_rnd_next | | | | | --25.63%--ha_innobase::general_fetch | | | | | --24.39%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | |--4.54%--rec_get_offsets_func | | | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | | | --1.02%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 96.90% 0.02% one_connection mariadbd [.] handle_select | --96.88%--handle_select | --96.86%--mysql_select | |--94.51%--JOIN::exec | JOIN::exec_inner | | | |--91.92%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.42%--rr_sequential | | | | | --27.24%--handler::ha_rnd_next | | | | | --25.63%--ha_innobase::general_fetch | | | | | --24.39%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | |--4.54%--rec_get_offsets_func | | | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | | | --1.02%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 96.86% 0.02% one_connection mariadbd [.] mysql_select | --96.84%--mysql_select | |--94.51%--JOIN::exec | JOIN::exec_inner | | | |--91.92%--sub_select | | | | | |--64.34%--evaluate_join_record | | | | | | | |--51.48%--sub_select | | | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | | | --20.25%--evaluate_join_record | | | | | | | | | --19.45%--end_update | | | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | | | --10.95%--hp_search | | | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | | | --4.48%--heap_write | | | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | | | --1.21%--Field::save_in_field_str | | | | | | | --10.60%--Item_cond_and::val_bool | | | | | | | --9.24%--Item_func_between::val_bool | | | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | | | --6.27%--Field::val_datetime_packed | | | | | | | --4.65%--Field_timestamp::get_date | | | | | | | --4.19%--THD::timestamp_to_TIME | | | | | | | --3.68%--sec_to_TIME | | | | | --27.42%--rr_sequential | | | | | --27.24%--handler::ha_rnd_next | | | | | --25.63%--ha_innobase::general_fetch | | | | | --24.39%--row_search_mvcc | | | | | |--8.41%--row_sel_store_mysql_rec | | | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.46%--fts_get_doc_id_from_rec | | | | | |--4.54%--rec_get_offsets_func | | | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | | | --1.02%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | --2.25%--sub_select_postjoin_aggr | AGGR_OP::end_send | | | --2.19%--join_init_read_record | | | --2.17%--st_join_table::sort_table | create_sort_index | filesort | --1.75%--JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 94.51% 0.00% one_connection mariadbd [.] JOIN::exec | ---JOIN::exec JOIN::exec_inner | |--91.92%--sub_select | | | |--64.34%--evaluate_join_record | | | | | |--51.48%--sub_select | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | --20.25%--evaluate_join_record | | | | | | | --19.45%--end_update | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | --10.95%--hp_search | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | --4.48%--heap_write | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.21%--Field::save_in_field_str | | | | | --10.60%--Item_cond_and::val_bool | | | | | --9.24%--Item_func_between::val_bool | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | --6.27%--Field::val_datetime_packed | | | | | --4.65%--Field_timestamp::get_date | | | | | --4.19%--THD::timestamp_to_TIME | | | | | --3.68%--sec_to_TIME | | | --27.42%--rr_sequential | | | --27.24%--handler::ha_rnd_next | | | --25.63%--ha_innobase::general_fetch | | | --24.39%--row_search_mvcc | | | |--8.41%--row_sel_store_mysql_rec | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | --1.46%--fts_get_doc_id_from_rec | | | |--4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --1.02%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --2.25%--sub_select_postjoin_aggr AGGR_OP::end_send | --2.19%--join_init_read_record | --2.17%--st_join_table::sort_table create_sort_index filesort 94.51% 0.00% one_connection mariadbd [.] JOIN::exec_inner | ---JOIN::exec_inner | |--91.92%--sub_select | | | |--64.34%--evaluate_join_record | | | | | |--51.48%--sub_select | | | | | | | |--30.57%--join_read_key2 | | | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | | | --27.88%--row_search_mvcc | | | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | | | --1.03%--btr_pcur_store_position | | | | | | | --20.25%--evaluate_join_record | | | | | | | --19.45%--end_update | | | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | | | --11.23%--heap_rkey | | | | | | | | | --10.95%--hp_search | | | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | | | --4.56%--ha_heap::write_row | | | | | | | | | --4.48%--heap_write | | | | | | | | | --3.98%--hp_write_key | | | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | | | --1.21%--Field::save_in_field_str | | | | | --10.60%--Item_cond_and::val_bool | | | | | --9.24%--Item_func_between::val_bool | | | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | | | --6.27%--Field::val_datetime_packed | | | | | --4.65%--Field_timestamp::get_date | | | | | --4.19%--THD::timestamp_to_TIME | | | | | --3.68%--sec_to_TIME | | | --27.42%--rr_sequential | | | --27.24%--handler::ha_rnd_next | | | --25.63%--ha_innobase::general_fetch | | | --24.39%--row_search_mvcc | | | |--8.41%--row_sel_store_mysql_rec | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | --1.46%--fts_get_doc_id_from_rec | | | |--4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --1.02%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --2.25%--sub_select_postjoin_aggr AGGR_OP::end_send | --2.19%--join_init_read_record | --2.17%--st_join_table::sort_table create_sort_index filesort 91.96% 0.60% one_connection mariadbd [.] sub_select | --91.36%--sub_select | |--63.82%--evaluate_join_record | | | |--50.96%--sub_select | | | | | |--30.57%--join_read_key2 | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | --27.88%--row_search_mvcc | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | --1.03%--btr_pcur_store_position | | | | | --20.25%--evaluate_join_record | | | | | --19.45%--end_update | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | --11.23%--heap_rkey | | | | | | | --10.95%--hp_search | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | --4.56%--ha_heap::write_row | | | | | | | --4.48%--heap_write | | | | | | | --3.98%--hp_write_key | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | --1.21%--Field::save_in_field_str | | | --10.60%--Item_cond_and::val_bool | | | --9.24%--Item_func_between::val_bool | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | --6.27%--Field::val_datetime_packed | | | --4.65%--Field_timestamp::get_date | | | --4.19%--THD::timestamp_to_TIME | | | --3.68%--sec_to_TIME | --27.46%--rr_sequential | --27.24%--handler::ha_rnd_next | --25.63%--ha_innobase::general_fetch | --24.39%--row_search_mvcc | |--8.41%--row_sel_store_mysql_rec | | | |--5.41%--row_sel_store_mysql_field | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | --1.46%--fts_get_doc_id_from_rec | |--4.54%--rec_get_offsets_func | | | --4.24%--rec_init_offsets_comp_ordinary | --1.02%--sel_restore_position_for_mysql btr_pcur_t::restore_position 64.36% 2.62% one_connection mariadbd [.] evaluate_join_record | |--61.74%--evaluate_join_record | | | |--51.04%--sub_select | | | | | |--30.57%--join_read_key2 | | | | | | | --29.17%--handler::ha_index_read_map | | | | | | | --28.83%--ha_innobase::index_read | | | | | | | --27.88%--row_search_mvcc | | | | | | | |--19.58%--btr_cur_t::search_leaf | | | | | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | | | | | |--4.44%--page_cur_search_with_match | | | | | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | | | | | --2.31%--cmp_data | | | | | | | | | |--4.33%--buf_page_get_gen | | | | | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | | | | | |--1.49%--rec_get_offsets_func | | | | | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | | | | | |--1.41%--row_sel_store_mysql_rec | | | | | | | --1.03%--btr_pcur_store_position | | | | | --19.81%--evaluate_join_record | | | | | --19.45%--end_update | | | | | |--11.55%--handler::ha_index_read_map | | | | | | | --11.23%--heap_rkey | | | | | | | --10.95%--hp_search | | | | | | | |--6.78%--hp_key_cmp | | | | | | | | | |--3.09%--my_charpos_mb | | | | | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | | | | | --1.93%--my_uca_hash_sort_utf8mb4 | | | | | |--4.62%--handler::ha_write_tmp_row | | | | | | | --4.56%--ha_heap::write_row | | | | | | | --4.48%--heap_write | | | | | | | --3.98%--hp_write_key | | | | | | | --2.77%--hp_rec_hashnr | | | | | | | --1.87%--my_uca_hash_sort_utf8mb4 | | | | | --1.21%--Field::save_in_field_str | | | --10.60%--Item_cond_and::val_bool | | | --9.24%--Item_func_between::val_bool | | | --8.42%--Item_func_between::val_int_cmp_datetime | | | --6.27%--Field::val_datetime_packed | | | --4.65%--Field_timestamp::get_date | | | --4.19%--THD::timestamp_to_TIME | | | --3.68%--sec_to_TIME | --2.62%--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.47% 8.39% one_connection mariadbd [.] row_search_mvcc | |--44.09%--row_search_mvcc | | | |--19.58%--btr_cur_t::search_leaf | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | |--4.44%--page_cur_search_with_match | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | --2.31%--cmp_data | | | | | |--4.33%--buf_page_get_gen | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | |--9.91%--row_sel_store_mysql_rec | | | | | |--6.37%--row_sel_store_mysql_field | | | | | | | |--2.36%--row_sel_field_store_in_mysql_format_func | | | | | | | --1.15%--__memmove_avx512_unaligned_erms | | | | | --1.46%--fts_get_doc_id_from_rec | | | |--6.07%--rec_get_offsets_func | | | | | --5.61%--rec_init_offsets_comp_ordinary | | | |--1.47%--btr_pcur_store_position | | | |--1.02%--sel_restore_position_for_mysql | | btr_pcur_t::restore_position | | | --1.01%--mtr_t::commit | --8.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 | |--6.17%--rr_sequential | handler::ha_rnd_next | ha_innobase::general_fetch | row_search_mvcc | --2.21%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 40.74% 0.48% one_connection mariadbd [.] handler::ha_index_read_map | --40.26%--handler::ha_index_read_map | |--28.83%--ha_innobase::index_read | | | --27.88%--row_search_mvcc | | | |--19.58%--btr_cur_t::search_leaf | | | | | |--6.93%--page_cur_search_with_match_bytes | | | | | | | --4.48%--cmp_dtuple_rec_bytes | | | | | |--4.44%--page_cur_search_with_match | | | | | | | --3.39%--page_cur_dtuple_cmp | | | | | | | --2.31%--cmp_data | | | | | |--4.33%--buf_page_get_gen | | | | | --1.28%--mtr_t::rollback_to_savepoint | | | |--1.49%--rec_get_offsets_func | | | | | --1.37%--rec_init_offsets_comp_ordinary | | | |--1.41%--row_sel_store_mysql_rec | | | --1.03%--btr_pcur_store_position | --11.25%--heap_rkey | --10.95%--hp_search | |--6.78%--hp_key_cmp | | | |--3.09%--my_charpos_mb | | | | | --1.37%--my_charlen_utf8mb4 | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | --1.93%--my_uca_hash_sort_utf8mb4 30.57% 0.18% one_connection mariadbd [.] join_read_key2 | --30.39%--join_read_key2 | --29.17%--handler::ha_index_read_map | --28.83%--ha_innobase::index_read | --27.88%--row_search_mvcc | |--19.58%--btr_cur_t::search_leaf | | | |--6.93%--page_cur_search_with_match_bytes | | | | | --4.48%--cmp_dtuple_rec_bytes | | | |--4.44%--page_cur_search_with_match | | | | | --3.39%--page_cur_dtuple_cmp | | | | | --2.31%--cmp_data | | | |--4.33%--buf_page_get_gen | | | --1.28%--mtr_t::rollback_to_savepoint | |--1.49%--rec_get_offsets_func | | | --1.37%--rec_init_offsets_comp_ordinary | |--1.41%--row_sel_store_mysql_rec | --1.03%--btr_pcur_store_position 28.87% 0.56% one_connection mariadbd [.] ha_innobase::index_read | --28.32%--ha_innobase::index_read | --27.92%--row_search_mvcc | |--19.58%--btr_cur_t::search_leaf | | | |--6.93%--page_cur_search_with_match_bytes | | | | | --4.48%--cmp_dtuple_rec_bytes | | | |--4.44%--page_cur_search_with_match | | | | | --3.39%--page_cur_dtuple_cmp | | | | | --2.31%--cmp_data | | | |--4.33%--buf_page_get_gen | | | --1.28%--mtr_t::rollback_to_savepoint | |--1.49%--rec_get_offsets_func | | | --1.37%--rec_init_offsets_comp_ordinary | |--1.45%--row_sel_store_mysql_rec | --1.03%--btr_pcur_store_position 27.48% 1.48% one_connection mariadbd [.] handler::ha_rnd_next | |--26.01%--handler::ha_rnd_next | | | --25.65%--ha_innobase::general_fetch | | | --24.39%--row_search_mvcc | | | |--8.41%--row_sel_store_mysql_rec | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | --1.46%--fts_get_doc_id_from_rec | | | |--4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --1.02%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.48%--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.42%--sub_select rr_sequential handler::ha_rnd_next 27.46% 0.22% one_connection mariadbd [.] rr_sequential | --27.24%--rr_sequential handler::ha_rnd_next | --25.63%--ha_innobase::general_fetch | --24.39%--row_search_mvcc | |--8.41%--row_sel_store_mysql_rec | | | |--5.41%--row_sel_store_mysql_field | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | --1.46%--fts_get_doc_id_from_rec | |--4.54%--rec_get_offsets_func | | | --4.24%--rec_init_offsets_comp_ordinary | --1.02%--sel_restore_position_for_mysql btr_pcur_t::restore_position 25.65% 1.25% one_connection mariadbd [.] ha_innobase::general_fetch | |--24.39%--ha_innobase::general_fetch | row_search_mvcc | | | |--8.41%--row_sel_store_mysql_rec | | | | | |--5.41%--row_sel_store_mysql_field | | | | | | | --2.10%--row_sel_field_store_in_mysql_format_func | | | | | --1.46%--fts_get_doc_id_from_rec | | | |--4.54%--rec_get_offsets_func | | | | | --4.24%--rec_init_offsets_comp_ordinary | | | --1.02%--sel_restore_position_for_mysql | btr_pcur_t::restore_position | --1.23%--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 19.60% 1.47% one_connection mariadbd [.] btr_cur_t::search_leaf | |--18.12%--btr_cur_t::search_leaf | | | |--6.93%--page_cur_search_with_match_bytes | | | | | --4.48%--cmp_dtuple_rec_bytes | | | |--4.44%--page_cur_search_with_match | | | | | --3.39%--page_cur_dtuple_cmp | | | | | --2.31%--cmp_data | | | |--4.33%--buf_page_get_gen | | | --1.28%--mtr_t::rollback_to_savepoint | --1.47%--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 19.47% 0.38% one_connection mariadbd [.] end_update | --19.09%--end_update | |--11.55%--handler::ha_index_read_map | | | --11.23%--heap_rkey | | | --10.95%--hp_search | | | |--6.78%--hp_key_cmp | | | | | |--3.09%--my_charpos_mb | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | --1.93%--my_uca_hash_sort_utf8mb4 | |--4.62%--handler::ha_write_tmp_row | | | --4.56%--ha_heap::write_row | | | --4.48%--heap_write | | | --3.98%--hp_write_key | | | --2.77%--hp_rec_hashnr | | | --1.87%--my_uca_hash_sort_utf8mb4 | --1.23%--Field::save_in_field_str 11.25% 0.26% one_connection mariadbd [.] heap_rkey | --10.99%--heap_rkey | --10.95%--hp_search | |--6.78%--hp_key_cmp | | | |--3.09%--my_charpos_mb | | | | | --1.37%--my_charlen_utf8mb4 | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | --1.93%--my_uca_hash_sort_utf8mb4 10.97% 1.37% one_connection mariadbd [.] hp_search | |--9.60%--hp_search | | | |--6.78%--hp_key_cmp | | | | | |--3.09%--my_charpos_mb | | | | | | | --1.37%--my_charlen_utf8mb4 | | | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | | | --1.93%--my_uca_hash_sort_utf8mb4 | --1.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 sub_select evaluate_join_record end_update handler::ha_index_read_map heap_rkey hp_search 10.66% 0.98% one_connection mariadbd [.] Item_cond_and::val_bool | --9.68%--Item_cond_and::val_bool | --9.28%--Item_func_between::val_bool | --8.42%--Item_func_between::val_int_cmp_datetime | --6.27%--Field::val_datetime_packed | --4.65%--Field_timestamp::get_date | --4.19%--THD::timestamp_to_TIME | --3.68%--sec_to_TIME 9.97% 2.08% one_connection mariadbd [.] row_sel_store_mysql_rec | |--7.88%--row_sel_store_mysql_rec | | | |--6.43%--row_sel_store_mysql_field | | | | | |--2.36%--row_sel_field_store_in_mysql_format_func | | | | | --1.15%--__memmove_avx512_unaligned_erms | | | --1.46%--fts_get_doc_id_from_rec | --2.04%--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.55%--rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec 9.28% 0.48% one_connection mariadbd [.] Item_func_between::val_bool | --8.80%--Item_func_between::val_bool | --8.42%--Item_func_between::val_int_cmp_datetime | --6.27%--Field::val_datetime_packed | --4.65%--Field_timestamp::get_date | --4.19%--THD::timestamp_to_TIME | --3.68%--sec_to_TIME 8.46% 0.42% one_connection mariadbd [.] Item_func_between::val_int_cmp_datetime | --8.04%--Item_func_between::val_int_cmp_datetime | --6.27%--Field::val_datetime_packed | --4.65%--Field_timestamp::get_date | --4.19%--THD::timestamp_to_TIME | --3.68%--sec_to_TIME 6.93% 2.45% one_connection mariadbd [.] page_cur_search_with_match_bytes | |--4.48%--page_cur_search_with_match_bytes | cmp_dtuple_rec_bytes | --2.45%--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.87% 1.26% one_connection mariadbd [.] rec_get_offsets_func | |--5.61%--rec_get_offsets_func | rec_init_offsets_comp_ordinary | --1.20%--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.78% 1.01% one_connection mariadbd [.] hp_key_cmp | |--5.77%--hp_key_cmp | | | |--3.09%--my_charpos_mb | | | | | --1.37%--my_charlen_utf8mb4 | | | --2.53%--my_uca_strnncollsp_onelevel_utf8mb4 | | | --1.35%--my_uca_scanner_next_utf8mb4.part.0 | --1.01%--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.43% 2.91% one_connection mariadbd [.] row_sel_store_mysql_field | |--3.51%--row_sel_store_mysql_field | | | |--2.36%--row_sel_field_store_in_mysql_format_func | | | --1.15%--__memmove_avx512_unaligned_erms | --2.85%--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.38%--rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc row_sel_store_mysql_rec row_sel_store_mysql_field 6.27% 0.73% one_connection mariadbd [.] Field::val_datetime_packed | --5.53%--Field::val_datetime_packed | --4.65%--Field_timestamp::get_date | --4.19%--THD::timestamp_to_TIME | --3.68%--sec_to_TIME 5.61% 5.61% 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.24%--rr_sequential | handler::ha_rnd_next | ha_innobase::general_fetch | row_search_mvcc | rec_get_offsets_func | rec_init_offsets_comp_ordinary | --1.37%--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 4.68% 2.49% one_connection mariadbd [.] my_charpos_mb | |--2.49%--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.05%--handler::ha_index_read_map | heap_rkey | hp_search | | | --1.71%--hp_key_cmp | my_charpos_mb | --2.19%--my_charpos_mb my_charlen_utf8mb4 4.65% 0.22% one_connection mariadbd [.] Field_timestamp::get_date | --4.43%--Field_timestamp::get_date | --4.19%--THD::timestamp_to_TIME | --3.68%--sec_to_TIME 4.62% 0.06% one_connection mariadbd [.] handler::ha_write_tmp_row | --4.56%--handler::ha_write_tmp_row ha_heap::write_row | --4.48%--heap_write | --3.98%--hp_write_key | --2.77%--hp_rec_hashnr | --1.87%--my_uca_hash_sort_utf8mb4 4.56% 0.08% one_connection mariadbd [.] ha_heap::write_row | --4.48%--ha_heap::write_row heap_write | --3.98%--hp_write_key | --2.77%--hp_rec_hashnr | --1.87%--my_uca_hash_sort_utf8mb4 4.49% 3.53% one_connection mariadbd [.] buf_page_get_gen | --3.53%--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.41%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc | --3.37%--btr_cur_t::search_leaf buf_page_get_gen 4.48% 0.22% one_connection mariadbd [.] heap_write | --4.26%--heap_write | --3.98%--hp_write_key | --2.77%--hp_rec_hashnr | --1.87%--my_uca_hash_sort_utf8mb4 4.48% 4.24% one_connection mariadbd [.] cmp_dtuple_rec_bytes | --4.24%--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.44% 1.05% one_connection mariadbd [.] page_cur_search_with_match | |--3.39%--page_cur_search_with_match | page_cur_dtuple_cmp | | | --2.31%--cmp_data | --1.05%--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 4.23% 0.26% one_connection mariadbd [.] THD::timestamp_to_TIME | --3.98%--THD::timestamp_to_TIME | --3.72%--sec_to_TIME 3.98% 1.09% one_connection mariadbd [.] hp_write_key | |--2.89%--hp_write_key | | | --2.77%--hp_rec_hashnr | | | --1.87%--my_uca_hash_sort_utf8mb4 | --1.09%--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 3.80% 2.47% one_connection mariadbd [.] my_uca_hash_sort_utf8mb4 | |--2.47%--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.39%--handler::ha_index_read_map | | heap_rkey | | hp_search | | my_uca_hash_sort_utf8mb4 | | | --1.07%--handler::ha_write_tmp_row | ha_heap::write_row | heap_write | hp_write_key | hp_rec_hashnr | my_uca_hash_sort_utf8mb4 | --1.34%--my_uca_hash_sort_utf8mb4 my_uca_scanner_next_utf8mb4.part.0 3.72% 3.72% one_connection mariadbd [.] sec_to_TIME | --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 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.39% 1.07% one_connection mariadbd [.] page_cur_dtuple_cmp | |--2.31%--page_cur_dtuple_cmp | cmp_data | --1.07%--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.98% 2.96% one_connection libc.so.6 [.] __memmove_avx512_unaligned_erms | --2.96%--clone3 start_thread pfs_spawn_thread handle_one_connection do_handle_one_connection do_command dispatch_command | --2.94%--mysql_parse | --2.92%--mysql_execute_command execute_sqlcom_select handle_select mysql_select JOIN::exec JOIN::exec_inner | --2.76%--sub_select | --1.89%--rr_sequential handler::ha_rnd_next ha_innobase::general_fetch row_search_mvcc 2.93% 1.44% one_connection mariadbd [.] cmp_data | |--1.49%--cmp_data | | | --1.30%--__memcmp_evex_movbe | --1.38%--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 | --1.18%--btr_cur_t::search_leaf page_cur_search_with_match page_cur_dtuple_cmp cmp_data 2.77% 0.28% one_connection mariadbd [.] hp_rec_hashnr | --2.49%--hp_rec_hashnr | --1.87%--my_uca_hash_sort_utf8mb4 2.75% 2.59% one_connection mariadbd [.] my_uca_scanner_next_utf8mb4.part.0 | --2.59%--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.79%--handler::ha_index_read_map heap_rkey hp_search | --1.29%--hp_key_cmp my_uca_strnncollsp_onelevel_utf8mb4 my_uca_scanner_next_utf8mb4.part.0 2.75% 0.44% one_connection mariadbd [.] my_uca_strnncollsp_onelevel_utf8mb4 | --2.31%--my_uca_strnncollsp_onelevel_utf8mb4 | --1.41%--my_uca_scanner_next_utf8mb4.part.0 2.36% 2.32% one_connection mariadbd [.] row_sel_field_store_in_mysql_format_func | --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 | --2.14%--rr_sequential handler::ha_rnd_next | --2.10%--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.27% 0.00% one_connection mariadbd [.] join_init_read_record | ---join_init_read_record | --2.17%--st_join_table::sort_table create_sort_index filesort 2.25% 0.00% one_connection mariadbd [.] sub_select_postjoin_aggr | ---sub_select_postjoin_aggr AGGR_OP::end_send | --2.19%--join_init_read_record | --2.17%--st_join_table::sort_table create_sort_index filesort 2.25% 0.00% one_connection mariadbd [.] AGGR_OP::end_send | ---AGGR_OP::end_send | --2.19%--join_init_read_record | --2.17%--st_join_table::sort_table create_sort_index filesort 2.19% 2.19% 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 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.79%--handler::ha_index_read_map heap_rkey hp_search | --1.37%--hp_key_cmp my_charpos_mb my_charlen_utf8mb4 2.17% 0.02% one_connection mariadbd [.] filesort | --2.15%--filesort 2.17% 0.00% one_connection mariadbd [.] st_join_table::sort_table | ---st_join_table::sort_table create_sort_index filesort 2.17% 0.00% one_connection mariadbd [.] create_sort_index | ---create_sort_index filesort 2.07% 2.07% 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.57%--sub_select evaluate_join_record sub_select join_read_key2 | --1.30%--handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 1.75% 1.75% one_connection mariadbd [.] mtr_memo_slot_t::release | --1.73%--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%--evaluate_join_record sub_select join_read_key2 handler::ha_index_read_map ha_innobase::index_read row_search_mvcc 1.75% 0.00% one_connection mariadbd [.] JOIN::optimize | ---JOIN::optimize | --1.63%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 1.63% 0.08% one_connection mariadbd [.] JOIN::optimize_inner | --1.55%--JOIN::optimize_inner | --1.03%--JOIN::optimize_stage2 1.47% 1.47% one_connection mariadbd [.] buf_pool_t::page_guess | --1.45%--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.28% one_connection mariadbd [.] btr_pcur_store_position | --1.19%--btr_pcur_store_position 1.46% 1.46% 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.30% 0.36% one_connection mariadbd [.] mtr_t::rollback_to_savepoint 1.23% 0.16% one_connection mariadbd [.] Field::save_in_field_str | --1.07%--Field::save_in_field_str 1.03% 0.06% one_connection mariadbd [.] JOIN::optimize_stage2 1.02% 0.04% one_connection mariadbd [.] btr_pcur_t::restore_position 1.02% 0.00% one_connection mariadbd [.] sel_restore_position_for_mysql | ---sel_restore_position_for_mysql btr_pcur_t::restore_position 1.01% 0.16% one_connection mariadbd [.] mtr_t::commit # # (Cannot load tips.txt file, please install perf!) #