File I/O Time Flame Graph
Reset Zoom
Search
__GI___libc_pread (119,705 us, 0.66%)
start_thread (18,179,074 us, 100.00%)
start_thread
buf_read_page(page_id_t const&, page_size_t const&) (5,022,867 us, 27.63%)
buf_read_page(page_id_t const&, page_size_t ..
handler::ha_index_read_idx_map(unsigned char*, unsigned int, unsigned char const*, unsigned long, ha_rkey_function) (5,200,019 us, 28.60%)
handler::ha_index_read_idx_map(unsigned char*..
__GI___libc_pread (27,082 us, 0.15%)
__GI___libc_pread (8,846 us, 0.05%)
mysqld (18,179,074 us, 100.00%)
mysqld
my_net_read (6,510 us, 0.04%)
__GI___libc_pread (15,655 us, 0.09%)
[unknown] (5,124,620 us, 28.19%)
[unknown]
__GI___libc_pread (35,968 us, 0.20%)
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*) (11,153,193 us, 61.35%)
btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned..
__GI___libc_pread (25,157 us, 0.14%)
__GI___libc_pread (1,971 us, 0.01%)
__GI___libc_pread (4,112 us, 0.02%)
ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (5,156,514 us, 28.37%)
ha_innobase::index_read(unsigned char*, unsig..
JOIN::optimize() (17,040,253 us, 93.74%)
JOIN::optimize()
ha_innobase::records_in_range(unsigned int, st_key_range*, st_key_range*) (11,334,728 us, 62.35%)
ha_innobase::records_in_range(unsigned int, st_key_range*, st_key_range*)
__GI___libc_pread (31,366 us, 0.17%)
__GI___libc_pread (34,513 us, 0.19%)
__GI___libc_pread (54,618 us, 0.30%)
JOIN::make_join_plan() (16,903,036 us, 92.98%)
JOIN::make_join_plan()
mysql_execute_command(THD*, bool) (2,160 us, 0.01%)
__GI___libc_pread (8,648 us, 0.05%)
[unknown] (11,178,604 us, 61.49%)
[unknown]
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) (11,094,201 us, 61.03%)
buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, ..
__GI___libc_pread (4,158 us, 0.02%)
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*) (5,087,387 us, 27.98%)
btr_cur_search_to_nth_level(dict_index_t*, u..
__GI___libc_pread (10,789 us, 0.06%)
__GI___libc_pread (136,082 us, 0.75%)
__GI___libc_pread (86,773 us, 0.48%)
mysql_execute_command(THD*, bool) (17,575,438 us, 96.68%)
mysql_execute_command(THD*, bool)
__GI___libc_pread (24,089 us, 0.13%)
join_read_const_table(JOIN_TAB*, st_position*) (5,353,277 us, 29.45%)
join_read_const_table(JOIN_TAB*, st_position*)
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long) (4,998,697 us, 27.50%)
os_file_read_func(IORequest&, int, void*, u..
__GI___libc_pread (22,916 us, 0.13%)
__GI___libc_pread (11,910 us, 0.07%)
__GI___libc_pread (13,290 us, 0.07%)
dispatch_command(THD*, COM_DATA const*, enum_server_command) (17,944,499 us, 98.71%)
dispatch_command(THD*, COM_DATA const*, enum_server_command)
mysql_lock_tables(THD*, TABLE**, unsigned long, unsigned int) (199,279 us, 1.10%)
Prepared_statement::set_parameters(String*, unsigned char*, unsigned char*) (18,032 us, 0.10%)
handle_connection (18,179,074 us, 100.00%)
handle_connection
[unknown] (6,234 us, 0.03%)
JOIN::extract_func_dependent_tables() (5,355,248 us, 29.46%)
JOIN::extract_func_dependent_tables()
[unknown] (6,457 us, 0.04%)
my_micro_time (10,808 us, 0.06%)
[unknown] (17,543,862 us, 96.51%)
[unknown]
[unknown] (29,426 us, 0.16%)
Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) (17,818,748 us, 98.02%)
Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*)
__GI___libc_pread (25,142 us, 0.14%)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (5,124,620 us, 28.19%)
row_search_mvcc(unsigned char*, page_cur_mod..
[unknown] (3,631 us, 0.02%)
DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*) (11,348,115 us, 62.42%)
DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsig..
__GI___libc_pread (58,992 us, 0.32%)
__GI___libc_pread (36,073 us, 0.20%)
my_micro_time (164,766 us, 0.91%)
__GI___libc_pread (27,403 us, 0.15%)
pfs_end_table_lock_wait_v1 (29,734 us, 0.16%)
handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) (17,512,496 us, 96.33%)
handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long)
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) (5,049,949 us, 27.78%)
buf_page_get_gen(page_id_t const&, page_size..
[unknown] (25,243 us, 0.14%)
do_command(THD*) (18,179,074 us, 100.00%)
do_command(THD*)
[unknown] (212,569 us, 1.17%)
__GI___libc_pread (156,124 us, 0.86%)
__GI___libc_pread (3,587 us, 0.02%)
[unknown] (11,081,197 us, 60.96%)
[unknown]
[unknown] (34,189 us, 0.19%)
__GI___libc_pread (37,216 us, 0.20%)
[unknown] (38,301 us, 0.21%)
__GI___libc_pread (11,081,197 us, 60.96%)
__GI___libc_pread
__GI___libc_pread (56,694 us, 0.31%)
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long) (11,081,197 us, 60.96%)
os_file_read_func(IORequest&, int, void*, unsigned long, unsigned long)
st_select_lex::optimize(THD*) (17,176,920 us, 94.49%)
st_select_lex::optimize(THD*)
__GI___libc_pread (31,763 us, 0.17%)
[unknown] (4,998,590 us, 27.50%)
[unknown]
Query_cache::store_query(THD*, TABLE_LIST*) (36,216 us, 0.20%)
__GI___libc_pread (35,189 us, 0.19%)
__GI___libc_pread (5,203 us, 0.03%)
__GI___libc_pread (94,456 us, 0.52%)
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) (11,081,197 us, 60.96%)
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, ..
fil_io(IORequest const&, bool, page_id_t const&, page_size_t const&, unsigned long, unsigned long, void*, void*) (4,998,778 us, 27.50%)
fil_io(IORequest const&, bool, page_id_t co..
__GI___libc_pread (101,478 us, 0.56%)
Prepared_statement::insert_params(unsigned char*, unsigned char*, unsigned char*, String*) (8,547 us, 0.05%)
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**) (11,348,248 us, 62.42%)
test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, st_order::enum_orde..
__GI___libc_pread (31,576 us, 0.17%)
[unknown] (33,993 us, 0.19%)
__GI___libc_pread (32,609 us, 0.18%)
all (18,179,074 us, 100%)
Prepared_statement::execute(String*, bool) (17,720,386 us, 97.48%)
Prepared_statement::execute(String*, bool)
[unknown] (11,348,157 us, 62.42%)
[unknown]
__GI___libc_pread (37,438 us, 0.21%)
__GI___libc_pread (137,103 us, 0.75%)
mysqld_stmt_execute(THD*, unsigned long, unsigned long, unsigned char*, unsigned long) (17,879,073 us, 98.35%)
mysqld_stmt_execute(THD*, unsigned long, unsigned long, unsigned char*, unsigned long)
gettimeofday (70,310 us, 0.39%)
__GI___libc_pread (8,547 us, 0.05%)
ha_innobase::change_active_index(unsigned int) (10,896 us, 0.06%)
__GI___libc_pread (23,918 us, 0.13%)
__GI___libc_pread (4,998,590 us, 27.50%)
__GI___libc_pread
__GI___libc_pread (9,485 us, 0.05%)
__GI___libc_pread (80,330 us, 0.44%)
__GI___libc_pread (153,258 us, 0.84%)
__GI___libc_pread (6,234 us, 0.03%)
ha_innobase::table_flags() const (4,608 us, 0.03%)
buf_read_page(page_id_t const&, page_size_t const&) (11,085,355 us, 60.98%)
buf_read_page(page_id_t const&, page_size_t const&)
row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) (27,403 us, 0.15%)
[unknown] (14,079 us, 0.08%)
handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*) (11,346,672 us, 62.42%)
handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int..
pfs_spawn_thread (18,179,074 us, 100.00%)
pfs_spawn_thread
st_select_lex::set_join(JOIN*) (35,189 us, 0.19%)
__GI___libc_pread (205,149 us, 1.13%)
__GI___libc_pread (14,079 us, 0.08%)
MDL_context::find_ticket(MDL_request*, enum_mdl_duration*) (32,606 us, 0.18%)
__GI___libc_pread (4,608 us, 0.03%)
JOIN::estimate_rowcount() (11,373,405 us, 62.56%)
JOIN::estimate_rowcount()
__GI___libc_pread (2,099 us, 0.01%)