Host 10.10.10.10:41519 40835 has a long-running idle transaction at Thu Jul 7 10:29:40 UTC 2011 1310034580 Thread 88 (Thread 0x40a00940 (LWP 434)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 87 (Thread 0x41401940 (LWP 435)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 86 (Thread 0x41e02940 (LWP 436)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 85 (Thread 0x42803940 (LWP 437)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 84 (Thread 0x43204940 (LWP 438)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 83 (Thread 0x43c05940 (LWP 439)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 82 (Thread 0x44606940 (LWP 440)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 81 (Thread 0x45007940 (LWP 441)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 80 (Thread 0x45a08940 (LWP 442)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 79 (Thread 0x46409940 (LWP 443)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 78 (Thread 0x46e0a940 (LWP 444)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 77 (Thread 0x4780b940 (LWP 445)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 76 (Thread 0x4820c940 (LWP 446)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 75 (Thread 0x48c0d940 (LWP 447)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 74 (Thread 0x4960e940 (LWP 448)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 73 (Thread 0x4a00f940 (LWP 449)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 72 (Thread 0x4aa10940 (LWP 450)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 71 (Thread 0x4b411940 (LWP 451)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 70 (Thread 0x4be12940 (LWP 452)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 69 (Thread 0x4c813940 (LWP 453)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 68 (Thread 0x4d214940 (LWP 454)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 67 (Thread 0x4dc15940 (LWP 455)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 66 (Thread 0x4e616940 (LWP 456)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 65 (Thread 0x4f017940 (LWP 457)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 64 (Thread 0x4fa18940 (LWP 458)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 63 (Thread 0x50419940 (LWP 459)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 62 (Thread 0x50e1a940 (LWP 460)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 61 (Thread 0x5181b940 (LWP 461)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 60 (Thread 0x5221c940 (LWP 462)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 59 (Thread 0x52c1d940 (LWP 463)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 58 (Thread 0x5361e940 (LWP 464)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 57 (Thread 0x5401f940 (LWP 465)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 56 (Thread 0x54a20940 (LWP 466)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 55 (Thread 0x55421940 (LWP 467)): #0 0x00002aaaaaee45b4 in ?? () from /usr/lib64/libaio.so.1 #1 0x000000000087859c in os_aio_linux_handle () #2 0x000000000083cf59 in fil_aio_wait () #3 0x00000000007d4c18 in io_handler_thread () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 54 (Thread 0x56823940 (LWP 502)): #0 0x00002aaaaacd4150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000087b585 in os_event_wait_time_low () #2 0x00000000007d4170 in srv_lock_timeout_thread () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 53 (Thread 0x57224940 (LWP 503)): #0 0x00002aaaaacd4150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000087b585 in os_event_wait_time_low () #2 0x00000000007d1ee5 in srv_error_monitor_thread () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 52 (Thread 0x57c25940 (LWP 504)): #0 0x00002aaaaacd4150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000087b585 in os_event_wait_time_low () #2 0x00000000007d444b in srv_monitor_thread () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 51 (Thread 0x55e22940 (LWP 505)): #0 0x00002aaaac19f722 in select () from /lib64/libc.so.6 #1 0x000000000087bbdb in os_thread_sleep () #2 0x00000000007d3810 in srv_master_thread () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 50 (Thread 0x58626940 (LWP 506)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000087b6c7 in os_event_wait_low () #2 0x00000000007d110b in srv_purge_thread () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 49 (Thread 0x58667940 (LWP 520)): #0 0x00002aaaaacd7838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x00002aaaaacd78dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004f254b in signal_hand () #3 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #4 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 48 (Thread 0x586a8940 (LWP 525)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 47 (Thread 0x586e9940 (LWP 531)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 46 (Thread 0x5872a940 (LWP 532)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 45 (Thread 0x5876b940 (LWP 534)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 44 (Thread 0x587ac940 (LWP 539)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 43 (Thread 0x587ed940 (LWP 545)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 42 (Thread 0x5882e940 (LWP 550)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 41 (Thread 0x5886f940 (LWP 565)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 40 (Thread 0x588b0940 (LWP 570)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 39 (Thread 0x588f1940 (LWP 580)): #0 0x00002aaaaacd4150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d60fe in MYSQL_BIN_LOG::wait_for_update_bin_log(THD*, timespec const*) () #2 0x000000000057006a in mysql_binlog_send(THD*, char*, unsigned long long, unsigned short) () #3 0x000000000055dcf9 in dispatch_command(enum_server_command, THD*, char*, unsigned int) () #4 0x000000000055e972 in do_command(THD*) () #5 0x00000000005e9311 in do_handle_one_connection(THD*) () #6 0x00000000005e93fa in handle_one_connection () #7 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #8 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x58932940 (LWP 626)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x58973940 (LWP 875)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x589b4940 (LWP 966)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x589f5940 (LWP 977)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x58a36940 (LWP 988)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x58a77940 (LWP 995)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x58ab8940 (LWP 996)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x58af9940 (LWP 997)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x58b3a940 (LWP 998)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x58b7b940 (LWP 1003)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x58bbc940 (LWP 1009)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x58bfd940 (LWP 1015)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x58c3e940 (LWP 1020)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x58c7f940 (LWP 1076)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x58cc0940 (LWP 1077)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x58d01940 (LWP 1078)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x58d42940 (LWP 1079)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x58d83940 (LWP 1084)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x58dc4940 (LWP 1090)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x58e05940 (LWP 1091)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x58e46940 (LWP 1092)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x58e87940 (LWP 1093)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x58ec8940 (LWP 1098)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x58f09940 (LWP 1104)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x58f4a940 (LWP 1105)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x58f8b940 (LWP 1106)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x58fcc940 (LWP 1107)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x5900d940 (LWP 1108)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x5904e940 (LWP 1113)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x5908f940 (LWP 1200)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x590d0940 (LWP 1361)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x59111940 (LWP 2439)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x59152940 (LWP 2726)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x59193940 (LWP 4021)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x591d4940 (LWP 8643)): #0 0x00002aaaaacd3ee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000004f499a in one_thread_per_connection_end(THD*, bool) () #2 0x00000000005e90d3 in do_handle_one_connection(THD*) () #3 0x00000000005e93fa in handle_one_connection () #4 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #5 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x59215940 (LWP 8656)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x59256940 (LWP 10245)): #0 0x00002aaaaacd691b in read () from /lib64/libpthread.so.0 #1 0x00000000004f5aeb in my_real_read(st_net*, unsigned long*) () #2 0x00000000004f5e33 in my_net_read () #3 0x000000000055e925 in do_command(THD*) () #4 0x00000000005e9311 in do_handle_one_connection(THD*) () #5 0x00000000005e93fa in handle_one_connection () #6 0x00002aaaaaccf73d in start_thread () from /lib64/libpthread.so.0 #7 0x00002aaaac1a64bd in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x2aaaac42ae00 (LWP 410)): #0 0x00002aaaac19d696 in poll () from /lib64/libc.so.6 #1 0x00000000004f1634 in handle_connections_sockets() () #2 0x00000000004f3526 in mysqld_main(int, char**) () #3 0x00002aaaac0ef994 in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000004eb899 in _start () *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110707 10:29:41 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 40 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7702 1_second, 7700 sleeps, 769 10_second, 9 background, 9 flush srv_master_thread log flush and writes: 8957 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 188452, signal count 628184 Mutex spin waits 7157199, rounds 4654397, OS waits 4678 RW-shared spins 230119, rounds 5419481, OS waits 166266 RW-excl spins 65980, rounds 1464437, OS waits 14976 Spin rounds per wait: 0.65 mutex, 23.55 RW-shared, 22.20 RW-excl ------------ TRANSACTIONS ------------ Trx id counter CE26435D Purge done for trx's n:o < CE26434D undo n:o < 0 History list length 345 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 410, OS thread id 1483643200 MySQL thread id 45599, query id 1847330 localhost root show engine innodb status ---TRANSACTION CE264193, not started, process no 410, OS thread id 1486305600 MySQL thread id 45363, query id 1846450 10.10.10.10 myapp ---TRANSACTION CE2641AA, not started, process no 410, OS thread id 1491896640 MySQL thread id 44716, query id 1846499 10.10.10.10 myapp ---TRANSACTION CE264234, not started, process no 410, OS thread id 1491097920 MySQL thread id 44715, query id 1846723 10.10.10.10 myapp ---TRANSACTION CE2642AC, not started, process no 410, OS thread id 1491364160 MySQL thread id 41055, query id 1846832 10.10.10.10 myapp ---TRANSACTION CE264347, not started, process no 410, OS thread id 1488435520 MySQL thread id 40053, query id 1847255 10.10.10.10 myapp ---TRANSACTION CE2641EA, not started, process no 410, OS thread id 1490831680 MySQL thread id 39107, query id 1846677 10.10.10.10 myapp ---TRANSACTION CE2641FB, not started, process no 410, OS thread id 1486039360 MySQL thread id 37017, query id 1846634 10.10.10.20 myapp ---TRANSACTION CE2642AE, not started, process no 410, OS thread id 1491630400 MySQL thread id 37015, query id 1846849 10.10.10.20 myapp ---TRANSACTION CE26409F, not started, process no 410, OS thread id 1489766720 MySQL thread id 37016, query id 1846733 10.10.10.20 myapp ---TRANSACTION CE2641F8, not started, process no 410, OS thread id 1495624000 MySQL thread id 37014, query id 1846631 10.10.10.20 myapp ---TRANSACTION CE264230, not started, process no 410, OS thread id 1486571840 MySQL thread id 37013, query id 1846707 10.10.10.20 myapp ---TRANSACTION CE2641E6, not started, process no 410, OS thread id 1494825280 MySQL thread id 37009, query id 1846586 10.10.10.20 myapp ---TRANSACTION CE264255, not started, process no 410, OS thread id 1492429120 MySQL thread id 37008, query id 1846759 10.10.10.20 myapp ---TRANSACTION CE26435C, not started, process no 410, OS thread id 1495357760 MySQL thread id 37007, query id 1847328 10.10.10.20 myapp ---TRANSACTION CE2641E1, not started, process no 410, OS thread id 1483909440 MySQL thread id 37006, query id 1846571 10.10.10.20 myapp ---TRANSACTION CE264359, not started, process no 410, OS thread id 1488169280 MySQL thread id 37005, query id 1847326 10.10.10.20 myapp ---TRANSACTION CE26431D, not started, process no 410, OS thread id 1494559040 MySQL thread id 37004, query id 1847188 10.10.10.20 myapp ---TRANSACTION CE264198, not started, process no 410, OS thread id 1492695360 MySQL thread id 37000, query id 1846464 10.10.10.20 myapp ---TRANSACTION CE2641A6, not started, process no 410, OS thread id 1485240640 MySQL thread id 36999, query id 1846492 10.10.10.20 myapp ---TRANSACTION CE2641D8, not started, process no 410, OS thread id 1490565440 MySQL thread id 36998, query id 1846564 10.10.10.20 myapp ---TRANSACTION CE264344, not started, process no 410, OS thread id 1484175680 MySQL thread id 36997, query id 1847252 10.10.10.20 myapp ---TRANSACTION CE264336, not started, process no 410, OS thread id 1490299200 MySQL thread id 36996, query id 1847239 10.10.10.20 myapp ---TRANSACTION CE260C3C, not started, process no 410, OS thread id 1494292800 MySQL thread id 36985, query id 1814961 10.10.10.20 myapp ---TRANSACTION CE264356, not started, process no 410, OS thread id 1486838080 MySQL thread id 36992, query id 1847314 10.10.10.20 myapp ---TRANSACTION CE2642B9, not started, process no 410, OS thread id 1492961600 MySQL thread id 36988, query id 1846875 10.10.10.20 myapp ---TRANSACTION CE2642D4, not started, process no 410, OS thread id 1484974400 MySQL thread id 36987, query id 1846932 10.10.10.20 myapp ---TRANSACTION CE264326, not started, process no 410, OS thread id 1484708160 MySQL thread id 36986, query id 1847211 10.10.10.20 myapp ---TRANSACTION CE2642AF, not started, process no 410, OS thread id 1487370560 MySQL thread id 36984, query id 1846848 10.10.10.20 myapp ---TRANSACTION CE264201, not started, process no 410, OS thread id 1490032960 MySQL thread id 36983, query id 1846640 10.10.10.20 myapp ---TRANSACTION CE263A4B, not started, process no 410, OS thread id 1487903040 MySQL thread id 36967, query id 1846579 10.10.10.20 myapp ---TRANSACTION CE263B2F, not started, process no 410, OS thread id 1489234240 MySQL thread id 36957, query id 1846465 10.10.10.20 myapp ---TRANSACTION 0, not started, process no 410, OS thread id 1493760320 MySQL thread id 36953, query id 1432470 10.10.10.20 myapp ---TRANSACTION 0, not started, process no 410, OS thread id 1488968000 MySQL thread id 36951, query id 1432667 10.10.10.20 myapp ---TRANSACTION 0, not started, process no 410, OS thread id 1488701760 MySQL thread id 36947, query id 1432192 10.10.10.20 myapp ---TRANSACTION 0, not started, process no 410, OS thread id 1492162880 MySQL thread id 36943, query id 1432391 10.10.10.20 myapp ---TRANSACTION CE234D00, not started, process no 410, OS thread id 1487104320 MySQL thread id 36942, query id 1432247 10.10.10.20 myapp ---TRANSACTION CE264047, not started, process no 410, OS thread id 1483376960 MySQL thread id 2547, query id 1845774 10.10.10.10 myapp ---TRANSACTION CE262A4B, ACTIVE 80 sec, process no 410, OS thread id 1487636800 4 lock struct(s), heap size 1248, 0 row lock(s), undo log entries 5 MySQL thread id 40835, query id 1832430 10.10.10.10 myapp -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 894675 OS file reads, 359925 OS file writes, 50990 OS fsyncs 56.97 reads/s, 16384 avg bytes/read, 45.87 writes/s, 7.60 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 40, free list len 39009, seg size 39050, 58932 merges merged operations: insert 59128, delete mark 21381, delete 3486 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 57374393, node heap has 55079 buffer(s) 101986.53 hash searches/s, 2059.00 non-hash searches/s --- LOG --- Log sequence number 1726208032233 Log flushed up to 1726207977936 Last checkpoint at 1726186537011 0 pending log writes, 0 pending chkp writes 11006 log i/o's done, 1.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 29670506496; in additional pool allocated 0 Dictionary memory allocated 950645 Buffer pool size 1769468 Free buffers 815052 Database pages 899337 Old database pages 332059 Modified db pages 19806 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3589, not young 0 0.27 youngs/s, 0.00 non-youngs/s Pages read 894604, created 4733, written 338589 57.00 reads/s, 0.22 creates/s, 42.87 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.57/s, evicted without access 0.00/s LRU len: 899337, unzip_LRU len: 0 I/O sum[0]:cur[12], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 442367 Free buffers 200291 Database pages 228294 Old database pages 84292 Modified db pages 5360 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 922, not young 0 0.02 youngs/s, 0.00 non-youngs/s Pages read 226660, created 1634, written 85500 15.30 reads/s, 0.12 creates/s, 10.70 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 1.57/s, evicted without access 0.00/s LRU len: 228294, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 442367 Free buffers 202884 Database pages 225695 Old database pages 83332 Modified db pages 4522 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 887, not young 0 0.05 youngs/s, 0.00 non-youngs/s Pages read 224780, created 915, written 84001 13.85 reads/s, 0.07 creates/s, 10.75 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 225695, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 442367 Free buffers 205235 Database pages 223371 Old database pages 82475 Modified db pages 5063 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 882, not young 0 0.05 youngs/s, 0.00 non-youngs/s Pages read 222485, created 886, written 84589 14.12 reads/s, 0.00 creates/s, 10.70 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 223371, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 442367 Free buffers 206642 Database pages 221977 Old database pages 81960 Modified db pages 4861 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 898, not young 0 0.15 youngs/s, 0.00 non-youngs/s Pages read 220679, created 1298, written 84499 13.72 reads/s, 0.02 creates/s, 10.72 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 221977, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 410, id 1440885056, state: flushing log Number of rows inserted 114398, updated 165606, deleted 1555, read 1080856329 7.95 inserts/s, 15.77 updates/s, 0.15 deletes/s, 115870.70 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ Id User Host db Command Time State Info 99 repl 10.10.10.30:40058 NULL Binlog Dump 9159 Master has sent all binlog to slave; waiting for binlog to be updated NULL 2547 myapp 10.10.10.10:41552 myapp_db Sleep 9 NULL 36942 myapp 10.10.10.20:50263 myapp_db Sleep 1739 NULL 36943 myapp 10.10.10.20:50264 myapp_db Sleep 1737 NULL 36947 myapp 10.10.10.20:50265 myapp_db Sleep 1739 NULL 36951 myapp 10.10.10.20:50266 myapp_db Sleep 1735 NULL 36953 myapp 10.10.10.20:50267 myapp_db Sleep 1736 NULL 36957 myapp 10.10.10.20:50268 myapp_db Sleep 5 NULL 36967 myapp 10.10.10.20:50269 myapp_db Sleep 4 NULL 36983 myapp 10.10.10.20:50270 myapp_db Sleep 4 NULL 36984 myapp 10.10.10.20:50271 myapp_db Sleep 2 NULL 36985 myapp 10.10.10.20:50272 myapp_db Sleep 178 NULL 36986 myapp 10.10.10.20:50273 myapp_db Sleep 1 NULL 36987 myapp 10.10.10.20:50274 myapp_db Sleep 2 NULL 36988 myapp 10.10.10.20:50275 myapp_db Sleep 2 NULL 36992 myapp 10.10.10.20:50276 myapp_db Sleep 1 NULL 36996 myapp 10.10.10.20:50283 myapp_db Sleep 1 NULL 36997 myapp 10.10.10.20:50284 myapp_db Sleep 1 NULL 36998 myapp 10.10.10.20:50285 myapp_db Sleep 4 NULL 36999 myapp 10.10.10.20:50286 myapp_db Sleep 5 NULL 37000 myapp 10.10.10.20:50287 myapp_db Sleep 5 NULL 37004 myapp 10.10.10.20:50297 myapp_db Sleep 1 NULL 37005 myapp 10.10.10.20:50298 myapp_db Sleep 0 NULL 37006 myapp 10.10.10.20:50299 myapp_db Sleep 4 NULL 37007 myapp 10.10.10.20:50302 myapp_db Sleep 0 NULL 37008 myapp 10.10.10.20:50304 myapp_db Sleep 3 NULL 37009 myapp 10.10.10.20:50312 myapp_db Sleep 4 NULL 37013 myapp 10.10.10.20:50313 myapp_db Sleep 3 NULL 37014 myapp 10.10.10.20:50314 myapp_db Sleep 4 NULL 37015 myapp 10.10.10.20:50315 myapp_db Sleep 2 NULL 37016 myapp 10.10.10.20:50316 myapp_db Sleep 3 NULL 37017 myapp 10.10.10.20:50317 myapp_db Sleep 4 NULL 39107 myapp 10.10.10.10:40583 myapp_db Sleep 4 NULL 40053 myapp 10.10.10.10:40794 myapp_db Sleep 1 NULL 40835 myapp 10.10.10.10:41519 myapp_db Sleep 80 NULL 41055 myapp 10.10.10.10:41553 myapp_db Sleep 2 NULL 44715 myapp 10.10.10.10:34705 myapp_db Sleep 3 NULL 44716 myapp 10.10.10.10:34707 myapp_db Sleep 5 NULL 45363 myapp 10.10.10.10:54050 myapp_db Sleep 5 NULL 45599 root localhost myapp_db Query 0 NULL show full processlist procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 0 0 0 48260 123468 17056696 0 0 552 1157 34 6 11 1 71 16 0 1 0 0 46796 123468 17057060 0 0 356 225 651 644 1 1 89 9 0 0 1 0 42676 123468 17059008 0 0 1700 61 1220 898 8 0 70 21 0 0 0 0 41944 123476 17059000 0 0 276 65 850 611 3 0 91 5 0 0 2 0 41304 123476 17059748 0 0 484 7668 1854 2080 9 0 73 18 0 0 1 0 39104 123496 17060456 0 0 628 10244 2903 3048 4 1 74 21 0 0 0 0 38552 123496 17060712 0 0 64 637 708 726 0 0 97 3 0 0 1 0 36844 123496 17061804 0 0 980 1201 1200 793 9 0 71 19 0 0 1 0 34504 123504 17063084 0 0 1300 47 722 714 1 0 75 24 0 0 1 0 31088 123504 17064176 0 0 1480 30 1507 1061 10 0 66 23 0