API tools faq
paste
Advertisement
kn0tsel

MySQL-12

kn0tsel
Nov 23rd, 2012
376
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Logtalk 11.27 KB | None | 0 0
raw download clone embed print report
  1. Analysis of sampling mysqld (pid 51710) every 1 millisecond
  2. Process:         mysqld [51710]
  3. Path:            /opt/local/lib/mysql55/bin/mysqld
  4. Load Address:    0x108725000
  5. Identifier:      mysqld
  6. Version:         ??? (???)
  7. Code Type:       X86-64 (Native)
  8. Parent Process:  sh [51614]
  9.  
  10. Date/Time:       2012-11-23 14:29:37.102 +0100
  11. OS Version:      Mac OS X 10.7.5 (11G63)
  12. Report Version:  7
  13.  
  14. Call graph:
  15.     2578 Thread_880949   DispatchQueue_1: com.apple.main-thread  (serial)
  16.     + 2578 start  (in mysqld) + 52  [0x108727a14]
  17.     +   2578 mysqld_main(int, char**)  (in mysqld) + 14243  [0x1087fe3e3]
  18.     +     2578 handle_connections_sockets()  (in mysqld) + 436  [0x1087fee04]
  19.     +       2578 poll  (in libsystem_kernel.dylib) + 10  [0x7fff86e47a7a]
  20.     2578 Thread_880950
  21.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  22.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  23.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  24.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  25.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  26.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  27.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  28.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  29.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  30.     2578 Thread_880951
  31.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  32.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  33.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  34.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  35.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  36.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  37.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  38.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  39.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  40.     2578 Thread_880952
  41.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  42.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  43.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  44.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  45.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  46.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  47.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  48.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  49.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  50.     2578 Thread_880953
  51.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  52.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  53.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  54.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  55.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  56.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  57.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  58.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  59.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  60.     2578 Thread_880954
  61.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  62.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  63.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  64.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  65.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  66.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  67.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  68.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  69.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  70.     2578 Thread_880955
  71.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  72.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  73.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  74.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  75.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  76.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  77.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  78.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  79.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  80.     2578 Thread_880956
  81.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  82.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  83.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  84.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  85.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  86.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  87.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  88.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  89.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  90.     2578 Thread_880957
  91.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  92.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  93.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  94.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  95.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  96.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  97.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  98.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  99.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  100.     2578 Thread_880958
  101.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  102.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  103.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  104.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  105.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  106.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  107.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  108.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  109.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  110.     2578 Thread_880959
  111.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  112.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  113.     +     2578 io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  114.     +       2578 fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  115.     +         2578 os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  116.     +           2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  117.     +             2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  118.     +               2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  119.     +                 2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  120.     2578 Thread_880961
  121.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  122.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  123.     +     2577 srv_lock_timeout_thread  (in mysqld) + 128  [0x108a5dca0]
  124.     +     ! 2577 os_event_wait_time_low  (in mysqld) + 275  [0x108a1eda3]
  125.     +     !   2577 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  126.     +     !     2577 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  127.     +     1 srv_lock_timeout_thread  (in mysqld) + 204  [0x108a5dcec]
  128.     2578 Thread_880962
  129.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  130.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  131.     +     2576 srv_error_monitor_thread  (in mysqld) + 510  [0x108a5dffe]
  132.     +     ! 2576 os_event_wait_time_low  (in mysqld) + 275  [0x108a1eda3]
  133.     +     !   2576 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  134.     +     !     2576 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  135.     +     2 srv_error_monitor_thread  (in mysqld) + 416  [0x108a5dfa0]
  136.     +       2 sync_array_print_long_waits  (in mysqld) + 190  [0x108a6295e]
  137.     2578 Thread_880963
  138.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  139.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  140.     +     2578 srv_monitor_thread  (in mysqld) + 228  [0x108a5da24]
  141.     +       2578 os_event_wait_time_low  (in mysqld) + 275  [0x108a1eda3]
  142.     +         2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  143.     +           2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  144.     2578 Thread_880964
  145.     + 2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  146.     +   2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  147.     +     2578 srv_master_thread  (in mysqld) + 4016  [0x108a5f380]
  148.     +       2578 os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  149.     +         2578 os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  150.     +           2578 _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  151.     +             2578 __psynch_cvwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e46bca]
  152.     2578 Thread_880969
  153.       2578 thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  154.         2578 _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  155.           2578 signal_hand  (in mysqld) + 1099  [0x1087fa81b]
  156.             2578 sigwait  (in libsystem_c.dylib) + 68  [0x7fff8d5d6aab]
  157.               2578 __sigwait  (in libsystem_kernel.dylib) + 10  [0x7fff86e47036]
  158.  
  159. Total number in stack (recursive counted multiple, when >=5):
  160.         15       _pthread_start  (in libsystem_c.dylib) + 335  [0x7fff8d6208bf]
  161.         15       thread_start  (in libsystem_c.dylib) + 13  [0x7fff8d623b75]
  162.         14       __psynch_cvwait  (in libsystem_kernel.dylib) + 0  [0x7fff86e46bc0]
  163.         14       _pthread_cond_wait  (in libsystem_c.dylib) + 840  [0x7fff8d624274]
  164.         11       os_cond_wait  (in mysqld) + 19  [0x108a1df33]
  165.         11       os_event_wait_low  (in mysqld) + 59  [0x108a1ec6b]
  166.         10       fil_aio_wait  (in mysqld) + 63  [0x1089f425f]
  167.         10       io_handler_thread  (in mysqld) + 88  [0x108a61b58]
  168.         10       os_aio_simulated_handle  (in mysqld) + 827  [0x108a1ccab]
  169.  
  170. Sort by top of stack, same collapsed (when >= 5):
  171.         __psynch_cvwait  (in libsystem_kernel.dylib)        36089
  172.         __sigwait  (in libsystem_kernel.dylib)        2578
  173.         poll  (in libsystem_kernel.dylib)        2578
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!