Analysis of sampling pid 293 every 10.000000 milliseconds Call graph: 99 Thread_0f07 99 start 99 _start 99 main 99 handle_connections_sockets 97 select 97 select 2 fcntl 2 fcntl 99 Thread_1003 99 _pthread_body 99 signal_hand 82 process_alarm 51 pthread_sigmask 51 pthread_sigmask 26 alarm 20 setitimer 20 setitimer 6 alarm 3 pthread_mutex_unlock 3 semaphore_signal_trap 3 semaphore_signal_trap 1 process_alarm 1 time 1 gettimeofday 1 __gettimeofday 1 __gettimeofday 17 sigwait 17 sigwait 99 Thread_1103 99 _pthread_body 99 handle_one_connection 82 end_thread(THD*, bool) 82 pthread_cond_wait 82 semaphore_wait_signal_trap 82 semaphore_wait_signal_trap 9 my_net_read 9 my_real_read(st_net*, unsigned long*) 8 read 8 read 1 thr_alarm 1 pthread_mutex_lock 1 semaphore_wait_signal_trap 1 semaphore_wait_signal_trap 7 dispatch_command(enum_server_command, THD*, char*, unsigned) 4 mysql_parse(THD*, char const*, unsigned, char const**) 4 Query_cache::send_result_to_client(THD*, char*, unsigned) 2 my_clock 2 times 2 getrusage 2 getrusage 2 net_real_write 2 write 2 write 2 my_pthread_setprio 2 pthread_setschedparam 2 thread_policy 2 mach_msg 2 mach_msg_trap 2 mach_msg_trap 1 send_ok(THD*, unsigned long long, unsigned long long, char const*) 1 net_flush 1 net_real_write 1 write 1 write 1 check_user(THD*, enum_server_command, char const*, unsigned, char const*, bool) 1 send_ok(THD*, unsigned long long, unsigned long long, char const*) 1 net_flush 1 net_real_write 1 write 1 write 99 Thread_1203 99 _pthread_body 99 handle_one_connection 81 end_thread(THD*, bool) 81 pthread_cond_wait 81 semaphore_wait_signal_trap 81 semaphore_wait_signal_trap 17 dispatch_command(enum_server_command, THD*, char*, unsigned) 17 mysql_parse(THD*, char const*, unsigned, char const**) 17 Query_cache::send_result_to_client(THD*, char*, unsigned) 16 net_real_write 16 write 16 write 1 my_clock 1 times 1 getrusage 1 getrusage 1 check_user(THD*, enum_server_command, char const*, unsigned, char const*, bool) 1 send_ok(THD*, unsigned long long, unsigned long long, char const*) 1 net_flush 1 net_real_write 1 write 1 write 99 Thread_1303 99 _pthread_body 99 handle_one_connection 99 my_net_read 99 my_real_read(st_net*, unsigned long*) 99 read 99 read 99 Thread_1403 99 _pthread_body 99 handle_one_connection 99 my_net_read 99 my_real_read(st_net*, unsigned long*) 99 read 99 read 99 Thread_1503 99 _pthread_body 99 handle_one_connection 99 end_thread(THD*, bool) 99 pthread_cond_wait 99 semaphore_wait_signal_trap 99 semaphore_wait_signal_trap 99 Thread_1603 99 _pthread_body 99 handle_one_connection 72 my_net_read 72 my_real_read(st_net*, unsigned long*) 72 read 72 read 26 end_thread(THD*, bool) 26 pthread_cond_wait 26 semaphore_wait_signal_trap 26 semaphore_wait_signal_trap 1 dispatch_command(enum_server_command, THD*, char*, unsigned) 1 mysql_parse(THD*, char const*, unsigned, char const**) 1 Query_cache::send_result_to_client(THD*, char*, unsigned) 1 net_real_write 1 write 1 write 99 Thread_1703 99 _pthread_body 99 handle_one_connection 78 my_net_read 78 my_real_read(st_net*, unsigned long*) 78 read 78 read 20 dispatch_command(enum_server_command, THD*, char*, unsigned) 18 mysql_parse(THD*, char const*, unsigned, char const**) 18 mysql_execute_command(THD*) 17 mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, unsigned, st_order*, unsigned long long, enum_duplicates, bool) 17 MYSQL_LOG::write(Log_event*) 17 MYSQL_LOG::flush_and_sync() 17 my_b_flush_io_cache 17 my_write 17 write 17 write 1 handle_select(THD*, st_lex*, select_result*, unsigned long) 1 mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) 1 JOIN::exec() 1 do_select(JOIN*, List*, st_table*, Procedure*) 1 select_send::send_eof() 1 send_eof(THD*) 1 net_flush 1 net_real_write 1 write 1 write 2 my_pthread_setprio 2 pthread_setschedparam 2 thread_policy 2 mach_msg 2 mach_msg_trap 2 mach_msg_trap 1 end_thread(THD*, bool) 1 pthread_cond_wait 1 semaphore_wait_signal_trap 1 semaphore_wait_signal_trap 99 Thread_1803 99 _pthread_body 99 handle_one_connection 99 my_net_read 99 my_real_read(st_net*, unsigned long*) 99 read 99 read 99 Thread_1903 99 _pthread_body 99 handle_one_connection 99 my_net_read 99 my_real_read(st_net*, unsigned long*) 99 read 99 read 99 Thread_1a03 99 _pthread_body 99 handle_one_connection 77 end_thread(THD*, bool) 77 pthread_cond_wait 77 semaphore_wait_signal_trap 77 semaphore_wait_signal_trap 22 dispatch_command(enum_server_command, THD*, char*, unsigned) 19 mysql_parse(THD*, char const*, unsigned, char const**) 17 mysql_parse(THD*, char const*, unsigned, char const**) 2 Query_cache::send_result_to_client(THD*, char*, unsigned) 2 net_real_write 2 write 2 write 3 my_pthread_setprio 3 pthread_setschedparam 3 thread_policy 3 mach_msg 3 mach_msg_trap 3 mach_msg_trap Total number in stack (recursive counted multiple, when >=5): 11 _pthread_body 10 handle_one_connection 9 write 8 net_real_write 7 my_net_read 7 my_real_read(st_net*, unsigned long*) 7 read 7 semaphore_wait_signal_trap 6 end_thread(THD*, bool) 6 pthread_cond_wait 5 dispatch_command(enum_server_command, THD*, char*, unsigned) 5 mysql_parse(THD*, char const*, unsigned, char const**) Sort by top of stack, same collapsed (when >= 5): read 554 semaphore_wait_signal_trap 367 select 97 pthread_sigmask 51 write 42 setitimer 20 mysql_parse(THD*, char const*, unsigned, char const**) 17 sigwait 17 mach_msg_trap 7 alarm 6 Sample analysis of process 293 written to file /dev/stdout Sampling process 293 each 10 msecs 100 times