Skip to content

Instantly share code, notes, and snippets.

@okossuth

okossuth/gist:64a35632613840bfd635

Created December 30, 2015 18:16
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 okossuth/64a35632613840bfd635 to your computer and use it in GitHub Desktop.
Save okossuth/64a35632613840bfd635 to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump stack trace
Raw
gistfile1.txt
root@xxxxxx:~# ./poormanprof.sh
31854
10 ??,??,??,??,start_thread,clone,??
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 select,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone,??
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,start_thread,clone,??
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 my_qsort,my_dir,find_files(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,??
1 do_sigwait,sigwait,signal_hand,start_thread,clone,??
1
root@xxxxxxx:~# ./poormanprof.sh
31854
10 ??,??,??,??,start_thread,clone,??
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone,??
1 select,??,??,start_thread,clone,??
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 ??,my_qsort,my_dir,find_files(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,??
1 do_sigwait,sigwait,signal_hand,start_thread,clone,??
1
root@xxxxxxxx:~# ./poormanprof.sh
31854
10 ??,??,??,??,start_thread,clone,??
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 select,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone,??
1 readdir_r,my_dir,find_files(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,??
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,start_thread,clone,??
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 do_sigwait,sigwait,signal_hand,start_thread,clone,??
1
root@xxxxxxxx:~# ./poormanprof.sh
31854
10 ??,??,??,??,start_thread,clone,??
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 select,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone,??
1 ??,readdir_r,my_dir,find_files(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,??
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,start_thread,clone,??
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 do_sigwait,sigwait,signal_hand,start_thread,clone,??
1
root@xxxxxxxx:~# ./poormanprof.sh
31854
10 ??,??,??,??,start_thread,clone,??
3 pthread_cond_timedwait@@GLIBC_2.3.2,??,??,start_thread,clone,??
2 select,??,??,start_thread,clone,??
2 pthread_cond_wait@@GLIBC_2.3.2,one_thread_per_connection_end(THD*,,do_handle_one_connection(THD*),handle_one_connection,start_thread,clone,??
1 ??,readdir_r,my_dir,find_files(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,??
1 pthread_cond_wait@@GLIBC_2.3.2,??,??,start_thread,clone,??
1 poll,handle_connections_sockets(),mysqld_main(int,,__libc_start_main,_start
1 do_sigwait,sigwait,signal_hand,start_thread,clone,??
1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment