Flame Graph
Reset Zoom
Search
create_ref_for_key (664 samples, 0.02%)
row_sel_field_store_in_mysql_format_func (491 samples, 0.02%)
[unknown] (3,125 samples, 0.10%)
__kfree_skb (261 samples, 0.01%)
open_tables_for_query (4,635 samples, 0.15%)
PTI_simple_ident_ident::itemize (315 samples, 0.01%)
sYSMALLOc (599 samples, 0.02%)
Query_result_send::send_data (629 samples, 0.02%)
PT_select_part2::contextualize (3,128 samples, 0.10%)
ip_output (1,503 samples, 0.05%)
net_rx_action (754 samples, 0.02%)
THD::decide_logging_format (367 samples, 0.01%)
row_search_mvcc (3,303 samples, 0.11%)
handler::ha_write_row (44,722 samples, 1.47%)
ipt_local_hook (261 samples, 0.01%)
end_send (3,018 samples, 0.10%)
ip_local_out (2,357 samples, 0.08%)
ip_rcv_finish (2,350 samples, 0.08%)
Protocol_classic::end_row (353 samples, 0.01%)
my_strnncollsp_utf8 (386 samples, 0.01%)
bond_dev_queue_xmit (1,069 samples, 0.04%)
call_softirq (3,548 samples, 0.12%)
THD::enter_stage (289 samples, 0.01%)
[[vsyscall]] (444 samples, 0.01%)
ipt_local_hook (793 samples, 0.03%)
Lex_hash::get_hash_symbol (651 samples, 0.02%)
ip_local_deliver (499 samples, 0.02%)
ixgbe_poll (3,567 samples, 0.12%)
sys_sendto (1,103 samples, 0.04%)
tcp_rcv_established (398 samples, 0.01%)
_int_free (572 samples, 0.02%)
flush_tlb_others_ipi (519 samples, 0.02%)
handler::compare_key (441 samples, 0.01%)
sys_sendto (9,568 samples, 0.31%)
schedule_hrtimeout_range (3,359 samples, 0.11%)
end_send_group (916 samples, 0.03%)
__alloc_skb (890 samples, 0.03%)
handler::ha_index_next (11,935 samples, 0.39%)
handler::ha_rnd_next (587 samples, 0.02%)
page_fault (564 samples, 0.02%)
Item_func::fix_func_arg (401 samples, 0.01%)
my_convert (2,581 samples, 0.08%)
Field_string::val_str (390 samples, 0.01%)
lock_table_names (344 samples, 0.01%)
handler::ha_external_lock (1,097 samples, 0.04%)
try_to_wake_up (663 samples, 0.02%)
end_send (853 samples, 0.03%)
pfs_end_idle_wait_v1 (469 samples, 0.02%)
my_net_read (23,165 samples, 0.76%)
THD::send_statement_status (11,651 samples, 0.38%)
ip_finish_output (742 samples, 0.02%)
ha_innobase::external_lock (650 samples, 0.02%)
std::__introsort_loop<unsigned char**, long, (anonymous namespace)::Mem_compare_longkey> (414 samples, 0.01%)
copy_fields (465 samples, 0.02%)
start_secondary (6,104 samples, 0.20%)
get_mm_tree (1,001 samples, 0.03%)
Query_result_send::send_data (5,269 samples, 0.17%)
tcp_cleanup_rbuf (2,439 samples, 0.08%)
MDL_context::acquire_lock (407 samples, 0.01%)
native_flush_tlb_others (277 samples, 0.01%)
handler::ha_external_lock (280 samples, 0.01%)
__kmalloc_node (325 samples, 0.01%)
flush_tlb_mm (290 samples, 0.01%)
ha_heap::rnd_pos (423 samples, 0.01%)
__wake_up_sync_key (751 samples, 0.02%)
local_bh_enable (741 samples, 0.02%)
make_join_select (531 samples, 0.02%)
end_send (6,469 samples, 0.21%)
napi_gro_receive (582 samples, 0.02%)
std::__introsort_loop<unsigned char**, long, (anonymous namespace)::Mem_compare_longkey> (436 samples, 0.01%)
vio_socket_io_wait (6,267 samples, 0.21%)
nf_hook_slow (761 samples, 0.02%)
ha_innobase::index_read (1,223 samples, 0.04%)
Protocol_classic::get_command (23,349 samples, 0.77%)
ip_local_deliver_finish (2,166 samples, 0.07%)
JOIN::create_intermediate_table (798 samples, 0.03%)
ixgbe_poll (727 samples, 0.02%)
row_sel_store_mysql_rec (1,085 samples, 0.04%)
my_charpos_mb (17,144 samples, 0.56%)
physflat_send_IPI_mask (393 samples, 0.01%)
PT_table_reference_list::contextualize (1,228 samples, 0.04%)
Unrecognized line: 8e536d JOIN::estimate_rowcount (/Failed to open [vsyscall], continuing without symbols at ./stackcollapse-perf.pl line 339, <> line (11,463 samples, 0.38%)
memcpy (973 samples, 0.03%)
build_equal_items_for_cond (1,300 samples, 0.04%)
_int_malloc (491 samples, 0.02%)
page_rec_get_n_recs_before (569 samples, 0.02%)
row_sel_store_mysql_field_func (1,585 samples, 0.05%)
net_rx_action (734 samples, 0.02%)
ha_innobase::store_lock (503 samples, 0.02%)
sock_sendmsg (474 samples, 0.02%)
init (6,395 samples, 0.21%)
handler::multi_range_read_next (14,294 samples, 0.47%)
THD::send_result_set_row (430 samples, 0.01%)
cpu_idle (6,031 samples, 0.20%)
check_table_access (867 samples, 0.03%)
Arg_comparator::set_cmp_func (338 samples, 0.01%)
get_mm_leaf (343 samples, 0.01%)
net_rx_action (784 samples, 0.03%)
local_bh_enable (793 samples, 0.03%)
net_read_packet (23,044 samples, 0.76%)
bond_dev_queue_xmit (777 samples, 0.03%)
Item_func::fix_fields (431 samples, 0.01%)
Unrecognized line: 453d65 Item_func::fix_fields (/data/mysql-5.7.18-linux-glibFailed to open /tmp/perf-74658.map, continuing without symbols at ./stackcollapse-perf.pl line 339, <> line (3,001 samples, 0.10%)
ip_local_deliver (498 samples, 0.02%)
dev_hard_start_xmit (455 samples, 0.01%)
my_utf8_uni (1,217 samples, 0.04%)
nf_hook_slow (793 samples, 0.03%)
my_ismbchar_utf8 (5,709 samples, 0.19%)
dev_queue_xmit (274 samples, 0.01%)
Unrecognized line: 8ca19a JOIN::exec (/data/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqldFailed to open /tmp/perf-74660.map, continuing without symbols at ./stackcollapse-perf.pl line 339, <> line (1,384,191 samples, 45.38%)
Unrecognized line: 8ca19a JOIN::exec (/data/mysql-5.7.18-linux..
ha_innobase::change_active_index (653 samples, 0.02%)
memcpy (618 samples, 0.02%)
ha_heap::write_row (44,429 samples, 1.46%)
consume_skb (296 samples, 0.01%)
__libc_send (1,184 samples, 0.04%)
sch_direct_xmit (844 samples, 0.03%)
Query_arena::free_items (530 samples, 0.02%)
ip_rcv (549 samples, 0.02%)
netif_receive_skb (2,624 samples, 0.09%)
PTI_expr_with_alias::itemize (538 samples, 0.02%)
ip_rcv_finish (514 samples, 0.02%)
memcpy (326 samples, 0.01%)
netif_receive_skb (570 samples, 0.02%)
handle_mm_fault (444 samples, 0.01%)
tcp_v4_do_rcv (416 samples, 0.01%)
handler::read_range_next (12,635 samples, 0.41%)
my_ismbchar_utf8 (11,563 samples, 0.38%)
handler::index_read_idx_map (4,603 samples, 0.15%)
_spin_lock (265 samples, 0.01%)
default_wake_function (629 samples, 0.02%)
skb_release_data (320 samples, 0.01%)
my_hash_sort_bin (745 samples, 0.02%)
dev_queue_xmit (1,574 samples, 0.05%)
rec_get_offsets_func (332 samples, 0.01%)
join_read_const_table (6,207 samples, 0.20%)
[[vdso]] (620 samples, 0.02%)
THD::cleanup_after_query (1,256 samples, 0.04%)
MYSQL_BIN_LOG::commit (618 samples, 0.02%)
QEP_tmp_table::end_send (16,043 samples, 0.53%)
tcp_transmit_skb (279 samples, 0.01%)
tcp_sendmsg (8,686 samples, 0.28%)
filesort (11,831 samples, 0.39%)
tcp_transmit_skb (492 samples, 0.02%)
ip_output (319 samples, 0.01%)
napi_skb_finish (570 samples, 0.02%)
hrtimer_start_range_ns (479 samples, 0.02%)
net_flush (10,646 samples, 0.35%)
tcp_write_xmit (586 samples, 0.02%)
ip_local_out (2,000 samples, 0.07%)
tcp_v4_rcv (463 samples, 0.02%)
btr_cur_search_to_nth_level (1,421 samples, 0.05%)
_spin_unlock_bh (3,595 samples, 0.12%)
test_quick_select (8,569 samples, 0.28%)
LEX::new_top_level_query (838 samples, 0.03%)
ipt_do_table (793 samples, 0.03%)
st_select_lex::cleanup (919 samples, 0.03%)
PT_select_options_and_item_list::contextualize (830 samples, 0.03%)
JOIN::init_planner_arrays (645 samples, 0.02%)
lock_clust_rec_cons_read_sees (353 samples, 0.01%)
my_hash_search_using_hash_value (374 samples, 0.01%)
lf_hash_search (1,954 samples, 0.06%)
ha_innobase::records_in_range (5,709 samples, 0.19%)
unmap_vmas (536 samples, 0.02%)
ip_queue_xmit (429 samples, 0.01%)
ip_rcv_finish (516 samples, 0.02%)
handle_mm_fault (381 samples, 0.01%)
ixgbe_xmit_frame_ring (295 samples, 0.01%)
netif_receive_skb (561 samples, 0.02%)
heap_write (43,913 samples, 1.44%)
cset_hash_sort_adapter (793 samples, 0.03%)
pfs_start_stage_v1 (374 samples, 0.01%)
boost::geometry::detail::get_turns::get_turns_in_sections<Gis_line_string, Gis_line_string, false, false, boost::geometry::section<boost::geometry::model::box<Gis_point>, 2ul>, boost::geometry::section<boost::geometry::model::box<Gis_point>, 2ul>, boost::geometry::detail::get_turns::get_turn_info_type<Gis_line_string, Gis_line_string, boost::geometry::detail::relate::turns::assign_policy<true>, boost::geometry::linestring_tag, boost::geometry::linestring_tag, boost::geometry::linear_tag, boost::geometry::linear_tag> >::apply<std::vector<boost::geometry::detail::overlay::turn_info<Gis_point, boost::geometry::segment_ratio<double>, boost::geometry::detail::overlay::turn_operation_linear<Gis_point, boost::geometry::segment_ratio<double> >, boost::array<boost::geometry::detail::overlay::turn_operation_linear<Gis_point, boost::geometry::segment_ratio<double> >, 2ul> >, std::allocator<boost::geometry::detail::overlay::turn_info<Gis_point, boost::geometry::segment_ratio<double>, boost::geometry::detail::overlay::turn_operation_linear<Gis_point, boost::geometry::segment_ratio<double> >, boost::array<boost::geometry::detail::overlay::turn_operation_linear<Gis_point, boost::geometry::segment_ratio<double> >, 2ul> > > >, boost::geometry::detail::no_rescale_policy, boost::geometry::detail::relate::linear_linear<Gis_line_string, Gis_line_string>::interrupt_policy_linear_linear<boost::geometry::detail::relate::static_mask_handler<boost::geometry::de9im::static_mask< (435 samples, 0.01%)
Protocol_classic::net_store_data (322 samples, 0.01%)
net_rx_action (3,620 samples, 0.12%)
get_quick_select (356 samples, 0.01%)
tcp_transmit_skb (2,642 samples, 0.09%)
close_thread_tables (1,310 samples, 0.04%)
net_flush (601 samples, 0.02%)
ip_output (1,587 samples, 0.05%)
ip_rcv (550 samples, 0.02%)
PT_select_item_list::contextualize (679 samples, 0.02%)
nf_iterate (793 samples, 0.03%)
tcp_v4_do_rcv (1,937 samples, 0.06%)
ip_queue_xmit (2,201 samples, 0.07%)
dev_hard_start_xmit (1,440 samples, 0.05%)
napi_gro_receive (2,730 samples, 0.09%)
cpuidle_idle_call (2,699 samples, 0.09%)
build_equal_items (1,671 samples, 0.05%)
close_thread_table (585 samples, 0.02%)
__hrtimer_start_range_ns (434 samples, 0.01%)
handler::ha_index_read_map (1,327 samples, 0.04%)
__memset_sse2 (289 samples, 0.01%)
ha_innobase::general_fetch (11,427 samples, 0.37%)
poll_schedule_timeout (3,532 samples, 0.12%)
__netif_receive_skb (568 samples, 0.02%)
dev_queue_xmit (763 samples, 0.03%)
do_command (231,680 samples, 7.59%)
do_command
ip_rcv (2,536 samples, 0.08%)
rr_from_pointers (620 samples, 0.02%)
vio_read (6,551 samples, 0.21%)
hrtimer_cancel (273 samples, 0.01%)
join_init_read_record (12,109 samples, 0.40%)
QUICK_RANGE_SELECT::get_next (14,987 samples, 0.49%)
ip_finish_output (1,663 samples, 0.05%)
my_lengthsp_8bit (656 samples, 0.02%)
nf_iterate (281 samples, 0.01%)
sys_madvise (417 samples, 0.01%)
flush_tlb_others_ipi (270 samples, 0.01%)
lock_sock_nested (3,881 samples, 0.13%)
__ip_local_out (386 samples, 0.01%)
Sort_param::make_sortkey (9,796 samples, 0.32%)
intel_idle (1,750 samples, 0.06%)
compare_between_int_result<unsigned long long> (449 samples, 0.01%)
my_strnxfrm_unicode (8,162 samples, 0.27%)
__do_softirq (3,548 samples, 0.12%)
my_lengthsp_8bit (325 samples, 0.01%)
Field_string::pack (473 samples, 0.02%)
Protocol_classic::net_store_data (1,421 samples, 0.05%)
tcp_sendmsg (996 samples, 0.03%)
sock_sendmsg (1,059 samples, 0.03%)
sk_stream_alloc_skb (964 samples, 0.03%)
local_bh_enable (761 samples, 0.02%)
napi_gro_receive (583 samples, 0.02%)
net_after_header_psi (1,537 samples, 0.05%)
start_thread (232,093 samples, 7.61%)
start_thread
handler::ha_rnd_pos (546 samples, 0.02%)
btr_search_guess_on_hash (462 samples, 0.02%)
tcp_rcv_established (398 samples, 0.01%)
find_busiest_group (391 samples, 0.01%)
nf_iterate (761 samples, 0.02%)
system_call_fastpath (12,841 samples, 0.42%)
net_rx_action (3,535 samples, 0.12%)
btr_pcur_move_to_next (453 samples, 0.01%)
rr_quick (15,268 samples, 0.50%)
handler::ha_index_read_map (420 samples, 0.01%)
net_write_packet (586 samples, 0.02%)
dev_hard_start_xmit (547 samples, 0.02%)
tcp_v4_rcv (467 samples, 0.02%)
ip_finish_output (287 samples, 0.01%)
open_tables (4,392 samples, 0.14%)
row_search_mvcc (965 samples, 0.03%)
napi_skb_finish (2,581 samples, 0.08%)
bond_start_xmit (1,363 samples, 0.04%)
__vdso_clock_gettime (763 samples, 0.03%)
LEX::reset (386 samples, 0.01%)
THD::enter_stage (571 samples, 0.02%)
alloc_query (385 samples, 0.01%)
__ip_local_out (361 samples, 0.01%)
napi_skb_finish (578 samples, 0.02%)
system_call_fastpath (1,556 samples, 0.05%)
mysql_parse (185,541 samples, 6.08%)
mysql_pa..
LEX::new_query (739 samples, 0.02%)
trans_commit_stmt (1,052 samples, 0.03%)
st_select_lex_unit::cleanup (996 samples, 0.03%)
memcpy (296 samples, 0.01%)
deactivate_task (707 samples, 0.02%)
Item_field::fix_fields (1,151 samples, 0.04%)
pfs_start_stage_v1 (781 samples, 0.03%)
__libc_send (538 samples, 0.02%)
dev_queue_xmit (1,301 samples, 0.04%)
mysql_unlock_read_tables (304 samples, 0.01%)
memcpy (264 samples, 0.01%)
rec_get_offsets_func (1,000 samples, 0.03%)
execute_sqlcom_select (159,888 samples, 5.24%)
execut..
napi_gro_receive (592 samples, 0.02%)
__do_page_fault (449 samples, 0.01%)
PTI_context< (700 samples, 0.02%)
sys_poll (5,108 samples, 0.17%)
insert_events_statements_history_long (508 samples, 0.02%)
memcpy (361 samples, 0.01%)
sub_select (91,450 samples, 3.00%)
su..
tcp_v4_rcv (470 samples, 0.02%)
st_select_lex::prepare (5,329 samples, 0.17%)
check_simple_equality (484 samples, 0.02%)
memcpy (419 samples, 0.01%)
Field::send_text (2,066 samples, 0.07%)
Lex_input_stream::add_digest_token (310 samples, 0.01%)
dev_queue_xmit (1,037 samples, 0.03%)
ha_innobase::general_fetch (4,141 samples, 0.14%)
nf_iterate (297 samples, 0.01%)
pfs_start_stage_v1 (416 samples, 0.01%)
madvise (427 samples, 0.01%)
sub_select_op (16,100 samples, 0.53%)
ip_local_deliver_finish (477 samples, 0.02%)
read_const (4,998 samples, 0.16%)
QUICK_RANGE_SELECT::reset (326 samples, 0.01%)
Sort_param::make_sortkey (10,855 samples, 0.36%)
hrtimer_start (570 samples, 0.02%)
handler::multi_range_read_next (5,232 samples, 0.17%)
my_convert (1,276 samples, 0.04%)
clock_gettime (900 samples, 0.03%)
Query_result_send::send_result_set_metadata (2,086 samples, 0.07%)
tcp_rcv_established (1,905 samples, 0.06%)
LEX::new_empty_query_block (299 samples, 0.01%)
check_quick_select (6,358 samples, 0.21%)
system_call_fastpath (1,108 samples, 0.04%)
cmp_dtuple_rec_with_match_low (294 samples, 0.01%)
nf_hook_slow (307 samples, 0.01%)
my_utf8_uni (927 samples, 0.03%)
QEP_TAB::cleanup (534 samples, 0.02%)
handle_query (154,537 samples, 5.07%)
handle..
ha_innobase::index_read (378 samples, 0.01%)
is_indexed_agg_distinct (260 samples, 0.01%)
dev_kfree_skb_any (324 samples, 0.01%)
create_tmp_table (633 samples, 0.02%)
ip_local_deliver_finish (470 samples, 0.02%)
memcpy (386 samples, 0.01%)
__poll (6,051 samples, 0.20%)
default_wake_function (672 samples, 0.02%)
tcp_v4_do_rcv (410 samples, 0.01%)
dispatch_command (207,052 samples, 6.79%)
dispatch_..
dev_hard_start_xmit (1,092 samples, 0.04%)
rec_get_offsets_func (294 samples, 0.01%)
tcp_write_xmit (326 samples, 0.01%)
system_call_fastpath (9,593 samples, 0.31%)
system_call_fastpath (5,166 samples, 0.17%)
filesort (18,601 samples, 0.61%)
schedule (623 samples, 0.02%)
pfs_get_thread_statement_locker_v1 (423 samples, 0.01%)
PT_table_factor_table_ident::contextualize (1,073 samples, 0.04%)
ip_queue_xmit (2,296 samples, 0.08%)
Item_func::fix_fields (1,437 samples, 0.05%)
__netif_receive_skb (558 samples, 0.02%)
handler::ha_index_next (4,267 samples, 0.14%)
setup_fields (1,481 samples, 0.05%)
ha_heap::rnd_next (521 samples, 0.02%)
MYSQLparse (12,265 samples, 0.40%)
release_sock (3,787 samples, 0.12%)
THD::send_result_set_row (2,247 samples, 0.07%)
try_to_wake_up (624 samples, 0.02%)
MDL_context::try_acquire_lock_impl (339 samples, 0.01%)
ixgbe_xmit_frame (372 samples, 0.01%)
tcp_transmit_skb (2,296 samples, 0.08%)
ip_rcv_finish (2,391 samples, 0.08%)
handler::read_range_first (437 samples, 0.01%)
sock_poll (521 samples, 0.02%)
evaluate_join_record (3,208 samples, 0.11%)
sock_recvmsg (12,352 samples, 0.40%)
JOIN::make_join_plan (19,981 samples, 0.66%)
optimize_cond (2,131 samples, 0.07%)
tcp_ack (729 samples, 0.02%)
JOIN::destroy (806 samples, 0.03%)
ip_queue_xmit (2,597 samples, 0.09%)
tcp_sendmsg (454 samples, 0.01%)
Unrecognized line: c2.5-x86_64/bin/mysqld) at ./stackcollapse-perf.pl line 339, <> line (3,002 samples, 0.10%)
netif_receive_skb (576 samples, 0.02%)
__do_softirq (741 samples, 0.02%)
net_read_raw_loop (20,891 samples, 0.68%)
local_bh_enable (3,688 samples, 0.12%)
THD::enter_stage (913 samples, 0.03%)
__tcp_push_pending_frames (592 samples, 0.02%)
__netif_receive_skb (2,547 samples, 0.08%)
open_table (2,316 samples, 0.08%)
page_cur_search_with_match_bytes (972 samples, 0.03%)
tcp_write_xmit (3,427 samples, 0.11%)
Item_field::fix_fields (287 samples, 0.01%)
ip_local_deliver_finish (468 samples, 0.02%)
join_init_read_record (19,423 samples, 0.64%)
row_search_mvcc (9,331 samples, 0.31%)
THD::enter_stage (269 samples, 0.01%)
ip_output (1,983 samples, 0.07%)
sys_recvfrom (12,802 samples, 0.42%)
mem_heap_create_func (287 samples, 0.01%)
__do_page_fault (485 samples, 0.02%)
handler::ha_index_read_idx_map (4,885 samples, 0.16%)
JOIN::make_tmp_tables_info (1,243 samples, 0.04%)
btr_cur_search_to_nth_level (4,431 samples, 0.15%)
tcp_v4_do_rcv (404 samples, 0.01%)
tcp_transmit_skb (3,140 samples, 0.10%)
Item_func_between::val_int (295 samples, 0.01%)
buf_page_get_gen (992 samples, 0.03%)
rr_unpack_from_buffer<true> (667 samples, 0.02%)
lex_start (1,338 samples, 0.04%)
handler::read_range_first (1,401 samples, 0.05%)
my_ismbchar_utf8 (1,024 samples, 0.03%)
JOIN::extract_func_dependent_tables (7,197 samples, 0.24%)
sys_madvise (938 samples, 0.03%)
dequeue_task_fair (499 samples, 0.02%)
JOIN::estimate_rowcount (9,163 samples, 0.30%)
ip_local_out (2,296 samples, 0.08%)
system_call_fastpath (941 samples, 0.03%)
ixgbe_poll (771 samples, 0.03%)
call_softirq (761 samples, 0.02%)
flush_tlb_mm (541 samples, 0.02%)
DsMrr_impl::dsmrr_next (14,527 samples, 0.48%)
_int_malloc (785 samples, 0.03%)
net_before_header_psi (355 samples, 0.01%)
PTI_comp_op::itemize (418 samples, 0.01%)
get_mm_parts (534 samples, 0.02%)
ipt_do_table (761 samples, 0.02%)
nf_hook_slow (324 samples, 0.01%)
JOIN::optimize (29,826 samples, 0.98%)
ip_local_deliver (2,278 samples, 0.07%)
page_fault (449 samples, 0.01%)
bond_start_xmit (981 samples, 0.03%)
local_bh_enable_ip (3,590 samples, 0.12%)
my_net_write (273 samples, 0.01%)
Item_equal::compare_const (642 samples, 0.02%)
Optimize_table_order::best_access_path (291 samples, 0.01%)
update_const_equal_items (919 samples, 0.03%)
napi_gro_receive (2,671 samples, 0.09%)
Protocol_classic::send_field_metadata (733 samples, 0.02%)
st_select_lex::setup_conds (2,165 samples, 0.07%)
__tcp_push_pending_frames (3,181 samples, 0.10%)
THD::send_result_metadata (1,854 samples, 0.06%)
pfs_start_idle_wait_v1 (305 samples, 0.01%)
__remove_hrtimer (295 samples, 0.01%)
ixgbe_xmit_frame_ring (326 samples, 0.01%)
lex_one_token (2,027 samples, 0.07%)
do_sys_poll (4,817 samples, 0.16%)
hp_rec_key_cmp (29,624 samples, 0.97%)
THD::enter_stage (441 samples, 0.01%)
mysql_unlock_tables (325 samples, 0.01%)
__kfree_skb (710 samples, 0.02%)
tick_nohz_stop_sched_tick (1,193 samples, 0.04%)
thread_return (1,843 samples, 0.06%)
Unrecognized line: ) at ./stackcollapse-perf.pl line 339, <> line (1,384,192 samples, 45.38%)
Unrecognized line: ) at ./stackcollapse-perf.pl line 339, <> line
rec_get_offsets_func (514 samples, 0.02%)
__hrtimer_start_range_ns (543 samples, 0.02%)
Protocol_classic::net_store_data (2,953 samples, 0.10%)
ha_innobase::build_template (265 samples, 0.01%)
net_send_eof (10,829 samples, 0.35%)
Field::send_text (359 samples, 0.01%)
Protocol_classic::end_row (773 samples, 0.03%)
lock_tables (3,669 samples, 0.12%)
ha_release_temporary_latches (261 samples, 0.01%)
tick_nohz_restart_sched_tick (760 samples, 0.02%)
__ip_local_out (793 samples, 0.03%)
[unknown] (778 samples, 0.03%)
ip_local_deliver (2,321 samples, 0.08%)
btr_search_guess_on_hash (1,173 samples, 0.04%)
__do_softirq (3,635 samples, 0.12%)
get_full_func_mm_tree (899 samples, 0.03%)
new_heap (450 samples, 0.01%)
tcp_ack (745 samples, 0.02%)
ip_local_deliver (493 samples, 0.02%)
QEP_tmp_table::put_record (328 samples, 0.01%)
ip_finish_output (1,367 samples, 0.04%)
st_select_lex::apply_local_transforms (453 samples, 0.01%)
memcpy (844 samples, 0.03%)
page_cur_search_with_match (937 samples, 0.03%)
tcp_write_xmit (3,134 samples, 0.10%)
__wake_up_common (726 samples, 0.02%)
row_sel_store_mysql_rec (2,876 samples, 0.09%)
row_sel_store_mysql_field_func (574 samples, 0.02%)
all (3,050,459 samples, 100%)
tcp_push_one (3,453 samples, 0.11%)
ip_local_out (391 samples, 0.01%)
native_flush_tlb_others (529 samples, 0.02%)
call_softirq (741 samples, 0.02%)
memcpy (272 samples, 0.01%)
buf_page_optimistic_get (484 samples, 0.02%)
insert_events_stages_history_long (323 samples, 0.01%)
row_sel_store_mysql_rec (336 samples, 0.01%)
Filesort_buffer::sort_buffer (745 samples, 0.02%)
QUICK_RANGE_SELECT::get_next (5,360 samples, 0.18%)
ha_innobase::index_read (3,557 samples, 0.12%)
select_precheck (1,328 samples, 0.04%)
Filesort_buffer::sort_buffer (787 samples, 0.03%)
pfs_start_stage_v1 (286 samples, 0.01%)
ixgbe_xmit_frame (426 samples, 0.01%)
sock_sendmsg (9,274 samples, 0.30%)
row_search_mvcc (294 samples, 0.01%)
JOIN::optimize_distinct_group_order (725 samples, 0.02%)
innobase_commit (310 samples, 0.01%)
my_hash_sort_utf8 (7,060 samples, 0.23%)
__do_softirq (761 samples, 0.02%)
btr_cur_optimistic_latch_leaves (556 samples, 0.02%)
tcp_v4_rcv (2,170 samples, 0.07%)
sch_direct_xmit (612 samples, 0.02%)
DsMrr_impl::dsmrr_info_const (6,264 samples, 0.21%)
my_utf8_uni (960 samples, 0.03%)
Optimize_table_order::best_extension_by_limited_search (391 samples, 0.01%)
Unrecognized line: data/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqld) at ./stackcollapse-perf.pl line 339, <> line (11,464 samples, 0.38%)
st_select_lex::st_select_lex (281 samples, 0.01%)
inet_recvmsg (11,980 samples, 0.39%)
Field_string::make_sort_key (9,747 samples, 0.32%)
TRP_RANGE::make_quick (410 samples, 0.01%)
my_charpos_mb (3,107 samples, 0.10%)
Field::send_text (4,287 samples, 0.14%)
tcp_rcv_established (1,900 samples, 0.06%)
hp_write_key (43,473 samples, 1.43%)
__libc_send (10,067 samples, 0.33%)
add_key_fields (452 samples, 0.01%)
check_access (807 samples, 0.03%)
zap_page_range (1,491 samples, 0.05%)
THD::send_result_set_row (4,684 samples, 0.15%)
TaoCrypt::HASHwithTransform::Final (272 samples, 0.01%)
__kfree_skb (294 samples, 0.01%)
row_search_mvcc (2,866 samples, 0.09%)
ixgbe_poll (3,485 samples, 0.11%)
__libc_recv (13,826 samples, 0.45%)
mysql_execute_command (167,494 samples, 5.49%)
mysql_e..
my_net_write (636 samples, 0.02%)
sys_madvise (1,555 samples, 0.05%)
get_lock_data (853 samples, 0.03%)
sock_def_readable (723 samples, 0.02%)
napi_skb_finish (2,639 samples, 0.09%)
sel_restore_position_for_mysql (725 samples, 0.02%)
THD::enter_stage (527 samples, 0.02%)
Field_string::val_str (809 samples, 0.03%)
do_page_fault (489 samples, 0.02%)
ip_rcv (543 samples, 0.02%)
dequeue_task (685 samples, 0.02%)
malloc (733 samples, 0.02%)
__wake_up_sync_key (698 samples, 0.02%)
PT_join_table_list::contextualize (1,136 samples, 0.04%)
dev_queue_xmit (742 samples, 0.02%)
tcp_poll (469 samples, 0.02%)
__wake_up_common (674 samples, 0.02%)
QEP_TAB::sort_table (12,081 samples, 0.40%)
THD::enter_stage (678 samples, 0.02%)
__memset_sse2 (559 samples, 0.02%)
tcp_push (335 samples, 0.01%)
Field_string::make_sort_key (9,620 samples, 0.32%)
__do_softirq (793 samples, 0.03%)
btr_estimate_n_rows_in_range_low (5,004 samples, 0.16%)
skb_entail (345 samples, 0.01%)
Item_equal::update_const (827 samples, 0.03%)
mysql_lock_tables (2,913 samples, 0.10%)
get_key_scans_params (6,492 samples, 0.21%)
Item_func_between::val_int (945 samples, 0.03%)
madvise (1,606 samples, 0.05%)
sys_sendto (500 samples, 0.02%)
handler::multi_range_read_info_const (6,116 samples, 0.20%)
tcp_send_ack (2,296 samples, 0.08%)
my_ismbchar_utf8 (2,239 samples, 0.07%)
ipt_post_routing_hook (761 samples, 0.02%)
system_call_fastpath (502 samples, 0.02%)
ip_rcv_finish (519 samples, 0.02%)
tcp_v4_do_rcv (1,931 samples, 0.06%)
ha_innobase::position (319 samples, 0.01%)
pick_next_task_fair (348 samples, 0.01%)
get_func_mm_tree (629 samples, 0.02%)
PT_select::contextualize (3,427 samples, 0.11%)
do_page_fault (449 samples, 0.01%)
unmap_vmas (818 samples, 0.03%)
Protocol_classic::send_ok (663 samples, 0.02%)
JOIN::exec (112,541 samples, 3.69%)
JOIN..
find_or_create_digest (3,114 samples, 0.10%)
btr_cur_search_to_nth_level (554 samples, 0.02%)
PT_select_init2::contextualize (3,279 samples, 0.11%)
find_keyword (798 samples, 0.03%)
zap_page_range (395 samples, 0.01%)
system_call_fastpath (417 samples, 0.01%)
MYSQLlex (2,690 samples, 0.09%)
find_field_in_table_ref (479 samples, 0.02%)
my_ismbchar_utf8 (291 samples, 0.01%)
__kfree_skb (265 samples, 0.01%)
netif_receive_skb (2,573 samples, 0.08%)
parse_sql (12,802 samples, 0.42%)
net_write_packet (10,491 samples, 0.34%)
compute_md5_hash (662 samples, 0.02%)
my_strnxfrm_unicode (8,329 samples, 0.27%)
Protocol_classic::read_packet (23,247 samples, 0.76%)
ha_innobase::update_thd (335 samples, 0.01%)
Item_func_between::fix_fields (474 samples, 0.02%)
st_select_lex::optimize (31,136 samples, 1.02%)
find_field_in_tables (626 samples, 0.02%)
pfs_start_stage_v1 (470 samples, 0.02%)
my_utf8_uni (1,255 samples, 0.04%)
tcp_push (3,243 samples, 0.11%)
pfs_end_statement_v1 (5,595 samples, 0.18%)
madvise (959 samples, 0.03%)
tcp_v4_rcv (2,143 samples, 0.07%)
sock_def_readable (786 samples, 0.03%)
call_softirq (3,635 samples, 0.12%)
Optimize_table_order::choose_table_order (633 samples, 0.02%)
__tcp_push_pending_frames (333 samples, 0.01%)
mysqld (246,218 samples, 8.07%)
mysqld
schedule (457 samples, 0.01%)
pollwake (642 samples, 0.02%)
ip_rcv (2,491 samples, 0.08%)
st_select_lex::add_table_to_list (847 samples, 0.03%)
btr_pcur_restore_position_func (674 samples, 0.02%)
ixgbe_poll (740 samples, 0.02%)
ip_local_deliver_finish (2,203 samples, 0.07%)
pfs_rw_lock_s_lock_func (293 samples, 0.01%)
copy_user_enhanced_fast_string (333 samples, 0.01%)
dev_kfree_skb_any (305 samples, 0.01%)
THD::enter_stage (347 samples, 0.01%)
hp_rec_hashnr (12,671 samples, 0.42%)
tcp_rcv_established (406 samples, 0.01%)
ha_commit_trans (887 samples, 0.03%)
handler::read_range_next (4,507 samples, 0.15%)
my_lfind (876 samples, 0.03%)
dequeue_entity (342 samples, 0.01%)
pollwake (688 samples, 0.02%)
tcp_push (597 samples, 0.02%)
my_strnncoll_binary (360 samples, 0.01%)
my_lengthsp_8bit (331 samples, 0.01%)
Item_sum_sum::add (612 samples, 0.02%)
__netif_receive_skb (555 samples, 0.02%)
ha_commit_low (461 samples, 0.02%)
evaluate_join_record (55,131 samples, 1.81%)
e..
pfs_start_stage_v1 (561 samples, 0.02%)
net_send_ok (641 samples, 0.02%)
zap_page_range (895 samples, 0.03%)
__netif_receive_skb (2,591 samples, 0.08%)
Query_result_send::send_data (2,506 samples, 0.08%)
default_send_IPI_mask_sequence_phys (385 samples, 0.01%)
napi_skb_finish (565 samples, 0.02%)
do_huge_pmd_anonymous_page (440 samples, 0.01%)
call_softirq (793 samples, 0.03%)
end_write (45,454 samples, 1.49%)
consume_skb (306 samples, 0.01%)
THD::enter_stage (491 samples, 0.02%)
tcp_recvmsg (11,788 samples, 0.39%)
pfs_spawn_thread (232,082 samples, 7.61%)
pfs_spawn_..
clear_page_c_e (405 samples, 0.01%)
QEP_TAB::sort_table (18,885 samples, 0.62%)
JOIN::join_free (729 samples, 0.02%)
DsMrr_impl::dsmrr_next (5,286 samples, 0.17%)
pfs_start_stage_v1 (409 samples, 0.01%)
Optimize_table_order::greedy_search (440 samples, 0.01%)
malloc_consolidate (434 samples, 0.01%)
handle_connection (232,002 samples, 7.61%)
handle_con..