perf top --call-graph dwarf,callee --no-children -z -d 5 -F 10 Samples: 70K of event 'cycles', 10 Hz, Event count (approx.): 1990236001013 lost: 0/0 drop: 0/0 [z] Overhead Shared Object Symbol - 62.57% [kernel] [k] native_queued_spin_lock_slowpath ▒ native_queued_spin_lock_slowpath ▒ - queued_spin_lock_slowpath ▒ - 62.55% _raw_qspin_lock ◆ - 33.47% futex_wait_setup ▒ futex_wait ▒ do_futex ▒ sys_futex ▒ - system_call_fastpath ▒ - __lll_lock_wait ▒ - 22.05% 0x13675ad ▒ - log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 29.05% futex_wake ▒ do_futex ▒ sys_futex ▒ - system_call_fastpath ▒ __lll_unlock_wake ▒ - 12.67% libpthread-2.17.so [.] pthread_mutex_lock ▒ 12.44% __GI___pthread_mutex_lock (inlined) ▒ native_mutex_lock (inlined) ▒ my_mutex_lock (inlined) ▒ - inline_mysql_mutex_lock (inlined) ▒ - 12.28% Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ 0.45% mysqld [.] btr_search_guess_on_hash perf top --call-graph dwarf,callee --no-children -z -d 5 -F 10 -p 16635 Samples: 7K of event 'cycles', 10 Hz, Event count (approx.): 1846141662117 lost: 0/0 drop: 0/0 [z] Overhead Shared Object Symbol - 64.06% [kernel] [k] native_queued_spin_lock_slowpath ▒ native_queued_spin_lock_slowpath ▒ queued_spin_lock_slowpath ▒ - _raw_qspin_lock ▒ - 33.35% futex_wait_setup ▒ futex_wait ▒ do_futex ◆ sys_futex ▒ system_call_fastpath ▒ - __lll_lock_wait ▒ - 22.52% 0x13675ad ▒ - log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 0.61% _L_lock_1093 ▒ __GI___pthread_mutex_lock (inlined) ▒ native_mutex_lock (inlined) ▒ my_mutex_lock (inlined) ▒ inline_mysql_mutex_lock (inlined) ▒ Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 30.68% futex_wake ▒ do_futex ▒ sys_futex ▒ system_call_fastpath ▒ - __lll_unlock_wake ▒ - 0.51% _L_unlock_738 ▒ __GI___pthread_mutex_unlock (inlined) ▒ native_mutex_unlock (inlined) ▒ my_mutex_unlock (inlined) ▒ inline_mysql_mutex_unlock (inlined) ▒ Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 0.61% _L_lock_1093 ▒ __GI___pthread_mutex_lock (inlined) ◆ native_mutex_lock (inlined) ▒ my_mutex_lock (inlined) ▒ inline_mysql_mutex_lock (inlined) ▒ Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 30.40% futex_wake ▒ do_futex ▒ sys_futex ▒ system_call_fastpath ▒ - __lll_unlock_wake ▒ - 0.65% _L_unlock_738 ▒ __GI___pthread_mutex_unlock (inlined) ▒ native_mutex_unlock (inlined) ▒ my_mutex_unlock (inlined) ▒ inline_mysql_mutex_unlock (inlined) ▒ Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ - 12.76% libpthread-2.17.so [.] pthread_mutex_lock ▒ __GI___pthread_mutex_lock (inlined) ▒ native_mutex_lock (inlined) ▒ my_mutex_lock (inlined) ▒ - inline_mysql_mutex_lock (inlined) ▒ - 12.59% Slow_log_throttle::log ▒ log_slow_applicable ▒ log_slow_statement ▒ dispatch_command ▒ do_command ▒ threadpool_process_request ▒ handle_event (inlined) ▒ worker_main ▒ pfs_spawn_thread ▒ start_thread ▒ __clone ▒ 0.57% mysqld [.] btr_search_guess_on_hash