# To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 1M of event 'cpu/cycles/P' # Event count (approx.): 6317151676137 # # Children Self Command Shared Object Symbol # ........ ........ ............... ......................... .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................. # 99.93% 0.00% one_connection libc.so.6 [.] __clone3 (inlined) 99.93% 0.00% one_connection libc.so.6 [.] start_thread 99.93% 0.00% one_connection mariadbd [.] handle_one_connection 99.93% 0.00% one_connection mariadbd [.] pfs_spawn_thread 99.93% 0.00% one_connection mariadbd [.] do_handle_one_connection (inlined) 99.80% 0.00% one_connection mariadbd [.] do_command (inlined) 99.80% 0.00% one_connection mariadbd [.] dispatch_command (inlined) 99.80% 0.00% one_connection mariadbd [.] mysql_parse (inlined) 99.79% 0.00% one_connection mariadbd [.] mysql_execute_command (inlined) 99.75% 0.00% one_connection mariadbd [.] execute_sqlcom_select (inlined) 99.75% 0.00% one_connection mariadbd [.] handle_select (inlined) 99.75% 0.00% one_connection mariadbd [.] mysql_select (inlined) 99.74% 0.00% one_connection mariadbd [.] exec_inner (inlined) 99.74% 0.00% one_connection mariadbd [.] exec (inlined) 99.74% 0.00% one_connection mariadbd [.] do_select (inlined) 99.74% 0.00% one_connection mariadbd [.] sub_select (inlined) 99.12% 0.00% one_connection mariadbd [.] mysql_handle_single_derived (inlined) 99.12% 0.00% one_connection mariadbd [.] preread_init (inlined) 99.11% 0.00% one_connection mariadbd [.] mysql_derived_fill (inlined) 95.75% 0.00% one_connection mariadbd [.] evaluate_join_record (inlined) 95.73% 0.00% one_connection mariadbd [.] get_stmt_da (inlined) 95.60% 0.05% one_connection mariadbd [.] maria_write 94.88% 0.00% one_connection mariadbd [.] end_write (inlined) 70.23% 0.02% one_connection mariadbd [.] _ma_unique_hash 69.87% 43.45% one_connection mariadbd [.] my_uca_hash_sort_utf8mb4 43.57% 0.00% one_connection mariadbd [.] MY_HASH_ADD (inlined) 26.05% 26.05% one_connection mariadbd [.] my_uca_scanner_next_utf8mb4.part.0 22.98% 0.03% one_connection mariadbd [.] _ma_check_unique 22.83% 0.00% one_connection mariadbd [.] my_uca_scanner_next_utf8mb4 (inlined) 20.98% 0.02% one_connection mariadbd [.] _ma_cmp_dynamic_unique 19.13% 0.00% one_connection mariadbd [.] my_uca_scanner_next_utf8mb4 (inlined) 15.43% 0.02% one_connection mariadbd [.] _ma_unique_comp 15.42% 0.01% one_connection mariadbd [.] my_uca_strnncollsp_onelevel_utf8mb4 15.41% 0.00% one_connection mariadbd [.] my_uca_level_booster_simple_prefix_cmp (inlined) 15.25% 15.25% one_connection mariadbd [.] my_uca_level_booster_simple_prefix_cmp.constprop.0 7.06% 0.05% one_connection [kernel.kallsyms] [.] entry_SYSCALL_64_after_hwframe 7.04% 0.08% one_connection [kernel.kallsyms] [.] do_syscall_64 6.09% 0.02% one_connection libc.so.6 [.] __syscall_cancel 6.04% 0.00% one_connection mariadbd [.] compound2_make (inlined) 5.84% 0.00% one_connection libc.so.6 [.] __syscall_cancel_arch (inlined) 5.46% 0.05% one_connection mariadbd [.] _ma_read_dynamic_record 4.35% 0.09% one_connection [kernel.kallsyms] [.] vfs_read 4.26% 0.00% one_connection mariadbd [.] my_uca_level_booster_2bytes_item_addr_const (inlined) 4.17% 0.32% one_connection [kernel.kallsyms] [k] shmem_file_read_iter 3.74% 0.01% one_connection mariadbd [.] _ma_nommap_pread 3.73% 0.01% one_connection mariadbd [.] my_pread 3.70% 0.00% one_connection mariadbd [.] rr_sequential (inlined) 3.68% 0.00% one_connection libc.so.6 [.] __libc_pread64 (inlined) 3.68% 0.00% one_connection mariadbd [.] ha_rnd_next (inlined) 3.68% 0.00% one_connection mariadbd [.] pread (inlined) 3.48% 0.02% one_connection [kernel.kallsyms] [.] __x64_sys_pread64 3.28% 2.63% one_connection [kernel.kallsyms] [k] _copy_to_iter 3.13% 0.00% one_connection mariadbd [.] read_record (inlined) 3.10% 2.80% one_connection libc.so.6 [.] __memmove_avx512_unaligned_erms 2.67% 0.09% one_connection [kernel.kallsyms] [.] copy_page_to_iter 2.48% 0.00% one_connection mariadbd [.] general_fetch (inlined) 2.41% 0.00% one_connection mariadbd [.] row_search_mvcc (inlined) 2.13% 0.00% one_connection mariadbd [.] my_uca_scanner_next_expansion_weight (inlined) 2.05% 0.00% one_connection mariadbd [.] row_sel_store_mysql_rec (inlined) 1.80% 0.00% one_connection mariadbd [.] row_sel_store_mysql_field (inlined) 1.71% 0.04% one_connection mariadbd [.] _ma_get_block_info 1.70% 0.14% one_connection [kernel.kallsyms] [.] shmem_get_folio_gfp 1.69% 0.00% one_connection mariadbd [.] btr_copy_externally_stored_field (inlined) 1.57% 0.00% one_connection mariadbd [.] inline_mysql_file_read (inlined) 1.57% 0.00% one_connection mariadbd [.] my_uca_2bytes_item_is_applicable (inlined) 1.54% 0.01% one_connection mariadbd [.] _ma_search 1.53% 0.00% one_connection mariadbd [.] my_uca_scanner_set_weight (inlined) 1.44% 0.00% one_connection mariadbd [.] my_uca_level_booster_simple_weight2_addr_const (inlined) 1.41% 0.00% one_connection mariadbd [.] sub_select_postjoin_aggr (inlined) 1.41% 0.00% one_connection mariadbd [.] end_send (inlined) 1.40% 0.02% one_connection mariadbd [.] my_read 1.32% 0.00% one_connection libc.so.6 [.] __libc_read (inlined) 1.32% 0.00% one_connection mariadbd [.] read (inlined) 1.26% 0.12% one_connection mariadbd [.] pagecache_read 1.12% 0.04% one_connection mariadbd [.] _ma_search_no_save 1.08% 0.00% one_connection mariadbd [.] my_pwrite 1.08% 0.05% one_connection mariadbd [.] _ma_fetch_keypage 1.07% 0.00% one_connection libc.so.6 [.] __libc_pwrite64 (inlined) 1.06% 0.92% one_connection [kernel.kallsyms] [k] entry_SYSRETQ_unsafe_stack 1.05% 0.00% one_connection mariadbd [.] _ma_write_blob_record 1.04% 0.04% one_connection [kernel.kallsyms] [.] ksys_read 1.02% 0.01% one_connection [kernel.kallsyms] [.] __x64_sys_pwrite64 1.01% 0.01% one_connection [kernel.kallsyms] [.] vfs_write # # (Tip: To analyze particular parallelism levels, try: perf report --latency --parallelism=32-64) #