FS I/O Time Flame Graph
nss_dns.so.1`_nss_get_dns_ipnodes_name (0 ms, 0.00%)
libresolv_joy.so.2`__res_vinit (0 ms, 0.00%)
mysqld`make_join_statistics (733 ms, 75.47%)
mysqld`make_join_statistics
libc.so.1`__read (147 ms, 15.13%)
libc.so.1`__read
mysqld`buf_page_get_gen (26 ms, 2.68%)
m..
mysqld (735 ms, 75.67%)
mysqld
mysqld`check_quick_select (255 ms, 26.25%)
mysqld`check_quick_select
libc.so.1`__read (1 ms, 0.10%)
libc.so.1`getdents64 (0 ms, 0.00%)
mysqld`os_file_pread (229 ms, 23.58%)
mysqld`os_file_pread
mysqld`buf_read_page (26 ms, 2.68%)
m..
mysqld`fil_io (229 ms, 23.58%)
mysqld`fil_io
mysqld`buf_page_get_gen (13 ms, 1.34%)
libc.so.1`__pread (465 ms, 47.87%)
libc.so.1`__pread
rsyslogd`doWriteInternal (0 ms, 0.00%)
mysqld`buf_read_page_low (13 ms, 1.34%)
libresolv_joy.so.2`joy_res_ninit (0 ms, 0.00%)
tail`show (1 ms, 0.10%)
libc.so.1`__pwrite (0 ms, 0.00%)
mysqld`handler::multi_range_read_info_const (255 ms, 26.25%)
mysqld`handler::multi_range_read_i..
rsyslogd`qqueueEnqObjDirectBatch (0 ms, 0.00%)
rsyslogd`processAction (0 ms, 0.00%)
rsyslogd`finishBatch (0 ms, 0.00%)
libc.so.1`_filbuf (5 ms, 0.51%)
libc.so.1`__pwrite (0 ms, 0.00%)
mysqld`fil_io (0 ms, 0.00%)
libc.so.1`__read (5 ms, 0.51%)
nscd`nss_psearch (1 ms, 0.10%)
nscd`nsc_lookup (23 ms, 2.37%)
n..
tar`putfile (147 ms, 15.13%)
tar`putfile
mysqld`fil_io (26 ms, 2.68%)
m..
libc.so.1`__pread (229 ms, 23.58%)
libc.so.1`__pread
mysqld`fil_io (0 ms, 0.00%)
mysqld`ha_innobase::index_read (478 ms, 49.21%)
mysqld`ha_innobase::index_read
rsyslogd`msgConsumer (0 ms, 0.00%)
mysqld`os_file_read_func (13 ms, 1.34%)
mysqld`buf_do_flush_list_batch (0 ms, 0.00%)
mysqld`get_key_scans_params (255 ms, 26.25%)
mysqld`get_key_scans_params
0x8265952 (0 ms, 0.00%)
mysqld`buf_dblwr_flush_buffered_writes (0 ms, 0.00%)
rsyslogd`doSubmitToActionQBatch (0 ms, 0.00%)
mysqld`srv_master_thread (0 ms, 0.00%)
mysqld`btr_estimate_n_rows_in_range (255 ms, 26.25%)
mysqld`btr_estimate_n_rows_in_range
nscd`check_db_file (23 ms, 2.37%)
n..
mysqld`mysql_execute_command (733 ms, 75.47%)
mysqld`mysql_execute_command
rsyslogd`doWriteCall (0 ms, 0.00%)
mysqld`fil_io (0 ms, 0.00%)
mysqld`os_file_write_func (0 ms, 0.00%)
libc.so.1`syscall (1 ms, 0.10%)
mysqld`io_handler_thread (0 ms, 0.00%)
mysqld`dispatch_command (733 ms, 75.47%)
mysqld`dispatch_command
mysqld`buf_read_page_low (465 ms, 47.87%)
mysqld`buf_read_page_low
mysqld`JOIN::optimize (733 ms, 75.47%)
mysqld`JOIN::optimize
nscd (82 ms, 8.44%)
nscd
0x836cedf (0 ms, 0.00%)
nscd`lookup (23 ms, 2.37%)
n..
rsyslogd (0 ms, 0.00%)
nss_files.so.1`getbyname (0 ms, 0.00%)
mysqld`mysql_select (733 ms, 75.47%)
mysqld`mysql_select
rsyslogd`submitBatch (0 ms, 0.00%)
mysqld`Prepared_statement::execute_loop (733 ms, 75.47%)
mysqld`Prepared_statement::execute_loop
mysqld`row_search_for_mysql (478 ms, 49.21%)
mysqld`row_search_for_mysql
mysqld`buf_read_page (465 ms, 47.87%)
mysqld`buf_read_page
rsyslogd`strmFlush (0 ms, 0.00%)
rsyslogd`strmSchedWrite (0 ms, 0.00%)
init`getcmd (5 ms, 0.51%)
libc.so.1`__pwrite (0 ms, 0.00%)
mysqld`handler::ha_index_read_idx_map (478 ms, 49.21%)
mysqld`handler::ha_index_read_idx_map
nss_files.so.1`__nss_files_XY_hostbyname (0 ms, 0.00%)
mysqld`os_file_pread (13 ms, 1.34%)
rsyslogd`processBatchDoActions (0 ms, 0.00%)
rsyslogd`doSubmitToActionQNotAllMarkBatch (0 ms, 0.00%)
mysqld`btr_cur_search_to_nth_level (229 ms, 23.58%)
mysqld`btr_cur_search_to_nth_l..
rsyslogd`strmFlushInternal (0 ms, 0.00%)
0x8355ff5 (0 ms, 0.00%)
rsyslogd`llExecFunc (0 ms, 0.00%)
init`_start (5 ms, 0.51%)
mysqld`log_write_up_to (0 ms, 0.00%)
mysqld`fil_aio_wait (0 ms, 0.00%)
mysqld`buf_flush_list (1 ms, 0.10%)
mysqld`os_file_read_func (465 ms, 47.87%)
mysqld`os_file_read_func
libc.so.1`__write (0 ms, 0.00%)
rsyslogd`wtiWorker (0 ms, 0.00%)
rsyslogd`processBatch (0 ms, 0.00%)
libc.so.1`_lwp_start (735 ms, 75.67%)
libc.so.1`_lwp_start
rsyslogd`processBatchMain (0 ms, 0.00%)
rsyslogd`ConsumerReg (0 ms, 0.00%)
mysqld`buf_read_page (229 ms, 23.58%)
mysqld`buf_read_page
nscd`lookup_int (23 ms, 2.37%)
n..
tail (2 ms, 0.21%)
mysqld`Prepared_statement::execute (733 ms, 75.47%)
mysqld`Prepared_statement::execute
mysqld`execute_sqlcom_select (733 ms, 75.47%)
mysqld`execute_sqlcom_select
mysqld`srv_sync_log_buffer_in_background (0 ms, 0.00%)
rsyslogd`strmPhysWrite (0 ms, 0.00%)
libc.so.1`__pread (13 ms, 1.34%)
rsyslogd`endTransaction (0 ms, 0.00%)
0x82a0e64 (0 ms, 0.00%)
mysqld`os_file_pread (465 ms, 47.87%)
mysqld`os_file_pread
mysqld`btr_pcur_move_to_next_page (13 ms, 1.34%)
mysqld`buf_read_page (13 ms, 1.34%)
libc.so.1`fgetc (5 ms, 0.51%)
libc.so.1`_filbuf (1 ms, 0.10%)
mysqld`fil_io (13 ms, 1.34%)
mysqld`ha_innobase::records_in_range (255 ms, 26.25%)
mysqld`ha_innobase::records_in_range
mysqld`os_aio_simulated_handle (0 ms, 0.00%)
mysqld`btr_cur_search_to_nth_level (465 ms, 47.87%)
mysqld`btr_cur_search_to_nth_level
postgres (0 ms, 0.00%)
mysqld`buf_page_get_gen (465 ms, 47.87%)
mysqld`buf_page_get_gen
libc.so.1`__door_return (82 ms, 8.44%)
libc.so.1..
tail`main (2 ms, 0.21%)
tar`_start (147 ms, 15.13%)
tar`_start
mysqld`os_file_write_func (0 ms, 0.00%)
libc.so.1`__read (0 ms, 0.00%)
mysqld`mysqld_stmt_execute (733 ms, 75.47%)
mysqld`mysqld_stmt_execute
libc.so.1`fgets (0 ms, 0.00%)
libc.so.1`_filbuf (0 ms, 0.00%)
nss_files.so.1`_nss_files_read_line (0 ms, 0.00%)
libc.so.1`_lwp_start (0 ms, 0.00%)
libc.so.1`getc (5 ms, 0.51%)
mysqld`os_file_read_func (229 ms, 23.58%)
mysqld`os_file_read_func
mysqld`fil_io (465 ms, 47.87%)
mysqld`fil_io
rsyslogd`processBatchDoRules (0 ms, 0.00%)
mysqld`handler::index_read_idx_map (478 ms, 49.21%)
mysqld`handler::index_read_idx_map
0x80b5713 (0 ms, 0.00%)
mysqld`buf_flush_page_cleaner_thread (1 ms, 0.10%)
libc.so.1`__pread (26 ms, 2.68%)
l..
mysqld`btr_pcur_move_to_next (13 ms, 1.34%)
mysqld`log_group_write_buf (0 ms, 0.00%)
libc.so.1`syscall (23 ms, 2.37%)
l..
mysqld`log_write_up_to (0 ms, 0.00%)
libc.so.1`__pwrite (0 ms, 0.00%)
mysqld`log_group_write_buf (0 ms, 0.00%)
tail`follow (2 ms, 0.21%)
mysqld`buf_flush_page_and_try_neighbors (0 ms, 0.00%)
nss_dns.so.1`_nss_dns_gethost_withttl (0 ms, 0.00%)
rsyslogd`doQueueEnqObjDirectBatch (0 ms, 0.00%)
mysqld`os_file_write_func (0 ms, 0.00%)
tar`putfile (147 ms, 15.13%)
tar`putfile
nscd`switcher (82 ms, 8.44%)
nscd`swit..
mysqld`pfs_spawn_thread (733 ms, 75.47%)
mysqld`pfs_spawn_thread
nscd`nss_search (1 ms, 0.10%)
init`remv (5 ms, 0.51%)
init (5 ms, 0.51%)
mysqld`buf_read_page_low (26 ms, 2.68%)
m..
mysqld`os_file_read_func (26 ms, 2.68%)
m..
0x8264ec6 (0 ms, 0.00%)
all (971 ms, 100%)
tar (147 ms, 15.13%)
tar
libc.so.1`syscall (59 ms, 6.07%)
libc.s..
tail`_start (2 ms, 0.21%)
init`main (5 ms, 0.51%)
nscd`search_dns_withttl (0 ms, 0.00%)
mysqld`buf_page_get_gen (229 ms, 23.58%)
mysqld`buf_page_get_gen
0x8391f3a (0 ms, 0.00%)
rsyslogd`wtpWorker (0 ms, 0.00%)
mysqld`join_read_const (478 ms, 49.21%)
mysqld`join_read_const
libc.so.1`_thrp_setup (0 ms, 0.00%)
mysqld`buf_read_page_low (229 ms, 23.58%)
mysqld`buf_read_page_low
mysqld`SQL_SELECT::test_quick_select (255 ms, 26.25%)
mysqld`SQL_SELECT::test_quick_select
rsyslogd`llExecFunc (0 ms, 0.00%)
mysqld`handle_one_connection (733 ms, 75.47%)
mysqld`handle_one_connection
mysqld`join_read_const_table (478 ms, 49.21%)
mysqld`join_read_const_table
tar`main (147 ms, 15.13%)
tar`main
mysqld`handle_select (733 ms, 75.47%)
mysqld`handle_select
mysqld`DsMrr_impl::dsmrr_info_const (255 ms, 26.25%)
mysqld`DsMrr_impl::dsmrr_info_const
mysqld`log_buffer_sync_in_background (0 ms, 0.00%)
libc.so.1`_thrp_setup (735 ms, 75.67%)
libc.so.1`_thrp_setup
nscd`_nscd_restart_if_cfgfile_changed (59 ms, 6.07%)
nscd`_..
mysqld`buf_flush_page (0 ms, 0.00%)
tar`dorep (147 ms, 15.13%)
tar`dorep
mysqld`os_file_write_func (0 ms, 0.00%)
mysqld`os_file_pread (26 ms, 2.68%)
m..
mysqld`do_handle_one_connection (733 ms, 75.47%)
mysqld`do_handle_one_connection
rsyslogd`processBatch (0 ms, 0.00%)