Off-CPU Time Flame Graph
Reset Zoom
Search
io_schedule (19,217 us, 0.01%)
io_schedule (22,815 us, 0.01%)
entry_SYSCALL_64_fastpath (19,184 us, 0.01%)
__schedule (19,214 us, 0.01%)
ha_innobase::extra(ha_extra_function) (23,933 us, 0.01%)
schedule (37,265 us, 0.02%)
schedule (21,871 us, 0.01%)
__memcpy_sse2_unaligned (337,895 us, 0.16%)
schedule (95,027 us, 0.04%)
handler::ha_index_next(unsigned char*) (13,948,252 us, 6.60%)
handler::..
schedule (77,767 us, 0.04%)
- (57,448 us, 0.03%)
entry_SYSCALL_64_fastpath (4,569,013 us, 2.16%)
e..
io_schedule (19,201 us, 0.01%)
sys_futex (6,000,644 us, 2.84%)
sy..
entry_SYSCALL_64_fastpath (39,481 us, 0.02%)
finish_task_switch (19,201 us, 0.01%)
SyS_pread64 (47,998 us, 0.02%)
vfs_read (432,254 us, 0.20%)
- (337,895 us, 0.16%)
generic_file_read_iter (18,197 us, 0.01%)
generic_file_read_iter (21,871 us, 0.01%)
schedule (30,784 us, 0.01%)
schedule (19,307 us, 0.01%)
__schedule (174,497 us, 0.08%)
- (19,126 us, 0.01%)
SyS_pread64 (18,884 us, 0.01%)
finish_task_switch (19,214 us, 0.01%)
generic_file_read_iter (24,837 us, 0.01%)
vfs_read (95,027 us, 0.04%)
MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**) (45,792 us, 0.02%)
handler::ha_index_next(unsigned char*) (4,649,817 us, 2.20%)
h..
Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) (208,514,412 us, 98.68%)
Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*)
schedule (27,373 us, 0.01%)
schedule (35,195 us, 0.02%)
SyS_pread64 (4,260,516 us, 2.02%)
S..
schedule (19,146 us, 0.01%)
st_select_lex::optimize(THD*) (146,778,283 us, 69.46%)
st_select_lex::optimize(THD*)
__vfs_read (294,788 us, 0.14%)
schedule (23,779 us, 0.01%)
finish_task_switch (276,243 us, 0.13%)
__vfs_read (4,559,141 us, 2.16%)
_..
[unknown] (15,782,796 us, 7.47%)
[unknown]
buf_read_page(page_id_t const&, page_size_t const&) (27,686 us, 0.01%)
finish_task_switch (355,460 us, 0.17%)
__vfs_read (337,452 us, 0.16%)
futex_wait (6,000,644 us, 2.84%)
fu..
exit_to_usermode_loop (21,141 us, 0.01%)
do_futex (43,721 us, 0.02%)
io_schedule (29,743 us, 0.01%)
__vfs_read (21,871 us, 0.01%)
SyS_pread64 (95,027 us, 0.04%)
hp_rec_key_cmp (126,449 us, 0.06%)
generic_file_read_iter (276,243 us, 0.13%)
[unknown] (3,929,785 us, 1.86%)
[..
do_futex (6,000,699 us, 2.84%)
do..
- (31,341 us, 0.01%)
finish_task_switch (43,721 us, 0.02%)
SyS_pread64 (19,307 us, 0.01%)
[unknown] (32,473 us, 0.02%)
sys_futex (5,000,128 us, 2.37%)
s..
ha_commit_low(THD*, bool, bool) (326,581 us, 0.15%)
schedule (21,141 us, 0.01%)
Protocol_classic::send_field_metadata(Send_field*, charset_info_st const*) (23,456 us, 0.01%)
open_table(THD*, TABLE_LIST*, Open_table_context*) (138,030 us, 0.07%)
schedule (1,460,795 us, 0.69%)
[unknown] (18,839 us, 0.01%)
Item_func::fix_fields(THD*, Item**) (30,607 us, 0.01%)
schedule (23,543 us, 0.01%)
ha_heap::write_row(unsigned char*) (200,713 us, 0.09%)
generic_file_read_iter (348,943 us, 0.17%)
schedule (27,511 us, 0.01%)
st_select_lex::prepare(THD*) (174,081 us, 0.08%)
generic_file_read_iter (27,511 us, 0.01%)
pfs_start_rwlock_rdwait_v1 (5,007,209 us, 2.37%)
p..
__schedule (27,913 us, 0.01%)
generic_file_read_iter (22,815 us, 0.01%)
- (21,139 us, 0.01%)
Prepared_statement::close_cursor() (4,645,399 us, 2.20%)
P..
- (4,241,932 us, 2.01%)
-
trans_commit_stmt(THD*) (4,252,055 us, 2.01%)
t..
io_schedule (19,291 us, 0.01%)
schedule (41,783 us, 0.02%)
- (43,773 us, 0.02%)
generic_file_read_iter (4,559,141 us, 2.16%)
g..
io_schedule (21,871 us, 0.01%)
rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) (22,506 us, 0.01%)
schedule (23,467 us, 0.01%)
entry_SYSCALL_64_fastpath (355,515 us, 0.17%)
do_futex (35,195 us, 0.02%)
- (129,955 us, 0.06%)
SyS_pread64 (19,217 us, 0.01%)
[unknown] (71,004,990 us, 33.60%)
[unknown]
[unknown] (4,669,852 us, 2.21%)
[..
finish_task_switch (41,783 us, 0.02%)
schedule (266,622 us, 0.13%)
SyS_pread64 (4,166,421 us, 1.97%)
S..
vfs_read (276,243 us, 0.13%)
[unknown] (71,103,336 us, 33.65%)
[unknown]
io_schedule (19,160 us, 0.01%)
SyS_pread64 (22,815 us, 0.01%)
finish_task_switch (20,265 us, 0.01%)
vfs_read (4,633,409 us, 2.19%)
v..
schedule (27,913 us, 0.01%)
__schedule (106,087 us, 0.05%)
SyS_pread64 (8,669,519 us, 4.10%)
SyS_..
entry_SYSCALL_64_fastpath (367,862 us, 0.17%)
ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (60,610,144 us, 28.68%)
ha_innobase::index_read(unsigned char*, unsig..
schedule (18,959 us, 0.01%)
handle_connection (211,311,889 us, 100.00%)
handle_connection
io_schedule (44,300 us, 0.02%)
- (20,664 us, 0.01%)
schedule (18,986 us, 0.01%)
SyS_pread64 (18,372 us, 0.01%)
vfs_read (19,208 us, 0.01%)
buf_page_init_for_read(dberr_t*, unsigned long, page_id_t const&, page_size_t const&, unsigned long) (218,283 us, 0.10%)
__schedule (1,294,433 us, 0.61%)
btr_pcur_move_to_next_page(btr_pcur_t*, mtr_t*) (27,686 us, 0.01%)
swapgs_restore_regs_and_return_to_usermode (18,794 us, 0.01%)
generic_file_read_iter (1,460,795 us, 0.69%)
[unknown] (32,502 us, 0.02%)
__vfs_read (250,514 us, 0.12%)
__vfs_read (32,474 us, 0.02%)
finish_task_switch (26,914 us, 0.01%)
__vfs_read (29,743 us, 0.01%)
do_command(THD*) (211,311,889 us, 100.00%)
do_command(THD*)
SyS_pread64 (348,943 us, 0.17%)
handler::multi_range_read_next(char**) (4,682,792 us, 2.22%)
h..
finish_task_switch (204,165 us, 0.10%)
SyS_pread64 (139,764 us, 0.07%)
[unknown] (321,862 us, 0.15%)
my_getsystime (41,332 us, 0.02%)
io_schedule (174,497 us, 0.08%)
SyS_pread64 (32,474 us, 0.02%)
__schedule (46,453 us, 0.02%)
__schedule (1,460,795 us, 0.69%)
- (40,462 us, 0.02%)
buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) (49,808,988 us, 23.57%)
buf_page_get_gen(page_id_t const&, pa..
generic_file_read_iter (48,462,263 us, 22.93%)
generic_file_read_iter
__vfs_read (27,245 us, 0.01%)
SyS_pread64 (355,496 us, 0.17%)
SyS_pread64 (20,265 us, 0.01%)
__schedule (95,027 us, 0.04%)
__vfs_read (19,291 us, 0.01%)
io_schedule (4,633,409 us, 2.19%)
i..
Field_long::val_int() (4,118,344 us, 1.95%)
F..
vfs_read (31,669 us, 0.01%)
schedule (432,250 us, 0.20%)
entry_SYSCALL_64_fastpath (82,086 us, 0.04%)
handler::compare_key(st_key_range*) (27,746 us, 0.01%)
__schedule (29,743 us, 0.01%)
finish_task_switch (185,765 us, 0.09%)
vfs_read (4,260,516 us, 2.02%)
v..
generic_file_read_iter (4,112,441 us, 1.95%)
g..
schedule (24,003 us, 0.01%)
- (4,118,344 us, 1.95%)
-
finish_task_switch (27,373 us, 0.01%)
SyS_pread64 (294,788 us, 0.14%)
mtr_t::commit() (36,140 us, 0.02%)
__vfs_read (29,951 us, 0.01%)
vfs_read (266,622 us, 0.13%)
entry_SYSCALL_64_fastpath (53,682 us, 0.03%)
Item_equal::update_const(THD*) (280,597 us, 0.13%)
schedule (3,895,289 us, 1.84%)
s..
handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*) (71,062,195 us, 33.63%)
handler::multi_range_read_info_const(unsigned int, st_..
__vfs_read (24,003 us, 0.01%)
- (168,710 us, 0.08%)
vfs_read (24,837 us, 0.01%)
insert_events_statements_history(PFS_thread*, PFS_events_statements*) (51,042 us, 0.02%)
open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) (222,619 us, 0.11%)
close_thread_tables(THD*) (43,447 us, 0.02%)
generic_file_read_iter (47,963,028 us, 22.70%)
generic_file_read_iter
io_schedule (19,229 us, 0.01%)
schedule (29,743 us, 0.01%)
SyS_pread64 (29,951 us, 0.01%)
vfs_read (24,719 us, 0.01%)
vfs_read (49,796 us, 0.02%)
entry_SYSCALL_64_fastpath (31,743 us, 0.02%)
entry_SYSCALL_64_fastpath (23,467 us, 0.01%)
__schedule (82,086 us, 0.04%)
finish_task_switch (18,197 us, 0.01%)
finish_task_switch (24,063 us, 0.01%)
prepare_exit_to_usermode (18,794 us, 0.01%)
SyS_pread64 (29,743 us, 0.01%)
[unknown] (37,619 us, 0.02%)
__schedule (19,177 us, 0.01%)
prepare_exit_to_usermode (27,913 us, 0.01%)
syscall_return_slowpath (120,570 us, 0.06%)
- (19,834 us, 0.01%)
JOIN::optimize() (146,722,590 us, 69.43%)
JOIN::optimize()
return_from_SYSCALL_64 (337,571 us, 0.16%)
finish_task_switch (23,543 us, 0.01%)
Sort_param::make_sortkey(unsigned char*, unsigned char const*) (6,103,517 us, 2.89%)
So..
__schedule (6,000,644 us, 2.84%)
__..
- (36,042 us, 0.02%)
generic_file_read_iter (350,051 us, 0.17%)
generic_file_read_iter (19,223 us, 0.01%)
- (185,781 us, 0.09%)
Item_bool_func2::cleanup() (6,025,648 us, 2.85%)
It..
- (19,130 us, 0.01%)
io_schedule (139,764 us, 0.07%)
schedule (6,000,644 us, 2.84%)
sc..
schedule (5,000,128 us, 2.37%)
s..
MDL_context::find_ticket(MDL_request*, enum_mdl_duration*) (21,139 us, 0.01%)
- (101,775 us, 0.05%)
__schedule (18,988 us, 0.01%)
generic_file_read_iter (19,229 us, 0.01%)
futex_wait (21,601 us, 0.01%)
page_cur_search_with_match_bytes(buf_block_t const*, dict_index_t const*, dtuple_t const*, page_cur_mode_t, unsigned long*, unsigned long*, unsigned long*, unsigned long*, page_cur_t*) (52,113 us, 0.02%)
vfs_read (29,951 us, 0.01%)
SyS_pread64 (4,241,232 us, 2.01%)
S..
SyS_pread64 (21,871 us, 0.01%)
close_thread_table(THD*, TABLE**) (27,426 us, 0.01%)
io_schedule (4,260,508 us, 2.02%)
i..
finish_task_switch (266,622 us, 0.13%)
QUICK_RANGE_SELECT::get_next() (14,030,327 us, 6.64%)
QUICK_RAN..
finish_task_switch (27,245 us, 0.01%)
finish_task_switch (6,000,699 us, 2.84%)
fi..
swapgs_restore_regs_and_return_to_usermode (106,087 us, 0.05%)
__schedule (20,514 us, 0.01%)
__schedule (3,895,289 us, 1.84%)
_..
finish_task_switch (53,650 us, 0.03%)
schedule (22,293 us, 0.01%)
schedule (21,124 us, 0.01%)
io_schedule (201,887 us, 0.10%)
finish_task_switch (19,217 us, 0.01%)
io_schedule (348,943 us, 0.17%)
Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) (19,729 us, 0.01%)
finish_task_switch (19,307 us, 0.01%)
sys_futex (18,986 us, 0.01%)
buf_LRU_free_page(buf_page_t*, bool) (85,367 us, 0.04%)
schedule (8,669,511 us, 4.10%)
sche..
io_schedule (32,474 us, 0.02%)
vfs_read (23,166 us, 0.01%)
handler::ha_write_row(unsigned char*) (203,059 us, 0.10%)
__schedule (19,223 us, 0.01%)
schedule (22,126 us, 0.01%)
__schedule (6,001,196 us, 2.84%)
__..
- (37,817 us, 0.02%)
__vfs_read (31,124 us, 0.01%)
btr_cur_optimistic_latch_leaves(buf_block_t*, unsigned long, unsigned long*, btr_cur_t*, char const*, unsigned long, mtr_t*) (45,343 us, 0.02%)
ha_commit_trans(THD*, bool, bool) (4,251,137 us, 2.01%)
h..
__GI___libc_pread (70,102,192 us, 33.17%)
__GI___libc_pread
vfs_read (19,160 us, 0.01%)
exit_to_usermode_loop (18,794 us, 0.01%)
__schedule (71,445 us, 0.03%)
io_schedule (29,301 us, 0.01%)
exit_to_usermode_loop (71,445 us, 0.03%)
schedule (43,301 us, 0.02%)
SyS_pread64 (276,243 us, 0.13%)
- (48,876,467 us, 23.13%)
-
sys_futex (43,721 us, 0.02%)
entry_SYSCALL_64_fastpath (432,254 us, 0.20%)
entry_SYSCALL_64_fastpath (1,294,515 us, 0.61%)
- (254,802 us, 0.12%)
generic_file_read_iter (37,585 us, 0.02%)
entry_SYSCALL_64_fastpath (26,914 us, 0.01%)
schedule (19,291 us, 0.01%)
finish_task_switch (5,000,109 us, 2.37%)
f..
SyS_pread64 (46,453 us, 0.02%)
__schedule (4,559,131 us, 2.16%)
_..
SyS_pread64 (24,071 us, 0.01%)
io_schedule (26,914 us, 0.01%)
swapgs_restore_regs_and_return_to_usermode (71,445 us, 0.03%)
- (10,357,237 us, 4.90%)
-
__memcmp_sse4_1 (37,619 us, 0.02%)
finish_task_switch (19,291 us, 0.01%)
find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, unsigned long, bool) (19,531 us, 0.01%)
- (1,467,282 us, 0.69%)
__vfs_read (4,166,421 us, 1.97%)
_..
- (180,895 us, 0.09%)
finish_task_switch (21,601 us, 0.01%)
__schedule (19,184 us, 0.01%)
__schedule (18,372 us, 0.01%)
__schedule (19,146 us, 0.01%)
trans_register_ha(THD*, bool, handlerton*, unsigned long long const*) (31,341 us, 0.01%)
io_schedule (18,372 us, 0.01%)
__vfs_read (26,914 us, 0.01%)
finish_task_switch (18,372 us, 0.01%)
SyS_poll (243,813 us, 0.12%)
schedule (19,217 us, 0.01%)
prepare_exit_to_usermode (22,293 us, 0.01%)
make_cond_for_table(Item*, unsigned long long, unsigned long long, bool) (19,834 us, 0.01%)
io_schedule (168,660 us, 0.08%)
open_tables_for_query(THD*, TABLE_LIST*, unsigned int) (230,884 us, 0.11%)
generic_file_read_iter (29,301 us, 0.01%)
prepare_exit_to_usermode (30,784 us, 0.01%)
__schedule (337,410 us, 0.16%)
__vfs_read (355,496 us, 0.17%)
Query_result_send::send_result_set_metadata(List<Item>&, unsigned int) (55,082 us, 0.03%)
finish_task_switch (168,900 us, 0.08%)
__schedule (26,593 us, 0.01%)
vfs_read (257,718 us, 0.12%)
vfs_read (29,397 us, 0.01%)
schedule (4,112,367 us, 1.95%)
s..
ha_innobase::change_active_index(unsigned int) (4,316,798 us, 2.04%)
h..
swapgs_restore_regs_and_return_to_usermode (22,126 us, 0.01%)
futex_wait (5,000,109 us, 2.37%)
f..
schedule (4,241,232 us, 2.01%)
s..
SyS_pread64 (23,166 us, 0.01%)
schedule (21,601 us, 0.01%)
finish_task_switch (337,410 us, 0.16%)
Rpl_transaction_ctx::cleanup() (6,020,592 us, 2.85%)
Rp..
generic_file_read_iter (1,294,433 us, 0.61%)
return_from_SYSCALL_64 (77,767 us, 0.04%)
btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*) (49,904,699 us, 23.62%)
btr_cur_search_to_nth_level(dict_inde..
io_schedule (22,067,170 us, 10.44%)
io_schedule
- (19,048 us, 0.01%)
Item_param::val_int() (19,571 us, 0.01%)
generic_file_read_iter (4,633,409 us, 2.19%)
g..
vfs_read (47,963,028 us, 22.70%)
vfs_read
io_schedule (49,796 us, 0.02%)
schedule (19,214 us, 0.01%)
mtr_t::start(bool, bool) (26,344 us, 0.01%)
SyS_pread64 (19,223 us, 0.01%)
vfs_read (41,783 us, 0.02%)
__vfs_read (53,650 us, 0.03%)
- (20,471 us, 0.01%)
generic_file_read_iter (22,115,060 us, 10.47%)
generic_file_re..
__vfs_read (29,301 us, 0.01%)
- (23,176 us, 0.01%)
generic_file_read_iter (19,307 us, 0.01%)
entry_SYSCALL_64_fastpath (4,260,516 us, 2.02%)
e..
__schedule (41,783 us, 0.02%)
entry_SYSCALL_64_fastpath (204,165 us, 0.10%)
return_from_SYSCALL_64 (1,741,018 us, 0.82%)
do_futex (18,986 us, 0.01%)
io_schedule (47,960,156 us, 22.70%)
io_schedule
__vfs_read (27,373 us, 0.01%)
entry_SYSCALL_64_fastpath (24,719 us, 0.01%)
generic_file_read_iter (174,497 us, 0.08%)
entry_SYSCALL_64_fastpath (6,026,033 us, 2.85%)
en..
futex_wait_queue_me (5,000,128 us, 2.37%)
f..
my_timer_microseconds (168,710 us, 0.08%)
SyS_pread64 (4,559,141 us, 2.16%)
S..
do_futex (23,543 us, 0.01%)
__vfs_read (19,208 us, 0.01%)
- (22,855 us, 0.01%)
exit_to_usermode_loop (20,056 us, 0.01%)
trx_commit_low(trx_t*, mtr_t*) (295,025 us, 0.14%)
do_futex (20,514 us, 0.01%)
hp_write_key (153,504 us, 0.07%)
finish_task_switch (6,001,196 us, 2.84%)
fi..
__vfs_read (19,177 us, 0.01%)
__vfs_read (139,764 us, 0.07%)
io_schedule (4,241,232 us, 2.01%)
i..
io_schedule (29,951 us, 0.01%)
__vfs_read (24,719 us, 0.01%)
entry_SYSCALL_64_fastpath (31,124 us, 0.01%)
mysqld (211,311,889 us, 100.00%)
mysqld
- (51,042 us, 0.02%)
entry_SYSCALL_64_fastpath (168,660 us, 0.08%)
finish_task_switch (165,573 us, 0.08%)
entry_SYSCALL_64_fastpath (82,171 us, 0.04%)
vfs_read (19,217 us, 0.01%)
finish_task_switch (49,796 us, 0.02%)
__vfs_read (82,171 us, 0.04%)
__vfs_read (19,184 us, 0.01%)
finish_task_switch (44,300 us, 0.02%)
vfs_read (19,307 us, 0.01%)
vfs_read (4,241,232 us, 2.01%)
v..
TC_LOG_DUMMY::commit(THD*, bool) (4,251,137 us, 2.01%)
T..
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long) (70,102,192 us, 33.17%)
os_file_read_func(IORequest&, int, void*, unsigned lo..
[unknown] (4,177,400 us, 1.98%)
[..
io_schedule (8,669,511 us, 4.10%)
io_s..
vfs_read (24,003 us, 0.01%)
sys_futex (6,000,699 us, 2.84%)
sy..
exit_to_usermode_loop (25,416 us, 0.01%)
all (211,311,889 us, 100%)
schedule (201,887 us, 0.10%)
btr_pcur_restore_position_func(unsigned long, btr_pcur_t*, char const*, unsigned long, mtr_t*) (47,600 us, 0.02%)
schedule (1,496,333 us, 0.71%)
finish_task_switch (37,585 us, 0.02%)
mysql_opt_change_db(THD*, st_mysql_const_lex_string const&, st_mysql_lex_string*, bool, bool*) (36,620 us, 0.02%)
__vfs_read (49,796 us, 0.02%)
__schedule (22,815 us, 0.01%)
finish_task_switch (4,559,131 us, 2.16%)
f..
SyS_pread64 (29,397 us, 0.01%)
schedule (29,951 us, 0.01%)
__schedule (19,208 us, 0.01%)
entry_SYSCALL_64_fastpath (48,102 us, 0.02%)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (4,289,494 us, 2.03%)
r..
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) (48,876,467 us, 23.13%)
fil_io(IORequest const&, bool, page_..
entry_SYSCALL_64_fastpath (266,622 us, 0.13%)
__schedule (243,813 us, 0.12%)
- (349,864 us, 0.17%)
SyS_pread64 (432,254 us, 0.20%)
__vfs_read (23,166 us, 0.01%)
__schedule (19,201 us, 0.01%)
finish_task_switch (120,570 us, 0.06%)
[unknown] (349,864 us, 0.17%)
entry_SYSCALL_64_fastpath (294,788 us, 0.14%)
net_send_ok(THD*, unsigned int, unsigned int, unsigned long long, unsigned long long, char const*, bool) (20,725 us, 0.01%)
__schedule (5,000,109 us, 2.37%)
_..
[unknown] (1,763,112 us, 0.83%)
vfs_read (348,943 us, 0.17%)
prepare_exit_to_usermode (21,124 us, 0.01%)
generic_file_read_iter (19,177 us, 0.01%)
mysql_unlock_some_tables(THD*, TABLE**, unsigned int) (68,567 us, 0.03%)
finish_task_switch (24,837 us, 0.01%)
- (70,102,192 us, 33.17%)
-
schedule (19,208 us, 0.01%)
schedule_hrtimeout_range_clock (243,813 us, 0.12%)
filesort(THD*, Filesort*, bool, unsigned long long*, unsigned long long*, unsigned long long*) (10,897,238 us, 5.16%)
fileso..
pfs_start_idle_wait_v1 (168,710 us, 0.08%)
[unknown] (19,408 us, 0.01%)
schedule (168,660 us, 0.08%)
io_schedule (26,593 us, 0.01%)
schedule (185,765 us, 0.09%)
io_schedule (1,294,433 us, 0.61%)
- (29,976 us, 0.01%)
SyS_pread64 (24,003 us, 0.01%)
__schedule (19,307 us, 0.01%)
__schedule (168,660 us, 0.08%)
schedule (22,067,170 us, 10.44%)
schedule
io_schedule (19,177 us, 0.01%)
SyS_pread64 (19,291 us, 0.01%)
generic_file_read_iter (31,124 us, 0.01%)
schedule (19,177 us, 0.01%)
Item_param::convert_str_value(THD*) (36,976 us, 0.02%)
__GI___libc_malloc (5,002,684 us, 2.37%)
_..
finish_task_switch (18,959 us, 0.01%)
__vfs_read (174,497 us, 0.08%)
vfs_read (19,223 us, 0.01%)
sys_futex (20,514 us, 0.01%)
- (27,055 us, 0.01%)
swapgs_restore_regs_and_return_to_usermode (22,293 us, 0.01%)
__schedule (48,283,622 us, 22.85%)
__schedule
io_schedule (48,283,622 us, 22.85%)
io_schedule
SyS_pread64 (53,650 us, 0.03%)
vfs_read (168,660 us, 0.08%)
schedule (29,397 us, 0.01%)
__schedule (18,986 us, 0.01%)
vfs_read (337,452 us, 0.16%)
- (22,196 us, 0.01%)
io_schedule (294,788 us, 0.14%)
vfs_read (740,484 us, 0.35%)
schedule (32,474 us, 0.02%)
__schedule (19,291 us, 0.01%)
finish_task_switch (432,250 us, 0.20%)
finish_task_switch (20,056 us, 0.01%)
vfs_read (19,146 us, 0.01%)
vfs_read (27,373 us, 0.01%)
Filesort_buffer::sort_buffer(Sort_param const*, unsigned int) (58,078 us, 0.03%)
__vfs_read (18,884 us, 0.01%)
io_schedule (4,166,421 us, 1.97%)
i..
vfs_read (3,895,299 us, 1.84%)
v..
__schedule (23,543 us, 0.01%)
finish_task_switch (43,301 us, 0.02%)
__lll_unlock_wake (19,646 us, 0.01%)
buf_page_io_complete(buf_page_t*, bool) (399,987 us, 0.19%)
schedule (740,484 us, 0.35%)
generic_file_read_iter (29,397 us, 0.01%)
__schedule (4,260,508 us, 2.02%)
_..
vfs_read (26,914 us, 0.01%)
schedule (350,051 us, 0.17%)
- (436,627 us, 0.21%)
finish_task_switch (20,514 us, 0.01%)
io_schedule (37,585 us, 0.02%)
finish_task_switch (21,141 us, 0.01%)
__schedule (139,764 us, 0.07%)
return_from_SYSCALL_64 (185,765 us, 0.09%)
[unknown] (50,807 us, 0.02%)
SyS_pread64 (29,301 us, 0.01%)
swapgs_restore_regs_and_return_to_usermode (25,416 us, 0.01%)
generic_file_read_iter (19,160 us, 0.01%)
schedule (31,124 us, 0.01%)
Field_string::pack(unsigned char*, unsigned char const*, unsigned int, bool) (37,817 us, 0.02%)
__schedule (44,300 us, 0.02%)
SyS_pread64 (204,165 us, 0.10%)
trx_commit_for_mysql(trx_t*) (295,025 us, 0.14%)
entry_SYSCALL_64_fastpath (348,943 us, 0.17%)
entry_SYSCALL_64_fastpath (29,951 us, 0.01%)
vio_socket_io_wait (1,763,112 us, 0.83%)
io_schedule (19,307 us, 0.01%)
finish_task_switch (174,497 us, 0.08%)
generic_file_read_iter (95,027 us, 0.04%)
vfs_read (4,112,441 us, 1.95%)
v..
io_schedule (24,003 us, 0.01%)
mysql_unlock_tables(THD*, st_mysql_lock*) (23,722 us, 0.01%)
entry_SYSCALL_64_fastpath (8,670,702 us, 4.10%)
entr..
vfs_read (201,887 us, 0.10%)
__schedule (21,141 us, 0.01%)
JOIN::optimize_distinct_group_order() (29,976 us, 0.01%)
vfs_read (546,461 us, 0.26%)
futex_wait (18,986 us, 0.01%)
schedule (546,461 us, 0.26%)
schedule (71,445 us, 0.03%)
[unknown] (361,071 us, 0.17%)
schedule (43,721 us, 0.02%)
schedule (5,000,109 us, 2.37%)
s..
vfs_read (19,201 us, 0.01%)
finish_task_switch (5,000,128 us, 2.37%)
f..
- (36,140 us, 0.02%)
Item_func_between::val_int() (59,626 us, 0.03%)
schedule (337,410 us, 0.16%)
io_schedule (95,027 us, 0.04%)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (60,563,588 us, 28.66%)
row_search_mvcc(unsigned char*, page_cur_mode..
__memcpy_sse2_unaligned (4,641,204 us, 2.20%)
_..
__vfs_read (26,593 us, 0.01%)
finish_task_switch (350,051 us, 0.17%)
finish_task_switch (4,260,508 us, 2.02%)
f..
- (19,684 us, 0.01%)
return_from_SYSCALL_64 (10,357,105 us, 4.90%)
return..
__schedule (23,467 us, 0.01%)
Field_string::unpack(unsigned char*, unsigned char const*, unsigned int, bool) (20,706 us, 0.01%)
generic_file_read_iter (49,796 us, 0.02%)
generic_file_read_iter (19,214 us, 0.01%)
sys_futex (23,543 us, 0.01%)
schedule (243,813 us, 0.12%)
finish_task_switch (19,229 us, 0.01%)
io_schedule (19,184 us, 0.01%)
__vfs_read (1,294,433 us, 0.61%)
exit_to_usermode_loop (106,087 us, 0.05%)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (13,423,247 us, 6.35%)
row_sear..
io_schedule (24,719 us, 0.01%)
finish_task_switch (29,951 us, 0.01%)
__vfs_read (46,453 us, 0.02%)
io_schedule (337,410 us, 0.16%)
__schedule (18,794 us, 0.01%)
- (31,456 us, 0.01%)
QEP_tmp_table::end_send() (323,308 us, 0.15%)
ha_commit_trans(THD*, bool, bool) (6,347,173 us, 3.00%)
ha_..
__schedule (355,460 us, 0.17%)
__GI___libc_pread (29,536 us, 0.01%)
__schedule (47,811 us, 0.02%)
__vfs_read (23,779 us, 0.01%)
vfs_read (19,214 us, 0.01%)
io_schedule (18,884 us, 0.01%)
generic_file_read_iter (4,260,516 us, 2.02%)
g..
pfs_end_statement_v1 (460,824 us, 0.22%)
generic_file_read_iter (44,300 us, 0.02%)
io_schedule (3,895,289 us, 1.84%)
i..
generic_file_read_iter (432,254 us, 0.20%)
sys_futex (35,195 us, 0.02%)
schedule (1,294,433 us, 0.61%)
generic_file_read_iter (428,850 us, 0.20%)
schedule (24,063 us, 0.01%)
vfs_read (18,884 us, 0.01%)
futex_wait_queue_me (6,000,699 us, 2.84%)
fu..
__schedule (165,573 us, 0.08%)
thr_multi_lock (23,176 us, 0.01%)
vfs_read (20,265 us, 0.01%)
prepare_exit_to_usermode (20,056 us, 0.01%)
- (18,353 us, 0.01%)
entry_SYSCALL_64_fastpath (201,887 us, 0.10%)
finish_task_switch (1,294,433 us, 0.61%)
entry_SYSCALL_64_fastpath (20,514 us, 0.01%)
buf_LRU_make_block_young(buf_page_t*) (21,984 us, 0.01%)
SyS_pread64 (320,916 us, 0.15%)
entry_SYSCALL_64_fastpath (49,796 us, 0.02%)
__vfs_read (19,217 us, 0.01%)
[unknown] (29,193 us, 0.01%)
SyS_pread64 (19,146 us, 0.01%)
ha_innobase::build_template(bool) (50,807 us, 0.02%)
schedule (48,283,622 us, 22.85%)
schedule
schedule (4,260,508 us, 2.02%)
s..
__vfs_read (19,307 us, 0.01%)
io_schedule (350,051 us, 0.17%)
__schedule (294,788 us, 0.14%)
- (106,087 us, 0.05%)
__vfs_read (266,622 us, 0.13%)
finish_task_switch (30,784 us, 0.01%)
finish_task_switch (546,461 us, 0.26%)
finish_task_switch (27,913 us, 0.01%)
schedule (348,943 us, 0.17%)
vfs_read (27,511 us, 0.01%)
- (37,619 us, 0.02%)
finish_task_switch (26,593 us, 0.01%)
entry_SYSCALL_64_fastpath (24,003 us, 0.01%)
- (33,072 us, 0.02%)
__vfs_read (257,718 us, 0.12%)
generic_file_read_iter (139,764 us, 0.07%)
schedule (29,301 us, 0.01%)
vfs_read (19,291 us, 0.01%)
__vfs_read (8,669,519 us, 4.10%)
__vf..
io_schedule (41,783 us, 0.02%)
vfs_read (1,460,795 us, 0.69%)
entry_SYSCALL_64_fastpath (5,000,109 us, 2.37%)
e..
finish_task_switch (96,083 us, 0.05%)
schedule (96,083 us, 0.05%)
SyS_pread64 (31,669 us, 0.01%)
do_futex (21,601 us, 0.01%)
- (5,002,684 us, 2.37%)
-
__schedule (49,796 us, 0.02%)
- (19,571 us, 0.01%)
io_schedule (24,837 us, 0.01%)
SyS_pread64 (19,201 us, 0.01%)
JOIN::estimate_rowcount() (71,135,224 us, 33.66%)
JOIN::estimate_rowcount()
sub_select(JOIN*, QEP_TAB*, bool) (26,710,657 us, 12.64%)
sub_select(JOIN*, Q..
do_syscall_64 (337,571 us, 0.16%)
sys_sched_yield (18,988 us, 0.01%)
__vfs_read (82,086 us, 0.04%)
__schedule (31,669 us, 0.01%)
io_schedule (31,669 us, 0.01%)
futex_wait_queue_me (6,001,196 us, 2.84%)
fu..
[unknown] (70,102,192 us, 33.17%)
[unknown]
finish_task_switch (22,815 us, 0.01%)
entry_SYSCALL_64_fastpath (1,460,795 us, 0.69%)
__schedule (34,743 us, 0.02%)
[unknown] (45,343 us, 0.02%)
io_schedule (204,165 us, 0.10%)
[unknown] (110,374 us, 0.05%)
- (20,636 us, 0.01%)
entry_SYSCALL_64_fastpath (741,512 us, 0.35%)
SyS_pread64 (41,783 us, 0.02%)
SyS_pread64 (37,265 us, 0.02%)
- (6,020,592 us, 2.85%)
-
swapgs_restore_regs_and_return_to_usermode (27,913 us, 0.01%)
- (18,839 us, 0.01%)
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) (27,686 us, 0.01%)
SyS_pread64 (174,497 us, 0.08%)
- (45,343 us, 0.02%)
__schedule (23,166 us, 0.01%)
schedule (24,837 us, 0.01%)
THD::Query_plan::set_query_plan(enum_sql_command, LEX*, bool) (547,611 us, 0.26%)
generic_file_read_iter (4,166,421 us, 1.97%)
g..
SyS_pread64 (250,514 us, 0.12%)
io_schedule (432,250 us, 0.20%)
futex_wait (35,195 us, 0.02%)
Item::compile(bool (Item::*)(unsigned char**), unsigned char**, Item* (Item::*)(unsigned char*), unsigned char*) (3,895,961 us, 1.84%)
I..
__schedule (21,601 us, 0.01%)
generic_file_read_iter (19,184 us, 0.01%)
generic_file_read_iter (53,650 us, 0.03%)
finish_task_switch (29,397 us, 0.01%)
__GI___libc_pread (48,876,467 us, 23.13%)
__GI___libc_pread
[unknown] (326,481 us, 0.15%)
__schedule (5,000,128 us, 2.37%)
_..
pfs_end_table_lock_wait_v1 (255,299 us, 0.12%)
finish_task_switch (8,669,511 us, 4.10%)
fini..
entry_SYSCALL_64_fastpath (5,000,128 us, 2.37%)
e..
[unknown] (58,859 us, 0.03%)
insert_events_statements_history(PFS_thread*, PFS_events_statements*) (106,087 us, 0.05%)
finish_task_switch (19,146 us, 0.01%)
__schedule (37,585 us, 0.02%)
sys_sched_yield (165,573 us, 0.08%)
futex_wait_queue_me (35,195 us, 0.02%)
Item_field::val_int() (26,579 us, 0.01%)
vfs_read (19,184 us, 0.01%)
finish_task_switch (24,719 us, 0.01%)
futex_wait_queue_me (23,543 us, 0.01%)
__schedule (1,496,333 us, 0.71%)
io_schedule (46,453 us, 0.02%)
__schedule (4,166,421 us, 1.97%)
_..
optimize_cond(THD*, Item**, COND_EQUAL**, List<TABLE_LIST>*, Item::cond_result*) (3,939,971 us, 1.86%)
o..
__vfs_read (276,243 us, 0.13%)
futex_wait_queue_me (6,000,644 us, 2.84%)
fu..
io_schedule (31,124 us, 0.01%)
__schedule (18,197 us, 0.01%)
[unknown] (23,933 us, 0.01%)
build_equal_items(THD*, Item*, Item**, COND_EQUAL*, bool, List<TABLE_LIST>*, COND_EQUAL**) (3,930,668 us, 1.86%)
b..
io_schedule (250,514 us, 0.12%)
generic_file_read_iter (19,201 us, 0.01%)
generic_file_read_iter (20,265 us, 0.01%)
handler::multi_range_read_next(char**) (14,008,009 us, 6.63%)
handler::..
[unknown] (321,862 us, 0.15%)
__vfs_read (4,633,409 us, 2.19%)
_..
schedule (18,988 us, 0.01%)
- (5,007,209 us, 2.37%)
-
generic_file_read_iter (19,291 us, 0.01%)
mysql_execute_command(THD*, bool) (195,978,914 us, 92.74%)
mysql_execute_command(THD*, bool)
buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) (30,837 us, 0.01%)
schedule (20,514 us, 0.01%)
__schedule (24,837 us, 0.01%)
THD::inc_sent_row_count(unsigned long long) (1,296,215 us, 0.61%)
entry_SYSCALL_64_fastpath (18,884 us, 0.01%)
MDL_context::acquire_lock(MDL_request*, unsigned long) (45,792 us, 0.02%)
Arg_comparator::compare_int_unsigned_signed() (19,571 us, 0.01%)
SyS_pread64 (350,051 us, 0.17%)
Item_func::fix_func_arg(THD*, Item**) (49,836 us, 0.02%)
schedule (165,573 us, 0.08%)
select_precheck(THD*, LEX*, TABLE_LIST*, TABLE_LIST*) (5,019,344 us, 2.38%)
s..
schedule (120,570 us, 0.06%)
SyS_pread64 (1,460,795 us, 0.69%)
__memcmp_sse4_1 (20,459 us, 0.01%)
- (41,332 us, 0.02%)
buf_LRU_scan_and_free_block(buf_pool_t*, bool) (88,694 us, 0.04%)
finish_task_switch (35,195 us, 0.02%)
schedule (31,669 us, 0.01%)
__vfs_read (4,260,516 us, 2.02%)
_..
SyS_pread64 (24,063 us, 0.01%)
sys_futex (6,001,196 us, 2.84%)
sy..
__vfs_read (27,511 us, 0.01%)
futex_wait (6,001,196 us, 2.84%)
fu..
long long compare_between_int_result<unsigned long long>(bool, bool, bool, Item**, char*) (22,500 us, 0.01%)
ha_innobase::estimate_rows_upper_bound() (29,178 us, 0.01%)
schedule (355,460 us, 0.17%)
io_schedule (20,265 us, 0.01%)
net_before_header_psi(st_net*, void*, unsigned long) (184,112 us, 0.09%)
__schedule (4,241,232 us, 2.01%)
_..
THD::send_statement_status() (24,188 us, 0.01%)
finish_task_switch (19,177 us, 0.01%)
prepare_exit_to_usermode (22,126 us, 0.01%)
sched_yield (282,182 us, 0.13%)
__vfs_read (24,063 us, 0.01%)
Prepared_statement::insert_params(unsigned char*, unsigned char*, unsigned char*, String*) (754,292 us, 0.36%)
generic_file_read_iter (24,003 us, 0.01%)
schedule (34,743 us, 0.02%)
entry_SYSCALL_64_fastpath (3,895,299 us, 1.84%)
e..
SyS_pread64 (34,743 us, 0.02%)
exit_to_usermode_loop (43,301 us, 0.02%)
- (19,071 us, 0.01%)
SyS_pread64 (26,593 us, 0.01%)
generic_file_read_iter (23,779 us, 0.01%)
Item_field::fix_fields(THD*, Item**) (40,861 us, 0.02%)
io_schedule (34,743 us, 0.02%)
finish_task_switch (29,301 us, 0.01%)
vio_read (1,763,112 us, 0.83%)
entry_SYSCALL_64_fastpath (4,241,232 us, 2.01%)
e..
vfs_read (250,514 us, 0.12%)
vfs_read (24,071 us, 0.01%)
- (8,703,520 us, 4.12%)
-
vfs_read (29,301 us, 0.01%)
- (54,154 us, 0.03%)
entry_SYSCALL_64_fastpath (139,774 us, 0.07%)
do_syscall_64 (27,268 us, 0.01%)
vfs_read (320,916 us, 0.15%)
join_read_const_table(JOIN_TAB*, st_position*) (69,685,875 us, 32.98%)
join_read_const_table(JOIN_TAB*, st_position*)
SyS_pread64 (740,484 us, 0.35%)
entry_SYSCALL_64_fastpath (24,321 us, 0.01%)
io_schedule (23,467 us, 0.01%)
__vfs_read (44,300 us, 0.02%)
__schedule (23,779 us, 0.01%)
finish_task_switch (6,000,644 us, 2.84%)
fi..
io_schedule (29,397 us, 0.01%)
__schedule (22,067,170 us, 10.44%)
__schedule
schedule (24,071 us, 0.01%)
do_sys_poll (243,813 us, 0.12%)
entry_SYSCALL_64_fastpath (47,979,205 us, 22.71%)
entry_SYSCALL_64_fastpath
[unknown] (350,517 us, 0.17%)
my_strnncollsp_simple (27,055 us, 0.01%)
long long compare_between_int_result<unsigned long long>(bool, bool, bool, Item**, char*) (38,990 us, 0.02%)
schedule (174,497 us, 0.08%)
[unknown] (28,090 us, 0.01%)
- (258,702 us, 0.12%)
generic_file_read_iter (294,788 us, 0.14%)
schedule (294,788 us, 0.14%)
schedule (53,650 us, 0.03%)
schedule (47,960,156 us, 22.70%)
schedule
vfs_read (21,871 us, 0.01%)
generic_file_read_iter (82,171 us, 0.04%)
- (29,798 us, 0.01%)
schedule (18,884 us, 0.01%)
finish_task_switch (37,265 us, 0.02%)
schedule (26,914 us, 0.01%)
vfs_read (44,300 us, 0.02%)
ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (24,436 us, 0.01%)
entry_SYSCALL_64_fastpath (19,245 us, 0.01%)
handler::ha_external_lock(THD*, int) (296,363 us, 0.14%)
do_syscall_64 (1,741,018 us, 0.82%)
buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) (27,686 us, 0.01%)
generic_file_read_iter (82,086 us, 0.04%)
- (754,292 us, 0.36%)
ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) (4,649,817 us, 2.20%)
h..
finish_task_switch (740,484 us, 0.35%)
finish_task_switch (95,027 us, 0.04%)
__schedule (276,243 us, 0.13%)
generic_file_read_iter (740,484 us, 0.35%)
io_schedule (27,511 us, 0.01%)
finish_task_switch (201,887 us, 0.10%)
mysql_lock_tables(THD*, TABLE**, unsigned long, unsigned int) (5,379,716 us, 2.55%)
my..
__schedule (546,461 us, 0.26%)
vfs_read (18,197 us, 0.01%)
SyS_pread64 (47,963,028 us, 22.70%)
SyS_pread64
_cond_resched (46,494 us, 0.02%)
finish_task_switch (47,960,156 us, 22.70%)
finish_task_switch
vfs_read (19,229 us, 0.01%)
heap_write (200,713 us, 0.09%)
sched_yield (180,895 us, 0.09%)
entry_SYSCALL_64_fastpath (4,633,491 us, 2.19%)
e..
JOIN::init_planner_arrays() (59,787 us, 0.03%)
Prepared_statement::execute(String*, bool) (203,040,012 us, 96.09%)
Prepared_statement::execute(String*, bool)
generic_file_read_iter (41,783 us, 0.02%)
MDL_context::acquire_lock(MDL_request*, unsigned long) (24,699 us, 0.01%)
generic_file_read_iter (168,660 us, 0.08%)
return_from_SYSCALL_64 (18,988 us, 0.01%)
dispatch_command(THD*, COM_DATA const*, enum_server_command) (209,250,949 us, 99.02%)
dispatch_command(THD*, COM_DATA const*, enum_server_command)
vfs_read (139,764 us, 0.07%)
__schedule (4,633,409 us, 2.19%)
_..
- (18,794 us, 0.01%)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (20,427 us, 0.01%)
Field_string::make_sort_key(unsigned char*, unsigned long) (6,057,036 us, 2.87%)
Fi..
entry_SYSCALL_64_fastpath (29,301 us, 0.01%)
SyS_pread64 (27,511 us, 0.01%)
__schedule (320,916 us, 0.15%)
vfs_read (4,559,141 us, 2.16%)
v..
entry_SYSCALL_64_fastpath (21,871 us, 0.01%)
SyS_pread64 (24,719 us, 0.01%)
schedule (18,372 us, 0.01%)
futex_wait (5,000,128 us, 2.37%)
f..
ha_innobase::records_in_range(unsigned int, st_key_range*, st_key_range*) (71,020,861 us, 33.61%)
ha_innobase::records_in_range(unsigned int, st_key_ran..
__vfs_read (24,837 us, 0.01%)
ibuf_merge_or_delete_for_page(buf_block_t*, page_id_t const&, page_size_t const*, unsigned long) (350,517 us, 0.17%)
finish_task_switch (4,166,421 us, 1.97%)
f..
__schedule (24,003 us, 0.01%)
JOIN::extract_func_dependent_tables() (69,722,708 us, 33.00%)
JOIN::extract_func_dependent_tables()
futex_wait (23,543 us, 0.01%)
io_schedule (23,166 us, 0.01%)
finish_task_switch (428,850 us, 0.20%)
entry_SYSCALL_64_fastpath (18,197 us, 0.01%)
- (24,608 us, 0.01%)
- (361,071 us, 0.17%)
finish_task_switch (294,788 us, 0.14%)
- (26,579 us, 0.01%)
finish_task_switch (106,087 us, 0.05%)
create_tmp_table(THD*, Temp_table_param*, List<Item>&, st_order*, bool, bool, unsigned long long, unsigned long long, char const*) (22,354 us, 0.01%)
io_schedule (19,214 us, 0.01%)
__schedule (24,063 us, 0.01%)
__vfs_read (41,783 us, 0.02%)
- (46,682 us, 0.02%)
entry_SYSCALL_64_fastpath (32,702 us, 0.02%)
vfs_read (53,650 us, 0.03%)
__schedule (18,959 us, 0.01%)
rw_lock_s_lock_spin(rw_lock_t*, unsigned long, char const*, unsigned long) (153,732 us, 0.07%)
- (50,807 us, 0.02%)
- (22,506 us, 0.01%)
sched_yield (19,071 us, 0.01%)
entry_SYSCALL_64_fastpath (174,497 us, 0.08%)
__schedule (25,416 us, 0.01%)
[unknown] (269,756 us, 0.13%)
entry_SYSCALL_64_fastpath (19,340 us, 0.01%)
entry_SYSCALL_64_fastpath (257,718 us, 0.12%)
__schedule (19,229 us, 0.01%)
_cond_resched (168,900 us, 0.08%)
return_from_SYSCALL_64 (48,505,669 us, 22.95%)
return_from_SYSCALL_64
do_futex (6,000,644 us, 2.84%)
do..
vfs_read (8,669,519 us, 4.10%)
vfs_..
entry_SYSCALL_64_fastpath (27,373 us, 0.01%)
[unknown] (48,876,467 us, 23.13%)
[unknown]
vfs_read (174,497 us, 0.08%)
generic_file_read_iter (23,467 us, 0.01%)
SyS_pread64 (201,887 us, 0.10%)
QUICK_RANGE_SELECT::get_next() (4,682,792 us, 2.22%)
Q..
__schedule (19,217 us, 0.01%)
[unknown] (23,722 us, 0.01%)
__vfs_read (201,887 us, 0.10%)
io_schedule (47,811 us, 0.02%)
sys_sched_yield (1,496,333 us, 0.71%)
entry_SYSCALL_64_fastpath (19,229 us, 0.01%)
do_syscall_64 (185,765 us, 0.09%)
finish_task_switch (19,223 us, 0.01%)
pthread_cond_wait@@GLIBC_2.3.2 (43,773 us, 0.02%)
vfs_read (1,294,433 us, 0.61%)
finish_task_switch (18,884 us, 0.01%)
__lll_lock_wait (23,777 us, 0.01%)
schedule (26,593 us, 0.01%)
[unknown] (91,932 us, 0.04%)
- (4,641,204 us, 2.20%)
-
[unknown] (179,785,414 us, 85.08%)
[unknown]
[unknown] (40,462 us, 0.02%)
schedule (25,416 us, 0.01%)
__GI___libc_pread (27,686 us, 0.01%)
__schedule (428,850 us, 0.20%)
[unknown] (49,906,018 us, 23.62%)
[unknown]
THD::send_result_metadata(List<Item>*, unsigned int) (55,082 us, 0.03%)
syscall_return_slowpath (21,141 us, 0.01%)
__vfs_read (19,223 us, 0.01%)
do_syscall_64 (18,988 us, 0.01%)
trx_commit(trx_t*) (31,456 us, 0.01%)
io_schedule (27,373 us, 0.01%)
SyS_pread64 (3,895,299 us, 1.84%)
S..
__GI___libc_pread (20,417 us, 0.01%)
__GI___libc_pread (83,215 us, 0.04%)
schedule (257,688 us, 0.12%)
- (29,178 us, 0.01%)
__schedule (19,160 us, 0.01%)
io_schedule (82,171 us, 0.04%)
entry_SYSCALL_64_fastpath (18,372 us, 0.01%)
swapgs_restore_regs_and_return_to_usermode (18,959 us, 0.01%)
finish_task_switch (3,895,289 us, 1.84%)
f..
schedule (44,300 us, 0.02%)
generic_file_read_iter (201,887 us, 0.10%)
generic_file_read_iter (19,146 us, 0.01%)
exit_to_usermode_loop (18,959 us, 0.01%)
finish_task_switch (1,460,795 us, 0.69%)
Protocol_classic::get_command(COM_DATA*, enum_server_command*) (1,967,477 us, 0.93%)
io_schedule (82,086 us, 0.04%)
entry_SYSCALL_64_fastpath (19,217 us, 0.01%)
__schedule (250,514 us, 0.12%)
- (24,674 us, 0.01%)
finish_task_switch (4,633,409 us, 2.19%)
f..
finish_task_switch (348,943 us, 0.17%)
schedule (19,160 us, 0.01%)
__schedule (46,494 us, 0.02%)
finish_task_switch (29,743 us, 0.01%)
- (143,858 us, 0.07%)
- (4,645,399 us, 2.20%)
-
vfs_read (294,788 us, 0.14%)
__schedule (120,570 us, 0.06%)
Field::key_cmp(unsigned char const*, unsigned int) (19,048 us, 0.01%)
long long compare_between_int_result<unsigned long long>(bool, bool, bool, Item**, char*) (54,154 us, 0.03%)
do_syscall_64 (48,505,669 us, 22.95%)
do_syscall_64
swapgs_restore_regs_and_return_to_usermode (20,056 us, 0.01%)
vfs_read (26,593 us, 0.01%)
io_schedule (19,223 us, 0.01%)
prepare_exit_to_usermode (25,416 us, 0.01%)
sys_sched_yield (10,357,105 us, 4.90%)
sys_sc..
__vfs_read (18,197 us, 0.01%)
pfs_unlock_mutex_v1 (4,241,932 us, 2.01%)
p..
entry_SYSCALL_64_fastpath (34,743 us, 0.02%)
swapgs_restore_regs_and_return_to_usermode (96,083 us, 0.05%)
__vfs_read (3,895,299 us, 1.84%)
_..
innobase_commit_low(trx_t*) (326,481 us, 0.15%)
SyS_pread64 (37,585 us, 0.02%)
schedule (24,719 us, 0.01%)
[unknown] (30,481 us, 0.01%)
schedule (82,086 us, 0.04%)
- (23,933 us, 0.01%)
entry_SYSCALL_64_fastpath (28,352 us, 0.01%)
__schedule (348,943 us, 0.17%)
__schedule (77,767 us, 0.04%)
[unknown] (22,383 us, 0.01%)
generic_file_read_iter (34,743 us, 0.02%)
generic_file_read_iter (24,719 us, 0.01%)
entry_SYSCALL_64_fastpath (20,265 us, 0.01%)
schedule (250,514 us, 0.12%)
schedule (19,229 us, 0.01%)
entry_SYSCALL_64_fastpath (4,115,948 us, 1.95%)
e..
__schedule (26,914 us, 0.01%)
buf_page_io_complete(buf_page_t*, bool) (352,460 us, 0.17%)
vfs_read (29,743 us, 0.01%)
- (19,544 us, 0.01%)
finish_task_switch (139,764 us, 0.07%)
__libc_poll (1,763,112 us, 0.83%)
- (4,262,336 us, 2.02%)
-
SyS_pread64 (27,245 us, 0.01%)
finish_task_switch (31,124 us, 0.01%)
finish_task_switch (23,467 us, 0.01%)
SyS_pread64 (19,177 us, 0.01%)
page_rec_get_n_recs_before(unsigned char const*) (20,664 us, 0.01%)
finish_task_switch (4,112,367 us, 1.95%)
f..
my_strnncollsp_simple (101,775 us, 0.05%)
buf_page_optimistic_get(unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*) (45,343 us, 0.02%)
vfs_read (82,086 us, 0.04%)
finish_task_switch (82,086 us, 0.04%)
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long) (48,876,467 us, 23.13%)
os_file_read_func(IORequest&, int, v..
vfs_read (23,467 us, 0.01%)
generic_file_read_iter (3,895,299 us, 1.84%)
g..
SyS_pread64 (19,208 us, 0.01%)
schedule (320,916 us, 0.15%)
rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) (18,794 us, 0.01%)
io_schedule (257,688 us, 0.12%)
generic_file_read_iter (46,453 us, 0.02%)
Item_func_between::fix_fields(THD*, Item**) (58,370 us, 0.03%)
Optimize_table_order::choose_table_order() (23,683 us, 0.01%)
generic_file_read_iter (24,063 us, 0.01%)
cleanup_items(Item*) (20,471 us, 0.01%)
vfs_read (34,743 us, 0.02%)
entry_SYSCALL_64_fastpath (276,243 us, 0.13%)
io_schedule (19,146 us, 0.01%)
SyS_pread64 (44,300 us, 0.02%)
schedule (4,633,409 us, 2.19%)
s..
generic_file_read_iter (546,461 us, 0.26%)
JOIN::exec() (27,147,051 us, 12.85%)
JOIN::exec()
__schedule (96,083 us, 0.05%)
- (22,337 us, 0.01%)
do_syscall_64 (22,119,171 us, 10.47%)
do_syscall_64
Item_func::fix_fields(THD*, Item**) (57,545 us, 0.03%)
schedule (276,243 us, 0.13%)
SyS_pread64 (168,660 us, 0.08%)
__vfs_read (23,467 us, 0.01%)
finish_task_switch (22,126 us, 0.01%)
schedule (37,585 us, 0.02%)
__schedule (257,688 us, 0.12%)
__vfs_read (31,669 us, 0.01%)
thd_to_trx(THD*) (23,933 us, 0.01%)
__vfs_read (19,214 us, 0.01%)
Prepared_statement::set_parameters(String*, unsigned char*, unsigned char*) (806,524 us, 0.38%)
buf_page_init_for_read(dberr_t*, unsigned long, page_id_t const&, page_size_t const&, unsigned long) (133,965 us, 0.06%)
finish_task_switch (18,988 us, 0.01%)
sys_futex (5,000,109 us, 2.37%)
s..
finish_task_switch (82,171 us, 0.04%)
entry_SYSCALL_64_fastpath (22,815 us, 0.01%)
- (29,536 us, 0.01%)
generic_file_read_iter (204,165 us, 0.10%)
schedule (22,815 us, 0.01%)
__schedule (6,000,699 us, 2.84%)
__..
SyS_pread64 (82,086 us, 0.04%)
finish_task_switch (21,871 us, 0.01%)
- (21,984 us, 0.01%)
generic_file_read_iter (320,916 us, 0.15%)
__schedule (185,765 us, 0.09%)
vfs_read (4,166,421 us, 1.97%)
v..
Item_func_between::val_int() (28,479 us, 0.01%)
generic_file_read_iter (29,743 us, 0.01%)
[unknown] (23,933 us, 0.01%)
SyS_pread64 (266,622 us, 0.13%)
exit_to_usermode_loop (96,083 us, 0.05%)
buf_page_is_corrupted(bool, unsigned char const*, page_size_t const&, bool) (23,310 us, 0.01%)
create_ref_for_key(JOIN*, JOIN_TAB*, Key_use*, unsigned long long) (23,989 us, 0.01%)
finish_task_switch (77,767 us, 0.04%)
vfs_read (37,585 us, 0.02%)
exit_to_usermode_loop (27,913 us, 0.01%)
vfs_read (428,850 us, 0.20%)
join_init_read_record(QEP_TAB*) (10,906,400 us, 5.16%)
join_i..
generic_file_read_iter (47,998 us, 0.02%)
__vfs_read (29,397 us, 0.01%)
vfs_read (24,063 us, 0.01%)
vfs_read (23,779 us, 0.01%)
generic_file_read_iter (4,241,232 us, 2.01%)
g..
finish_task_switch (25,416 us, 0.01%)
io_schedule (266,622 us, 0.13%)
futex_wait (20,514 us, 0.01%)
btr_search_info_update_slow(btr_search_t*, btr_cur_t*) (29,585 us, 0.01%)
__vfs_read (37,585 us, 0.02%)
__schedule (204,165 us, 0.10%)
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long) (27,686 us, 0.01%)
entry_SYSCALL_64_fastpath (33,129 us, 0.02%)
JOIN::make_join_plan() (140,996,771 us, 66.72%)
JOIN::make_join_plan()
entry_SYSCALL_64_fastpath (44,401 us, 0.02%)
vfs_read (48,462,263 us, 22.93%)
vfs_read
prepare_exit_to_usermode (106,087 us, 0.05%)
__GI___pthread_mutex_lock (27,844 us, 0.01%)
__schedule (37,265 us, 0.02%)
__vfs_read (432,254 us, 0.20%)
__schedule (10,357,105 us, 4.90%)
__sche..
io_schedule (4,559,131 us, 2.16%)
i..
[unknown] (4,241,932 us, 2.01%)
[..
- (36,810 us, 0.02%)
vfs_read (355,496 us, 0.17%)
entry_SYSCALL_64_fastpath (6,011,800 us, 2.84%)
en..
vfs_read (31,124 us, 0.01%)
JOIN::create_intermediate_table(QEP_TAB*, List<Item>*, JOIN::ORDER_with_src&, bool) (22,573 us, 0.01%)
io_schedule (18,197 us, 0.01%)
- (270,495 us, 0.13%)
io_schedule (19,208 us, 0.01%)
handler::ha_index_read_idx_map(unsigned char*, unsigned int, unsigned char const*, unsigned long, ha_rkey_function) (64,955,804 us, 30.74%)
handler::ha_index_read_idx_map(unsigned char*, un..
- (1,763,112 us, 0.83%)
schedule (19,201 us, 0.01%)
generic_file_read_iter (250,514 us, 0.12%)
my_strnxfrm_simple (6,051,719 us, 2.86%)
my..
__schedule (35,195 us, 0.02%)
__schedule (43,721 us, 0.02%)
__vfs_read (18,372 us, 0.01%)
buf_page_make_young(buf_page_t*) (282,225 us, 0.13%)
sched_yield (185,781 us, 0.09%)
- (46,892 us, 0.02%)
schedule (4,559,131 us, 2.16%)
s..
- (20,839 us, 0.01%)
exit_to_usermode_loop (22,293 us, 0.01%)
io_schedule (23,779 us, 0.01%)
futex_wait_queue_me (43,721 us, 0.02%)
__vfs_read (37,265 us, 0.02%)
- (24,585 us, 0.01%)
- (20,417 us, 0.01%)
__vfs_read (204,165 us, 0.10%)
[unknown] (24,608 us, 0.01%)
- (20,706 us, 0.01%)
poll_schedule_timeout (243,813 us, 0.12%)
__vfs_read (24,071 us, 0.01%)
my_net_read (1,967,477 us, 0.93%)
__schedule (24,071 us, 0.01%)
sys_sched_yield (77,767 us, 0.04%)
do_syscall_64 (77,767 us, 0.04%)
finish_task_switch (24,071 us, 0.01%)
sys_futex (21,601 us, 0.01%)
__schedule (266,622 us, 0.13%)
exit_to_usermode_loop (21,124 us, 0.01%)
vfs_read (82,171 us, 0.04%)
__schedule (22,126 us, 0.01%)
entry_SYSCALL_64_fastpath (19,160 us, 0.01%)
__schedule (30,784 us, 0.01%)
- (26,344 us, 0.01%)
entry_SYSCALL_64_fastpath (30,123 us, 0.01%)
schedule (204,165 us, 0.10%)
finish_task_switch (18,794 us, 0.01%)
return_from_SYSCALL_64 (165,573 us, 0.08%)
SyS_pread64 (26,914 us, 0.01%)
io_schedule (740,484 us, 0.35%)
- (36,976 us, 0.02%)
__schedule (47,960,156 us, 22.70%)
__schedule
entry_SYSCALL_64_fastpath (95,027 us, 0.04%)
lock_tables(THD*, TABLE_LIST*, unsigned int, unsigned int) (5,406,432 us, 2.56%)
lo..
entry_SYSCALL_64_fastpath (320,916 us, 0.15%)
generic_file_read_iter (26,593 us, 0.01%)
io_schedule (4,112,367 us, 1.95%)
i..
__schedule (27,245 us, 0.01%)
SyS_pread64 (49,796 us, 0.02%)
entry_SYSCALL_64_fastpath (26,593 us, 0.01%)
__vfs_read (1,460,795 us, 0.69%)
vfs_read (46,453 us, 0.02%)
generic_file_read_iter (19,208 us, 0.01%)
entry_SYSCALL_64_fastpath (19,214 us, 0.01%)
trans_commit(THD*) (6,347,173 us, 3.00%)
tra..
exit_to_usermode_loop (22,126 us, 0.01%)
start_thread (211,311,889 us, 100.00%)
start_thread
entry_SYSCALL_64_fastpath (22,049 us, 0.01%)
- (83,262 us, 0.04%)
check_column_grant_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, unsigned long) (46,682 us, 0.02%)
- (547,611 us, 0.26%)
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) (70,102,560 us, 33.17%)
fil_io(IORequest const&, bool, page_id_t const&, page..
io_schedule (320,916 us, 0.15%)
io_schedule (276,243 us, 0.13%)
lock_clust_rec_cons_read_sees(unsigned char const*, dict_index_t*, unsigned long const*, ReadView*) (19,544 us, 0.01%)
__schedule (53,650 us, 0.03%)
[unknown] (1,555,197 us, 0.74%)
__schedule (82,171 us, 0.04%)
generic_file_read_iter (29,951 us, 0.01%)
sync_array_wait_event(sync_array_t*, sync_cell_t*&) (153,732 us, 0.07%)
ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int) (13,513,709 us, 6.40%)
ha_innob..
schedule (6,000,699 us, 2.84%)
sc..
__schedule (350,051 us, 0.17%)
__schedule (740,484 us, 0.35%)
SyS_pread64 (23,467 us, 0.01%)
- (4,178,203 us, 1.98%)
-
generic_file_read_iter (18,884 us, 0.01%)
__schedule (31,124 us, 0.01%)
Query_result_send::cleanup() (178,923 us, 0.08%)
Item_equal::update_const(THD*) (4,177,400 us, 1.98%)
I..
do_futex (6,001,196 us, 2.84%)
do..
generic_file_read_iter (355,496 us, 0.17%)
ut_crc32_hw(unsigned char const*, unsigned long) (23,310 us, 0.01%)
- (29,388 us, 0.01%)
vfs_read (32,474 us, 0.02%)
__vfs_read (22,115,060 us, 10.47%)
__vfs_read
SyS_pread64 (18,197 us, 0.01%)
__vfs_read (320,916 us, 0.15%)
entry_SYSCALL_64_fastpath (546,461 us, 0.26%)
finish_task_switch (27,511 us, 0.01%)
__schedule (43,301 us, 0.02%)
__schedule (168,900 us, 0.08%)
SyS_pread64 (4,112,441 us, 1.95%)
S..
finish_task_switch (31,669 us, 0.01%)
find_or_create_digest(PFS_thread*, sql_digest_storage const*, char const*, unsigned int) (285,676 us, 0.14%)
__vfs_read (20,265 us, 0.01%)
Item_equal::compare_const(THD*, Item*) (4,151,554 us, 1.96%)
I..
handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (24,436 us, 0.01%)
buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, bool) (70,842,100 us, 33.52%)
buf_page_get_gen(page_id_t const&, page_size_t const&..
schedule (20,265 us, 0.01%)
lock_clust_rec_cons_read_sees(unsigned char const*, dict_index_t*, unsigned long const*, ReadView*) (19,684 us, 0.01%)
- (280,597 us, 0.13%)
SyS_pread64 (257,718 us, 0.12%)
- (6,051,719 us, 2.86%)
-
- (102,357 us, 0.05%)
finish_task_switch (23,166 us, 0.01%)
__vfs_read (22,815 us, 0.01%)
sched_yield (10,357,237 us, 4.90%)
sched_..
schedule (6,001,196 us, 2.84%)
sc..
lf_hash_search (269,756 us, 0.13%)
entry_SYSCALL_64_fastpath (27,511 us, 0.01%)
btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*) (70,962,717 us, 33.58%)
btr_cur_search_to_nth_level(dict_index_t*, unsigned l..
__vfs_read (47,963,028 us, 22.70%)
__vfs_read
vfs_read (37,265 us, 0.02%)
finish_task_switch (19,208 us, 0.01%)
SyS_pread64 (31,124 us, 0.01%)
__lll_unlock_wake (129,955 us, 0.06%)
generic_file_read_iter (257,718 us, 0.12%)
__schedule (32,474 us, 0.02%)
prepare_exit_to_usermode (71,445 us, 0.03%)
entry_SYSCALL_64_fastpath (46,211 us, 0.02%)
io_schedule (355,460 us, 0.17%)
SyS_pread64 (82,171 us, 0.04%)
__schedule (8,669,511 us, 4.10%)
__sc..
schedule (82,171 us, 0.04%)
schedule (428,850 us, 0.20%)
__vfs_read (350,051 us, 0.17%)
Protocol_classic::send_eof(unsigned int, unsigned int) (21,579 us, 0.01%)
- (55,621 us, 0.03%)
DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*) (71,068,205 us, 33.63%)
DsMrr_impl::dsmrr_info_const(unsigned int, st_range_se..
schedule (18,794 us, 0.01%)
SyS_pread64 (428,850 us, 0.20%)
finish_task_switch (34,743 us, 0.02%)
entry_SYSCALL_64_fastpath (43,748 us, 0.02%)
Item_equal::Item_equal(Item*, Item_field*) (29,798 us, 0.01%)
- (83,215 us, 0.04%)
io_schedule (27,245 us, 0.01%)
vfs_read (22,815 us, 0.01%)
futex_wait_queue_me (18,986 us, 0.01%)
__schedule (18,884 us, 0.01%)
finish_task_switch (257,688 us, 0.12%)
finish_task_switch (243,813 us, 0.12%)
schedule (23,166 us, 0.01%)
__schedule (21,124 us, 0.01%)
__schedule (29,951 us, 0.01%)
__schedule (21,871 us, 0.01%)
__vfs_read (95,027 us, 0.04%)
rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, unsigned long, mem_block_info_t**) (51,407 us, 0.02%)
schedule (27,245 us, 0.01%)
SyS_pread64 (48,462,263 us, 22.93%)
SyS_pread64
schedule (19,184 us, 0.01%)
copy_fields(Temp_table_param*, THD const*) (24,608 us, 0.01%)
__schedule (22,293 us, 0.01%)
generic_file_read_iter (27,245 us, 0.01%)
finish_task_switch (47,811 us, 0.02%)
__vfs_read (19,160 us, 0.01%)
generic_file_read_iter (24,071 us, 0.01%)
finish_task_switch (4,241,232 us, 2.01%)
f..
generic_file_read_iter (18,372 us, 0.01%)
vfs_read (18,372 us, 0.01%)
schedule (10,357,105 us, 4.90%)
schedule
io_schedule (428,850 us, 0.20%)
schedule (46,453 us, 0.02%)
sys_sched_yield (185,765 us, 0.09%)
finish_task_switch (46,453 us, 0.02%)
do_futex (5,000,109 us, 2.37%)
d..
buf_page_make_young(buf_page_t*) (21,984 us, 0.01%)
entry_SYSCALL_64_fastpath (23,543 us, 0.01%)
__vfs_read (19,146 us, 0.01%)
handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) (179,517,356 us, 84.95%)
handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long)
handler::ha_thd() const (36,810 us, 0.02%)
- (178,923 us, 0.08%)
entry_SYSCALL_64_fastpath (23,166 us, 0.01%)
buf_read_page(page_id_t const&, page_size_t const&) (49,498,763 us, 23.42%)
buf_read_page(page_id_t const&, page_..
entry_SYSCALL_64_fastpath (129,693 us, 0.06%)
TC_LOG_DUMMY::commit(THD*, bool) (6,347,173 us, 3.00%)
TC_..
exit_to_usermode_loop (30,784 us, 0.01%)
setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, unsigned long, List<Item>*, bool, bool) (60,983 us, 0.03%)
__schedule (201,887 us, 0.10%)
__schedule (27,511 us, 0.01%)
vfs_read (19,177 us, 0.01%)
entry_SYSCALL_64_fastpath (19,201 us, 0.01%)
- (51,407 us, 0.02%)
finish_task_switch (23,779 us, 0.01%)
buf_read_page(page_id_t const&, page_size_t const&) (70,607,824 us, 33.41%)
buf_read_page(page_id_t const&, page_size_t const&)
futex_wait_queue_me (5,000,109 us, 2.37%)
f..
futex_wait_queue_me (21,601 us, 0.01%)
io_schedule (53,650 us, 0.03%)
__vfs_read (168,660 us, 0.08%)
finish_task_switch (46,494 us, 0.02%)
finish_task_switch (10,357,105 us, 4.90%)
finish..
schedule (20,056 us, 0.01%)
finish_task_switch (19,184 us, 0.01%)
- (27,844 us, 0.01%)
- (295,025 us, 0.14%)
vfs_read (27,245 us, 0.01%)
entry_SYSCALL_64_fastpath (32,474 us, 0.02%)
schedule (47,811 us, 0.02%)
finish_task_switch (19,160 us, 0.01%)
__lll_unlock_wake (83,262 us, 0.04%)
SyS_pread64 (24,837 us, 0.01%)
test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, st_order::enum_order, QEP_shared_owner const*, Item*, Bitmap<64u>*, QUICK_SELECT_I**) (71,134,520 us, 33.66%)
test_quick_select(THD*, Bitmap<64u>, unsigned long lon..
__vfs_read (4,241,232 us, 2.01%)
_..
entry_SYSCALL_64_fastpath (35,195 us, 0.02%)
entry_SYSCALL_64_fastpath (23,779 us, 0.01%)
entry_SYSCALL_64_fastpath (46,453 us, 0.02%)
finish_task_switch (32,474 us, 0.02%)
Item_field::fix_fields(THD*, Item**) (49,836 us, 0.02%)
__vfs_read (428,850 us, 0.20%)
generic_file_read_iter (27,373 us, 0.01%)
SyS_pread64 (19,229 us, 0.01%)
generic_file_read_iter (37,265 us, 0.02%)
entry_SYSCALL_64_fastpath (29,397 us, 0.01%)
generic_file_read_iter (31,669 us, 0.01%)
__vfs_read (19,229 us, 0.01%)
entry_SYSCALL_64_fastpath (4,166,434 us, 1.97%)
e..
entry_SYSCALL_64_fastpath (250,514 us, 0.12%)
[unknown] (1,962,324 us, 0.93%)
swapgs_restore_regs_and_return_to_usermode (30,784 us, 0.01%)
generic_file_read_iter (32,474 us, 0.02%)
sub_select_op(JOIN*, QEP_TAB*, bool) (323,308 us, 0.15%)
- (23,777 us, 0.01%)
buf_LRU_get_free_block(buf_pool_t*) (89,226 us, 0.04%)
mysqld_stmt_execute(THD*, unsigned long, unsigned long, unsigned char*, unsigned long) (208,555,652 us, 98.70%)
mysqld_stmt_execute(THD*, unsigned long, unsigned long, unsigned char*, unsigned long)
- (3,895,961 us, 1.84%)
-
SyS_pread64 (27,373 us, 0.01%)
entry_SYSCALL_64_fastpath (19,223 us, 0.01%)
SyS_pread64 (22,115,060 us, 10.47%)
SyS_pread64
SyS_pread64 (1,294,433 us, 0.61%)
__vfs_read (34,743 us, 0.02%)
__schedule (24,719 us, 0.01%)
entry_SYSCALL_64_fastpath (428,850 us, 0.20%)
finish_task_switch (48,283,622 us, 22.85%)
finish_task_switch
- (203,768 us, 0.10%)
finish_task_switch (71,445 us, 0.03%)
- (24,699 us, 0.01%)
io_schedule (1,460,795 us, 0.69%)
- (23,310 us, 0.01%)
vfs_read (204,165 us, 0.10%)
SyS_pread64 (19,214 us, 0.01%)
generic_file_read_iter (8,669,519 us, 4.10%)
gene..
generic_file_read_iter (23,166 us, 0.01%)
my_hash_search_using_hash_value (19,984 us, 0.01%)
generic_file_read_iter (266,622 us, 0.13%)
finish_task_switch (320,916 us, 0.15%)
- (433,030 us, 0.20%)
__vfs_read (740,484 us, 0.35%)
return_from_SYSCALL_64 (27,268 us, 0.01%)
vfs_read (350,051 us, 0.17%)
SyS_pread64 (546,461 us, 0.26%)
prepare_exit_to_usermode (96,083 us, 0.05%)
__vfs_read (348,943 us, 0.17%)
entry_SYSCALL_64_fastpath (41,810 us, 0.02%)
- (19,729 us, 0.01%)
prepare_exit_to_usermode (18,959 us, 0.01%)
finish_task_switch (1,496,333 us, 0.71%)
entry_SYSCALL_64_fastpath (19,291 us, 0.01%)
schedule (106,087 us, 0.05%)
ha_innobase::store_lock(THD*, st_thr_lock_data**, thr_lock_type) (45,321 us, 0.02%)
futex_wait_queue_me (20,514 us, 0.01%)
generic_file_read_iter (337,452 us, 0.16%)
finish_task_switch (22,293 us, 0.01%)
__schedule (20,265 us, 0.01%)
Aggregator_simple::add() (22,855 us, 0.01%)
finish_task_switch (24,003 us, 0.01%)
entry_SYSCALL_64_fastpath (19,208 us, 0.01%)
__schedule (29,397 us, 0.01%)
schedule (4,166,421 us, 1.97%)
s..
finish_task_switch (22,067,170 us, 10.44%)
finish_task_swi..
__schedule (4,112,367 us, 1.95%)
_..
JOIN::make_tmp_tables_info() (33,500 us, 0.02%)
schedule (139,764 us, 0.07%)
SyS_pread64 (4,633,409 us, 2.19%)
S..
- (49,176 us, 0.02%)
- (27,686 us, 0.01%)
__vfs_read (48,462,263 us, 22.93%)
__vfs_read
- (282,182 us, 0.13%)
swapgs_restore_regs_and_return_to_usermode (21,124 us, 0.01%)
- (1,296,215 us, 0.61%)
pfs_spawn_thread (211,311,889 us, 100.00%)
pfs_spawn_thread
do_syscall_64 (165,573 us, 0.08%)
io_schedule (24,071 us, 0.01%)
entry_SYSCALL_64_fastpath (6,005,565 us, 2.84%)
en..
entry_SYSCALL_64_fastpath (19,177 us, 0.01%)
[unknown] (27,686 us, 0.01%)
SyS_pread64 (19,184 us, 0.01%)
futex_wait (6,000,699 us, 2.84%)
fu..
SyS_pread64 (23,779 us, 0.01%)
Opt_trace_context::start(bool, bool, bool, bool, long, long, unsigned long, unsigned long long) (436,627 us, 0.21%)
st_select_lex::setup_conds(THD*) (100,636 us, 0.05%)
io_schedule (24,063 us, 0.01%)
generic_file_read_iter (26,914 us, 0.01%)
io_schedule (546,461 us, 0.26%)
- (23,989 us, 0.01%)
__schedule (27,373 us, 0.01%)
schedule (19,223 us, 0.01%)
Item::walk(bool (Item::*)(unsigned char*), Item::enum_walk, unsigned char*) (23,989 us, 0.01%)
__vfs_read (4,112,441 us, 1.95%)
_..
SyS_pread64 (19,160 us, 0.01%)
ha_commit_low(THD*, bool, bool) (4,251,137 us, 2.01%)
h..
schedule (18,197 us, 0.01%)
futex_wait (43,721 us, 0.02%)
SyS_pread64 (337,452 us, 0.16%)
- (20,122 us, 0.01%)
__schedule (29,301 us, 0.01%)
- (20,459 us, 0.01%)
QEP_TAB::sort_table() (10,898,252 us, 5.16%)
QEP_TA..
finish_task_switch (250,514 us, 0.12%)
do_syscall_64 (10,357,105 us, 4.90%)
do_sys..
io_schedule (37,265 us, 0.02%)
exit_to_usermode_loop (120,570 us, 0.06%)
finish_task_switch (168,660 us, 0.08%)
vfs_read (47,998 us, 0.02%)
__vfs_read (47,998 us, 0.02%)
return_from_SYSCALL_64 (22,119,171 us, 10.47%)
return_from_SYS..
__vfs_read (546,461 us, 0.26%)
__vfs_read (19,201 us, 0.01%)
do_futex (5,000,128 us, 2.37%)
d..
__schedule (432,250 us, 0.20%)
__schedule (20,056 us, 0.01%)
finish_task_switch (21,124 us, 0.01%)
generic_file_read_iter (19,217 us, 0.01%)
vfs_read (22,115,060 us, 10.47%)
vfs_read
finish_task_switch (18,986 us, 0.01%)
schedule (49,796 us, 0.02%)
- (321,862 us, 0.15%)
- (19,646 us, 0.01%)
- (6,025,648 us, 2.85%)
-