Skip to content

Instantly share code, notes, and snippets.

@ShahriyarR
Created May 30, 2016 10:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ShahriyarR/c3452f5b25b969daa1779f4d70445871 to your computer and use it in GitHub Desktop.
Save ShahriyarR/c3452f5b25b969daa1779f4d70445871 to your computer and use it in GitHub Desktop.
[root@mysql-57 ~]# pt-pmp --pid=1499
Mon May 30 14:00:33 GST 2016
7 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2448),LinuxAIOHandler::poll(os0file.cc:2594),os_aio_linux_handler(os0file.cc:2650),os_aio_handler(os0file.cc:2650),fil_aio_wait(fil0fil.cc:5803),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6)
3 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),TTASEventMutex::wait(ut0mutex.ic:89),spin_and_try_lock(ib0mutex.h:850),enter(ib0mutex.h:850),PolicyMutex<TTASEventMutex<GenericPolicy>(ib0mutex.h:850),buf_page_io_complete(buf0buf.cc:5815),fil_aio_wait(fil0fil.cc:5837),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6)
3 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_x_lock_func(sync0rw.cc:795),pfs_rw_lock_x_lock_func(sync0rw.ic:711),buf_page_get_gen(buf0buf.cc:4623),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),btr_pcur_restore_position_func(btr0pcur.ic:521),row_upd_clust_step(row0upd.cc:2822),row_upd(row0upd.cc:3001),row_upd_step(row0upd.cc:3147),row_update_for_mysql_using_upd_graph(row0mysql.cc:2518),row_update_for_mysql(row0mysql.cc:2715),ha_innobase::update_row(ha_innodb.cc:8104),handler::ha_update_row(handler.cc:7885),mysql_update(sql_update.cc:879),Sql_cmd_update::try_single_table_update(sql_update.cc:2883),Sql_cmd_update::execute(sql_update.cc:3010),mysql_execute_command(sql_parse.cc:4807),mysql_parse(sql_parse.cc:5519),dispatch_command(sql_parse.cc:1429),do_command(sql_parse.cc:997),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
3 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_s_lock_spin(sync0rw.cc:425),rw_lock_s_lock_func(sync0rw.ic:433),pfs_rw_lock_s_lock_func(sync0rw.ic:433),buf_page_get_gen(sync0rw.ic:433),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),row_search_mvcc(row0sel.cc:5006),ha_innobase::index_read(ha_innodb.cc:8591),handler::ha_index_read_map(handler.cc:2952),handler::read_range_first(handler.cc:7218),handler::multi_range_read_next(handler.cc:6288),QUICK_RANGE_SELECT::get_next(opt_range.cc:11170),rr_quick(records.cc:398),mysql_update(sql_update.cc:802),Sql_cmd_update::try_single_table_update(sql_update.cc:2883),Sql_cmd_update::execute(sql_update.cc:3010),mysql_execute_command(sql_parse.cc:4807),mysql_parse(sql_parse.cc:5519),dispatch_command(sql_parse.cc:1429),do_command(sql_parse.cc:997),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
2 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_s_lock_spin(sync0rw.cc:425),rw_lock_s_lock_func(sync0rw.ic:433),pfs_rw_lock_s_lock_func(sync0rw.ic:433),buf_page_get_gen(sync0rw.ic:433),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),row_search_mvcc(row0sel.cc:5006),ha_innobase::index_read(ha_innodb.cc:8591),handler::index_read_idx_map(handler.cc:7371),handler::ha_index_read_idx_map(handler.cc:3004),read_(handler.cc:3004),join_read_const_table(handler.cc:3004),JOIN::extract_func_dependent_tables(sql_optimizer.cc:5531),JOIN::make_join_plan(sql_optimizer.cc:4995),JOIN::optimize(sql_optimizer.cc:368),st_select_lex::optimize(sql_select.cc:1009),handle_query(sql_select.cc:164),execute_sqlcom_select(sql_parse.cc:5109),mysql_execute_command(sql_parse.cc:2758),mysql_parse(sql_parse.cc:5519),dispatch_command(sql_parse.cc:1429),do_command(sql_parse.cc:997),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
2 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),srv_worker_thread(srv0srv.cc:2506),start_thread(libpthread.so.0),clone(libc.so.6)
1 sigwait(libpthread.so.0),signal_hand(mysqld.cc:2094),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),TTASEventMutex::wait(ut0mutex.ic:89),spin_and_try_lock(ib0mutex.h:850),enter(ib0mutex.h:850),enter(ib0mutex.h:850),buf_flush_start(ib0mutex.h:850),buf_flush_do_batch(ib0mutex.h:850),buf_flush_lists(buf0flu.cc:2128),buf_flush_page_cleaner_coordinator(buf0flu.cc:3344),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_x_lock_wait_func(sync0rw.cc:510),rw_lock_x_lock_low(sync0rw.cc:510),rw_lock_x_lock_func(sync0rw.cc:510),pfs_rw_lock_x_lock_func(sync0rw.ic:705),srv_master_evict_from_table_cache(sync0rw.ic:705),srv_master_do_idle_tasks(srv0srv.cc:2216),srv_master_thread(srv0srv.cc:2216),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_x_lock_func(sync0rw.cc:795),pfs_rw_lock_x_lock_func(sync0rw.ic:711),buf_page_get_gen(buf0buf.cc:4623),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),btr_pcur_restore_position_func(btr0pcur.ic:521),row_purge_reposition_pcur(row0purge.cc:102),row_purge_remove_clust_if_poss_low(row0purge.cc:102),row_purge_remove_clust_if_poss(row0purge.cc:214),row_purge_del_mark(row0purge.cc:214),row_purge_record_func(row0purge.cc:214),row_purge(row0purge.cc:214),row_purge_step(row0purge.cc:214),que_thr_step(que0que.cc:1056),que_run_threads_low(que0que.cc:1056),que_run_threads(que0que.cc:1056),trx_purge(trx0purge.cc:1860),srv_do_purge(srv0srv.cc:2617),srv_purge_coordinator_thread(srv0srv.cc:2617),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_x_lock_func(sync0rw.cc:795),pfs_rw_lock_x_lock_func(sync0rw.ic:711),buf_page_get_gen(buf0buf.cc:4623),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),btr_pcur_restore_position_func(btr0pcur.ic:521),row_purge_reposition_pcur(row0purge.cc:102),row_purge_remove_clust_if_poss_low(row0purge.cc:102),row_purge_remove_clust_if_poss(row0purge.cc:214),row_purge_del_mark(row0purge.cc:214),row_purge_record_func(row0purge.cc:214),row_purge(row0purge.cc:214),row_purge_step(row0purge.cc:214),que_thr_step(que0que.cc:1056),que_run_threads_low(que0que.cc:1056),que_run_threads(que0que.cc:1056),srv_task_execute(srv0srv.cc:2458),srv_worker_thread(srv0srv.cc:2458),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_s_lock_spin(sync0rw.cc:425),rw_lock_s_lock_func(sync0rw.ic:433),pfs_rw_lock_s_lock_func(sync0rw.ic:433),buf_page_get_gen(sync0rw.ic:433),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_with_no_init_func(btr0pcur.ic:521),row_search_mvcc(row0sel.cc:5006),ha_innobase::index_read(ha_innodb.cc:8591),handler::ha_index_read_map(handler.cc:2952),handler::read_range_first(handler.cc:7218),handler::multi_range_read_next(handler.cc:6288),QUICK_RANGE_SELECT::get_next(opt_range.cc:11170),rr_quick(records.cc:398),Sql_cmd_delete::mysql_delete(sql_delete.cc:452),Sql_cmd_delete::execute(sql_delete.cc:1375),mysql_execute_command(sql_parse.cc:4807),mysql_parse(sql_parse.cc:5519),dispatch_command(sql_parse.cc:1429),do_command(sql_parse.cc:997),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),rw_lock_s_lock_spin(sync0rw.cc:425),rw_lock_s_lock_func(sync0rw.ic:433),pfs_rw_lock_s_lock_func(sync0rw.ic:433),buf_page_get_gen(sync0rw.ic:433),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_estimate_n_rows_in_range_low(btr0cur.cc:5699),btr_estimate_n_rows_in_range(btr0cur.cc:5999),ha_innobase::records_in_range(ha_innodb.cc:13252),handler::multi_range_read_info_(ha_innodb.cc:13252),DsMrr_impl::dsmrr_info_(ha_innodb.cc:13252),check_quick_select(opt_range.cc:10029),get_key_scans_params(opt_range.cc:5811),test_quick_select(opt_range.cc:5811),get_quick_record_count(sql_optimizer.cc:5899),JOIN::estimate_rowcount(sql_optimizer.cc:5899),JOIN::make_join_plan(sql_optimizer.cc:5003),JOIN::optimize(sql_optimizer.cc:368),st_select_lex::optimize(sql_select.cc:1009),handle_query(sql_select.cc:164),execute_sqlcom_select(sql_parse.cc:5109),mysql_execute_command(sql_parse.cc:2758),mysql_parse(sql_parse.cc:5519),dispatch_command(sql_parse.cc:1429),do_command(sql_parse.cc:997),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),os_event_wait_low(os0event.cc:534),buf_dump_thread(buf0dump.cc:772),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_wait,native_cond_wait(thr_cond.h:140),my_cond_wait(thr_cond.h:140),inline_mysql_cond_wait(thr_cond.h:140),compress_gtid_table(thr_cond.h:140),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_monitor_thread(srv0srv.cc:1571),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_error_monitor_thread(srv0srv.cc:1737),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3029),start_thread(libpthread.so.0),clone(libc.so.6)
1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),dict_stats_thread(dict0stats_bg.cc:421),start_thread(libpthread.so.0),clone(libc.so.6)
1 poll(libc.so.6),poll(poll2.h:46),vio_io_wait(poll2.h:46),vio_socket_io_wait(viosocket.c:77),vio_read(viosocket.c:132),net_read_raw_loop(net_serv.cc:665),net_read_packet_header(net_serv.cc:749),net_read_packet(net_serv.cc:749),my_net_read(net_serv.cc:892),Protocol_classic::read_packet(protocol_classic.cc:808),Protocol_classic::get_command(protocol_classic.cc:965),do_command(sql_parse.cc:936),handle_connection(connection_handler_per_thread.cc:301),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6)
1 poll(libc.so.6),poll(poll2.h:41),Mysqld_socket_listener::listen_for_connection_event(poll2.h:41),connection_event_loop(connection_acceptor.h:66),mysqld_main(connection_acceptor.h:66),__libc_start_main(libc.so.6),_start
1 _int_free(libc.so.6),deallocate(ut0new.h:404),ut_delete<os_event>(ut0new.h:404),os_event_destroy(ut0new.h:404),destroy(ib0mutex.h:657),destroy(ib0mutex.h:657),mutex_destroy<PolicyMutex<TTASEventMutex<BlockMutexPolicy>(ib0mutex.h:657),buf_pool_resize(ib0mutex.h:657),buf_resize_thread(buf0buf.cc:3029),start_thread(libpthread.so.0),clone(libc.so.6)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment