Off-CPU Time Flame Graph
mysqld`_start (27,295 ms, 5.19%)
mys..
mysqld`hp_delete_key (504 ms, 0.10%)
libc.so.1`__lwp_park (25,000 ms, 4.76%)
lib..
mysqld`fts_optimize_thread (25,000 ms, 4.76%)
mys..
mysqld`os_thread_sleep (29,001 ms, 5.52%)
mys..
mysqld`net_read_raw_loop (34,742 ms, 6.61%)
mysql..
mysqld`os_event_wait_time_low (25,000 ms, 4.76%)
mys..
mysqld`row_sel_field_store_in_mysql_format_func (115 ms, 0.02%)
mysqld`ha_innobase::records_in_range (100 ms, 0.02%)
libc.so.1`__cond_timedwait (29,000 ms, 5.52%)
lib..
mysqld`check_quick_select (101 ms, 0.02%)
mysqld`make_join_statistics (329 ms, 0.06%)
mysqld`my_charpos_mb (301 ms, 0.06%)
mysqld`ha_innobase::general_fetch (296 ms, 0.06%)
libc.so.1`pthread_cond_timedwait (25,000 ms, 4.76%)
lib..
mysqld`heap_write (1,716 ms, 0.33%)
mysqld`dispatch_command (5,390 ms, 1.03%)
libc.so.1`cond_wait_common (25,000 ms, 4.76%)
lib..
mysqld`my_net_read (34,780 ms, 6.62%)
mysql..
mysqld`mysql_select (3,224 ms, 0.61%)
mysqld`net_read_packet (34,780 ms, 6.62%)
mysql..
libsocket.so.1`send (1,562 ms, 0.30%)
mysqld`mysqld_stmt_execute (3,575 ms, 0.68%)
libc.so.1`__pollsys (27,295 ms, 5.19%)
lib..
mysqld`my_ismbchar_utf8 (100 ms, 0.02%)
mysqld`os_event_wait_time_low (25,000 ms, 4.76%)
mys..
mysqld`sub_select (2,459 ms, 0.47%)
mysqld`JOIN::optimize (491 ms, 0.09%)
libc.so.1`cond_wait_queue (25,000 ms, 4.76%)
lib..
mysqld`Item_equal::compare_const (113 ms, 0.02%)
mysqld`io_handler_thread (51,010 ms, 9.71%)
mysqld`i..
libc.so.1`cond_wait_common (25,000 ms, 4.76%)
lib..
libc.so.1`cond_wait_queue (220,981 ms, 42.05%)
libc.so.1`cond_wait_queue
mysqld`SQL_SELECT::test_quick_select (114 ms, 0.02%)
mysqld`handle_one_connection (261,191 ms, 49.70%)
mysqld`handle_one_connection
libc.so.1`__so_recv (106 ms, 0.02%)
mysqld`srv_monitor_thread (25,000 ms, 4.76%)
mys..
mysqld`ib_wqueue_timedwait (25,000 ms, 4.76%)
mys..
mysqld`fil_aio_wait (51,010 ms, 9.71%)
mysqld`f..
mysqld`hp_rec_hashnr (633 ms, 0.12%)
libc.so.1`cond_wait_common (20,000 ms, 3.81%)
li..
mysqld`one_thread_per_connection_end (220,981 ms, 42.05%)
mysqld`one_thread_per_connection_end
mysqld`lock_clust_rec_cons_read_sees (102 ms, 0.02%)
mysqld`dict_stats_thread (20,000 ms, 3.81%)
my..
libc.so.1`pselect (29,001 ms, 5.52%)
lib..
mysqld`my_utf8_uni (182 ms, 0.03%)
mysqld`Prepared_statement::execute_loop (3,572 ms, 0.68%)
libc.so.1`__pollsys (34,616 ms, 6.59%)
libc..
mysqld`my_ismbchar_utf8 (74 ms, 0.01%)
libc.so.1`__cond_timedwait (29,000 ms, 5.52%)
lib..
libc.so.1`__lwp_park (20,000 ms, 3.81%)
li..
mysqld`ha_heap::write_row (1,717 ms, 0.33%)
mysqld`THD::set_query (74 ms, 0.01%)
mysqld`handler::multi_range_read_next (395 ms, 0.08%)
libc.so.1`cond_wait (51,007 ms, 9.71%)
libc.so...
mysqld`row_search_for_mysql (284 ms, 0.05%)
libc.so.1`cond_wait_common (29,000 ms, 5.52%)
lib..
mysqld`handle_select (3,227 ms, 0.61%)
libc.so.1`select (29,001 ms, 5.52%)
lib..
mysqld`net_flush (1,563 ms, 0.30%)
libc.so.1`pthread_cond_timedwait (29,000 ms, 5.52%)
lib..
mysqld`handle_connections_sockets (27,295 ms, 5.19%)
mys..
libc.so.1`cond_timedwait (29,000 ms, 5.52%)
lib..
libc.so.1`__pollsys (29,001 ms, 5.52%)
lib..
all (525,501 ms, 100%)
mysqld`net_send_eof (1,564 ms, 0.30%)
libc.so.1`cond_wait_queue (29,000 ms, 5.52%)
lib..
mysqld`mysql_execute_command (3,479 ms, 0.66%)
libc.so.1`__pollsys (28,998 ms, 5.52%)
lib..
libc.so.1`pthread_cond_wait (220,981 ms, 42.05%)
libc.so.1`pthread_cond_wait
libc.so.1`_thrp_setup (498,205 ms, 94.81%)
libc.so.1`_thrp_setup
mysqld`Prepared_statement::execute (3,555 ms, 0.68%)
libc.so.1`__cond_wait (220,981 ms, 42.05%)
libc.so.1`__cond_wait
mysqld`handler::multi_range_read_info_const (101 ms, 0.02%)
mysqld`row_sel_store_mysql_field_func (133 ms, 0.03%)
mysqld`btr_estimate_n_rows_in_range (94 ms, 0.02%)
libc.so.1`pthread_cond_wait (51,007 ms, 9.71%)
libc.so...
mysqld`get_key_scans_params (101 ms, 0.02%)
mysqld`close_thread_tables (103 ms, 0.02%)
mysqld`srv_error_monitor_thread (29,000 ms, 5.52%)
mys..
libc.so.1`cond_timedwait (25,000 ms, 4.76%)
lib..
mysqld`handler::ha_index_next (350 ms, 0.07%)
mysqld`my_hash_sort_utf8 (78 ms, 0.01%)
mysqld`Item_func::type (110 ms, 0.02%)
mysqld`vio_write (1,563 ms, 0.30%)
libc.so.1`pthread_cond_timedwait (25,000 ms, 4.76%)
lib..
mysqld`my_ismbchar_utf8 (146 ms, 0.03%)
mysqld`rr_quick (400 ms, 0.08%)
mysqld`set_thread_state_v1 (119 ms, 0.02%)
libc.so.1`_lwp_start (498,205 ms, 94.81%)
libc.so.1`_lwp_start
mysqld`my_ismbchar_utf8 (117 ms, 0.02%)
libc.so.1`cond_wait_common (29,000 ms, 5.52%)
lib..
mysqld`my_charpos_mb (460 ms, 0.09%)
libc.so.1`__lwp_park (29,000 ms, 5.52%)
lib..
mysqld`my_utf8_uni (165 ms, 0.03%)
mysqld`srv_master_thread (29,002 ms, 5.52%)
mys..
mysqld`mysqld_main (27,295 ms, 5.19%)
mys..
mysqld`vio_socket_io_wait (34,634 ms, 6.59%)
mysq..
libc.so.1`pthread_cond_timedwait (20,000 ms, 3.81%)
li..
mysqld`QUICK_RANGE_SELECT::get_next (400 ms, 0.08%)
libc.so.1`__cond_timedwait (25,000 ms, 4.76%)
lib..
mysqld`row_sel_store_mysql_rec (136 ms, 0.03%)
mysqld`join_init_read_record (190 ms, 0.04%)
mysqld`my_strnncollsp_utf8 (113 ms, 0.02%)
mysqld`vio_io_wait (34,634 ms, 6.59%)
mysq..
libc.so.1`cond_wait_queue (20,000 ms, 3.81%)
li..
mysqld`DsMrr_impl::dsmrr_info_const (101 ms, 0.02%)
mysqld`my_strnxfrm_unicode (83 ms, 0.02%)
mysqld`my_utf8_uni (73 ms, 0.01%)
mysqld`st_join_table::sort_table (178 ms, 0.03%)
mysqld`hp_rec_hashnr (504 ms, 0.10%)
mysqld`Protocol::end_statement (1,577 ms, 0.30%)
mysqld`Field_string::make_sort_key (101 ms, 0.02%)
mysqld`execute_sqlcom_select (3,296 ms, 0.63%)
libc.so.1`poll (27,295 ms, 5.19%)
lib..
libc.so.1`cond_timedwait (20,000 ms, 3.81%)
li..
libc.so.1`__lwp_park (220,981 ms, 42.05%)
libc.so.1`__lwp_park
mysqld`my_hash_sort_utf8 (102 ms, 0.02%)
mysqld`join_read_const (71 ms, 0.01%)
libc.so.1`__cond_timedwait (25,000 ms, 4.76%)
lib..
mysqld`make_sortkey (110 ms, 0.02%)
libc.so.1`cond_wait_queue (25,000 ms, 4.76%)
lib..
mysqld`pfs_spawn_thread (261,191 ms, 49.70%)
mysqld`pfs_spawn_thread
mysqld`end_write (1,722 ms, 0.33%)
libc.so.1`__so_send (1,560 ms, 0.30%)
mysqld`end_send (84 ms, 0.02%)
mysqld`os_event_wait_time_low (29,000 ms, 5.52%)
mys..
mysqld`os_thread_sleep (28,998 ms, 5.52%)
mys..
mysqld`join_read_const_table (188 ms, 0.04%)
mysqld`my_charpos_mb (320 ms, 0.06%)
mysqld`os_event_wait_time_low (20,000 ms, 3.81%)
my..
mysqld`buf_flush_page_cleaner_thread (29,001 ms, 5.52%)
mys..
mysqld`evaluate_join_record (1,843 ms, 0.35%)
libc.so.1`__cond_wait (51,007 ms, 9.71%)
libc.so...
libsocket.so.1`recv (106 ms, 0.02%)
mysqld`os_event_wait_time_low (29,000 ms, 5.52%)
mys..
libc.so.1`cond_wait (220,981 ms, 42.05%)
libc.so.1`cond_wait
libc.so.1`select (28,998 ms, 5.52%)
lib..
libc.so.1`__lwp_park (25,000 ms, 4.76%)
lib..
libc.so.1`cond_wait_queue (29,000 ms, 5.52%)
lib..
mysqld`my_ismbchar_utf8 (103 ms, 0.02%)
mysqld`do_command (34,780 ms, 6.62%)
mysql..
libc.so.1`cond_wait_queue (51,007 ms, 9.71%)
libc.so...
libc.so.1`poll (34,634 ms, 6.59%)
libc..
mysqld`os_event_wait_low (51,007 ms, 9.71%)
mysqld`o..
mysqld`Item_equal::update_const (114 ms, 0.02%)
mysqld`update_const_equal_items (114 ms, 0.02%)
mysqld`net_write_packet (1,563 ms, 0.30%)
mysqld`lock_wait_timeout_thread (29,000 ms, 5.52%)
mys..
mysqld`vio_read (34,742 ms, 6.61%)
mysql..
libc.so.1`cond_timedwait (29,000 ms, 5.52%)
lib..
mysqld`os_aio_simulated_handle (51,007 ms, 9.71%)
mysqld`o..
mysqld`PROFILING::status_change (92 ms, 0.02%)
mysqld`Arg_comparator::set_cmp_func (111 ms, 0.02%)
libc.so.1`pselect (28,998 ms, 5.52%)
lib..
mysqld`JOIN::exec (2,561 ms, 0.49%)
mysqld`hp_write_key (1,187 ms, 0.23%)
libc.so.1`__lwp_park (51,007 ms, 9.71%)
libc.so...
libc.so.1`cond_timedwait (25,000 ms, 4.76%)
lib..
libc.so.1`pthread_cond_timedwait (29,000 ms, 5.52%)
lib..
mysqld`hp_rec_key_cmp (547 ms, 0.10%)
mysqld`do_handle_one_connection (261,191 ms, 49.70%)
mysqld`do_handle_one_connection
libc.so.1`__cond_timedwait (20,000 ms, 3.81%)
li..
mysqld`filesort (174 ms, 0.03%)
libc.so.1`__lwp_park (29,000 ms, 5.52%)
lib..
mysqld`handler::ha_write_row (1,719 ms, 0.33%)
mysqld`handler::read_range_next (372 ms, 0.07%)