Skip to content

Instantly share code, notes, and snippets.

@johnskopis

johnskopis/gist:6619586

Created September 19, 2013 06:02
Show Gist options
  • Save johnskopis/6619586 to your computer and use it in GitHub Desktop.
Save johnskopis/6619586 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[root@sfdb32 ~]# pmp
1051 read,??,my_net_read,do_command(THD*),do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
96 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
36 ??,??,??,??,start_thread,clone
12 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
12 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,??,??,handler::ha_write_row(unsigned,write_record(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
7 pthread_cond_timedwait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::store_query(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
6 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::read_range_first(st_key_range,handler::read_multi_range_first(st_key_multi_range**,,QUICK_RANGE_SELECT::get_next(),??,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
5 pthread_cond_timedwait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::send_result_to_client(THD*,,mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
4 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
3 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,open_and_lock_tables(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,MYSQL_BIN_LOG::wait_for_update_bin_log(THD*,,mysql_binlog_send(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::index_read_idx_map(unsigned,??,??,??,JOIN::optimize(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 sigwait,signal_hand,start_thread,clone
1 select,??,??,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::insert(Query_cache_tls*,,net_real_write,??,my_net_write,Protocol::write(),??,??,sub_select(JOIN*,,??,JOIN::exec(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,Query_cache::ask_handler_allowance(THD*,,Query_cache::store_query(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::ha_write_row(unsigned,write_record(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 ??,??,??,??,??,??,??,??,??,??,??,??,??,??,ha_delete_table(THD*,,mysql_rm_table_no_locks(THD*,,mysql_rm_table(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1
[root@sfdb32 ~]# pmp
850 read,??,my_net_read,do_command(THD*),do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
246 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
36 ??,??,??,??,start_thread,clone
30 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::read_range_first(st_key_range,handler::read_multi_range_first(st_key_multi_range**,,QUICK_RANGE_SELECT::get_next(),??,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
30 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,open_and_lock_tables(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
22 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
22 pthread_cond_timedwait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::store_query(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
14 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,??,??,handler::ha_write_row(unsigned,write_record(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
14 pthread_cond_timedwait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::send_result_to_client(THD*,,mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
10 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,MYSQL_BIN_LOG::wait_for_update_bin_log(THD*,,mysql_binlog_send(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::index_read_idx_map(unsigned,??,??,??,JOIN::optimize(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 sigwait,signal_hand,start_thread,clone
1 select,??,??,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::insert(Query_cache_tls*,,net_real_write,??,my_net_write,Protocol::write(),??,??,sub_select(JOIN*,,??,JOIN::exec(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,Query_cache::ask_handler_allowance(THD*,,Query_cache::store_query(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::ha_write_row(unsigned,write_record(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 ??,??,??,??,??,??,??,??,??,??,??,??,??,ha_delete_table(THD*,,mysql_rm_table_no_locks(THD*,,mysql_rm_table(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1
[root@sfdb32 ~]# pmp
496 read,??,my_net_read,do_command(THD*),do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
380 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,open_and_lock_tables(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
373 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,open_normal_and_derived_tables(THD*,,??,get_all_tables(THD*,,get_schema_tables_result(JOIN*,,JOIN::exec(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
314 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
38 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
36 ??,??,??,??,start_thread,clone
35 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,??,??,handler::ha_write_row(unsigned,write_record(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
24 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::lock(),Query_cache::invalidate_table(THD*,,Query_cache::invalidate_table(THD*,,Query_cache::invalidate(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
13 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::read_range_first(st_key_range,handler::read_multi_range_first(st_key_multi_range**,,QUICK_RANGE_SELECT::get_next(),??,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
10 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,mysql_update(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
6 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,MYSQL_BIN_LOG::wait_for_update_bin_log(THD*,,mysql_binlog_send(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,??,start_thread,clone
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,handler::index_read_idx_map(unsigned,??,??,??,JOIN::optimize(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 sigwait,signal_hand,start_thread,clone
1 select,??,??,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,store_create_info(THD*,,mysqld_show_create(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,Query_cache::try_lock(bool),Query_cache::insert(Query_cache_tls*,,net_real_write,??,my_net_write,Protocol::write(),??,??,sub_select(JOIN*,,??,JOIN::exec(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,??,Query_cache::ask_handler_allowance(THD*,,Query_cache::store_query(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,open_table_from_share(THD*,,open_table(THD*,,open_tables(THD*,,open_and_lock_tables(THD*,,mysql_insert(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,??,??,??,??,handler::ha_open(TABLE*,,handler::clone(char,??,QUICK_RANGE_SELECT::init_ror_merged_scan(bool),QUICK_ROR_INTERSECT_SELECT::init_ror_merged_scan(bool),QUICK_ROR_INTERSECT_SELECT::reset(),??,sub_select(JOIN*,,??,JOIN::exec(),mysql_select(THD*,,handle_select(THD*,,??,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 ??,??,??,??,??,??,??,??,??,??,??,??,??,??,ha_delete_table(THD*,,mysql_rm_table_no_locks(THD*,,mysql_rm_table(THD*,,mysql_execute_command(THD*),mysql_parse(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1
[root@sfdb32 ~]# pmp
1620 read,??,my_net_read,do_command(THD*),do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
36 ??,??,??,??,start_thread,clone
30 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
3 select,??,??,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone
3 pthread_cond_timedwait@@GLIBC_2.3.2,MYSQL_BIN_LOG::wait_for_update_bin_log(THD*,,mysql_binlog_send(THD*,,dispatch_command(enum_server_command,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone
1 sigwait,signal_hand,start_thread,clone
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment