mysql> show processlist; +----+------+---------------------+------+---------+------+--------------------+------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+---------------------+------+---------+------+--------------------+------------------------------------+ | 2 | root | 192.168.250.3:41581 | test | Query | 457 | Waiting for table | select * from t1 where id = -16062 | | 3 | root | 192.168.250.3:41582 | test | Query | 457 | Waiting for table | select * from t1 where id = 6387 | | 4 | root | 192.168.250.3:41583 | test | Query | 457 | Waiting for table | select * from t1 where id = 14369 | | 5 | root | 192.168.250.3:41584 | test | Query | 457 | Waiting for tables | select * from t1 where id = 13240 | | 6 | root | 192.168.250.3:41585 | test | Query | 457 | Waiting for table | select * from t1 where id = 28811 | | 7 | root | 192.168.250.3:41586 | test | Query | 457 | Waiting for table | drop table if exists t1 | | 8 | root | 192.168.250.3:41587 | test | Query | 457 | Waiting for table | select * from t1 where id = 22426 | | 9 | root | 192.168.250.3:41588 | test | Query | 457 | Waiting for table | drop table if exists t1 | | 10 | root | 192.168.250.3:41589 | test | Query | 457 | Waiting for table | drop table if exists t1 | | 11 | root | 192.168.250.3:41590 | test | Query | 457 | Waiting for table | select * from t1 where id = -12824 | | 12 | root | 127.0.0.1:51288 | test | Query | 0 | NULL | show processlist | +----+------+---------------------+------+---------+------+--------------------+------------------------------------+ 11 rows in set (0.00 sec) 14408 __tmainCRTStartup pthread_cond_wait Below Normal 0 2032 io_handler_thread os_event_wait_multiple Highest 0 14628 io_handler_thread os_event_wait_multiple Highest 0 14964 io_handler_thread os_event_wait_multiple Highest 0 14472 io_handler_thread os_event_wait_multiple Highest 0 3352 srv_lock_timeout_and_monitor_thread os_thread_sleep Highest 0 10804 srv_error_monitor_thread os_thread_sleep Highest 0 14900 srv_master_thread os_event_wait Highest 0 14672 _threadstart handle_shutdown Normal 0 12368 _threadstart pthread_cond_timedwait Normal 0 15328 _threadstart _beginthread Normal 0 1848 _threadstart pthread_cond_wait Highest 0 8644 _threadstart pthread_cond_wait Highest 0 4724 _threadstart pthread_cond_wait Highest 0 7116 _threadstart pthread_cond_wait Highest 0 15168 _threadstart pthread_cond_wait Highest 0 8008 _threadstart pthread_cond_wait Highest 0 8456 _threadstart pthread_cond_wait Highest 0 13220 _threadstart pthread_cond_wait Highest 0 10716 _threadstart pthread_cond_wait Highest 0 13740 _threadstart pthread_cond_wait Highest 0 > 12032 _threadstart vio_read Normal 0 14408 __tmainCRTStartup pthread_cond_wait Below Normal 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e34d0, _RTL_CRITICAL_SECTION * mutex=0x009e2fc0) Line 49 C mysqld-debug.exe!handle_connections_methods() Line 3129 + 0xf bytes C++ mysqld-debug.exe!win_main(int argc=0x00000006, char * * argv=0x02143748) Line 3346 C++ mysqld-debug.exe!mysql_service(void * p=0x00000000) Line 3400 + 0x12 bytes C++ mysqld-debug.exe!main(int argc=0x00000006, char * * argv=0x02143748) Line 3555 + 0x7 bytes C++ mysqld-debug.exe!__tmainCRTStartup() Line 318 + 0x19 bytes C mysqld-debug.exe!mainCRTStartup() Line 187 C kernel32.dll!BaseProcessInitPostImport() + 0x8d bytes > 2032 io_handler_thread os_event_wait_multiple Highest 0 ntdll.dll!NtWaitForMultipleObjects() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForMultipleObjects() + 0x18 bytes > mysqld-debug.exe!os_event_wait_multiple(unsigned long n=0x00000020, void * * native_event_array=0x02250230) Line 413 + 0x12 bytes C mysqld-debug.exe!os_aio_windows_handle(unsigned long segment=0x00000000, unsigned long pos=0x00000000, void * * message1=0x03baff98, void * * message2=0x03baff90, unsigned long * type=0x03baffa0) Line 3491 + 0x1a bytes C mysqld-debug.exe!fil_aio_wait(unsigned long segment=0x00000000) Line 4089 + 0x17 bytes C mysqld-debug.exe!io_handler_thread(void * arg=0x009e75c8) Line 432 + 0x9 bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 14628 io_handler_thread os_event_wait_multiple Highest 0 ntdll.dll!NtWaitForMultipleObjects() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForMultipleObjects() + 0x18 bytes > mysqld-debug.exe!os_event_wait_multiple(unsigned long n=0x00000020, void * * native_event_array=0x02251ad0) Line 413 + 0x12 bytes C mysqld-debug.exe!os_aio_windows_handle(unsigned long segment=0x00000000, unsigned long pos=0x00000000, void * * message1=0x03ceff98, void * * message2=0x03ceff90, unsigned long * type=0x03ceffa0) Line 3491 + 0x1a bytes C mysqld-debug.exe!fil_aio_wait(unsigned long segment=0x00000001) Line 4089 + 0x17 bytes C mysqld-debug.exe!io_handler_thread(void * arg=0x009e75cc) Line 432 + 0x9 bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 14964 io_handler_thread os_event_wait_multiple Highest 0 ntdll.dll!NtWaitForMultipleObjects() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForMultipleObjects() + 0x18 bytes > mysqld-debug.exe!os_event_wait_multiple(unsigned long n=0x00000020, void * * native_event_array=0x02253370) Line 413 + 0x12 bytes C mysqld-debug.exe!os_aio_windows_handle(unsigned long segment=0x00000000, unsigned long pos=0x00000000, void * * message1=0x03e2ff98, void * * message2=0x03e2ff90, unsigned long * type=0x03e2ffa0) Line 3491 + 0x1a bytes C mysqld-debug.exe!fil_aio_wait(unsigned long segment=0x00000002) Line 4089 + 0x17 bytes C mysqld-debug.exe!io_handler_thread(void * arg=0x009e75d0) Line 432 + 0x9 bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 14472 io_handler_thread os_event_wait_multiple Highest 0 ntdll.dll!NtWaitForMultipleObjects() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForMultipleObjects() + 0x18 bytes > mysqld-debug.exe!os_event_wait_multiple(unsigned long n=0x00000020, void * * native_event_array=0x02254c10) Line 413 + 0x12 bytes C mysqld-debug.exe!os_aio_windows_handle(unsigned long segment=0x00000000, unsigned long pos=0x00000000, void * * message1=0x03f6ff98, void * * message2=0x03f6ff90, unsigned long * type=0x03f6ffa0) Line 3491 + 0x1a bytes C mysqld-debug.exe!fil_aio_wait(unsigned long segment=0x00000003) Line 4089 + 0x17 bytes C mysqld-debug.exe!io_handler_thread(void * arg=0x009e75d4) Line 432 + 0x9 bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 3352 srv_lock_timeout_and_monitor_thread os_thread_sleep Highest 0 ntdll.dll!NtDelayExecution() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!Sleep() + 0xf bytes > mysqld-debug.exe!os_thread_sleep(unsigned long tm=0x000f4240) Line 276 C mysqld-debug.exe!srv_lock_timeout_and_monitor_thread(void * arg=0x00000000) Line 1686 + 0xa bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 10804 srv_error_monitor_thread os_thread_sleep Highest 0 ntdll.dll!NtDelayExecution() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!Sleep() + 0xf bytes > mysqld-debug.exe!os_thread_sleep(unsigned long tm=0x001e8480) Line 276 C mysqld-debug.exe!srv_error_monitor_thread(void * arg=0x00000000) Line 1910 + 0xa bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 14900 srv_master_thread os_event_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!os_event_wait(os_event_struct * event=0x0220e580) Line 307 + 0xe bytes C mysqld-debug.exe!srv_master_thread(void * arg=0x00000000) Line 2402 + 0x9 bytes C kernel32.dll!FlsSetValue() + 0x136 bytes > 14672 _threadstart handle_shutdown Normal 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!handle_shutdown(void * arg=0x00000000) Line 2365 + 0xf bytes C++ mysqld-debug.exe!pthread_start(void * param=0x021cc668) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x022bfd38) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 12368 _threadstart pthread_cond_timedwait Normal 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x009e63d8, _RTL_CRITICAL_SECTION * mutex=0x009e63bc, timespec * abstime=0x051eff34) Line 67 + 0x11 bytes C mysqld-debug.exe!handle_manager(void * arg=0x00000000) Line 62 + 0x13 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x021cc668) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0446f840) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 15328 _threadstart _beginthread Normal 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] mswsock.dll!7db4092c() kernel32.dll!CreateThread() + 0x1e bytes kernel32.dll!ResumeThread() + 0x12 bytes > mysqld-debug.exe!_beginthread(void (void *)* initialcode=0x0532fb7c, unsigned int stacksize=0x71bf17fc, void * argument=0x0532fc94) Line 164 + 0xa bytes C 000072f1() ws2_32.dll!select() + 0xa1 bytes ws2_32.dll!WEP() + 0x49c bytes mysqld-debug.exe!00780b1f() kernel32.dll!MulDiv() + 0x175 bytes > 1848 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x04462500) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x04462500, const char * db=0x044967d8, const char * table_name=0x04496910, const char * alias=0x04496930, int * refresh=0x0546ee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x04462500, st_table_list * start=0x04496938, unsigned int * counter=0x0546ee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04462500, st_table_list * tables=0x04496938) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04462500) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04462500, char * inBuf=0x04496848, unsigned int length=0x00000022) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04462500, char * packet=0x04470161, unsigned int packet_length=0x00000023) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04462500) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04462500) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x021cc668) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044741a8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 8644 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x04474410) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x04474410, const char * db=0x0446fe90, const char * table_name=0x044c1738, const char * alias=0x044c1758, int * refresh=0x055aee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x04474410, st_table_list * start=0x044c1760, unsigned int * counter=0x055aee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04474410, st_table_list * tables=0x044c1760) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04474410) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04474410, char * inBuf=0x044c1670, unsigned int length=0x00000020) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04474410, char * packet=0x044760f9, unsigned int packet_length=0x00000021) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04474410) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04474410) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04463e98) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0447a140) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 4724 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x0447a3a8) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x0447a3a8, const char * db=0x0446fdd0, const char * table_name=0x044ba608, const char * alias=0x044ba628, int * refresh=0x056eee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x0447a3a8, st_table_list * start=0x044ba630, unsigned int * counter=0x056eee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x0447a3a8, st_table_list * tables=0x044ba630) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0447a3a8) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0447a3a8, char * inBuf=0x044ba540, unsigned int length=0x00000021) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0447a3a8, char * packet=0x0447c169, unsigned int packet_length=0x00000022) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0447a3a8) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0447a3a8) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0446c128) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044801b0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 7116 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_tables(THD * thd=0x04480418) Line 1362 + 0xf bytes C++ mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04480418, st_table * * tables=0x044c8dd0, unsigned int count=0x00000001, unsigned int flags=0x00000000) Line 187 + 0x9 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04480418, st_table_list * tables=0x044c8be8, unsigned int count=0x00000001) Line 1910 + 0x19 bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04480418, st_table_list * tables=0x044c8be8) Line 1814 + 0x29 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04480418) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04480418, char * inBuf=0x044c8af8, unsigned int length=0x00000021) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04480418, char * packet=0x044821d9, unsigned int packet_length=0x00000022) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04480418) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04480418) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04486220) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x04486268) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 15168 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x044864d0) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x044864d0, const char * db=0x0447bc38, const char * table_name=0x044cfcf0, const char * alias=0x044cfd10, int * refresh=0x0596ee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x044864d0, st_table_list * start=0x044cfd18, unsigned int * counter=0x0596ee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x044864d0, st_table_list * tables=0x044cfd18) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x044864d0) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x044864d0, char * inBuf=0x044cfc28, unsigned int length=0x00000021) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x044864d0, char * packet=0x04488291, unsigned int packet_length=0x00000022) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x044864d0) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x044864d0) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0448c2d8) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0448c320) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 8008 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x0448c6a8) Line 802 + 0xf bytes C++ mysqld-debug.exe!wait_for_locked_table_names(THD * thd=0x0448c6a8, st_table_list * table_list=0x044d6dc8) Line 883 + 0x9 bytes C++ mysqld-debug.exe!lock_table_names(THD * thd=0x0448c6a8, st_table_list * table_list=0x044d6dc8) Line 925 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table_part2(THD * thd=0x0448c6a8, st_table_list * tables=0x044d6dc8, int if_exists=0x00000001, int drop_temporary=0x00000000, int dont_log_query=0x00000000) Line 218 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table(THD * thd=0x0448c6a8, st_table_list * tables=0x044d6dc8, char if_exists='', char drop_temporary=0x00) Line 122 + 0x19 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0448c6a8) Line 3211 + 0x21 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0448c6a8, char * inBuf=0x044d6d58, unsigned int length=0x00000017) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0448c6a8, char * packet=0x0448e469, unsigned int packet_length=0x00000018) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0448c6a8) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0448c6a8) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x021cc668) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044924b0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 8456 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x04499908) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x04499908, const char * db=0x0447bdb8, const char * table_name=0x044ddf50, const char * alias=0x044ddf70, int * refresh=0x05beee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x04499908, st_table_list * start=0x044ddf78, unsigned int * counter=0x05beee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04499908, st_table_list * tables=0x044ddf78) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04499908) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04499908, char * inBuf=0x044dde88, unsigned int length=0x00000021) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04499908, char * packet=0x0449b6c9, unsigned int packet_length=0x00000022) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04499908) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04499908) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0449f710) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0449f758) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 13220 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x0449fae0) Line 802 + 0xf bytes C++ mysqld-debug.exe!wait_for_locked_table_names(THD * thd=0x0449fae0, st_table_list * table_list=0x044e5028) Line 883 + 0x9 bytes C++ mysqld-debug.exe!lock_table_names(THD * thd=0x0449fae0, st_table_list * table_list=0x044e5028) Line 925 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table_part2(THD * thd=0x0449fae0, st_table_list * tables=0x044e5028, int if_exists=0x00000001, int drop_temporary=0x00000000, int dont_log_query=0x00000000) Line 218 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table(THD * thd=0x0449fae0, st_table_list * tables=0x044e5028, char if_exists='', char drop_temporary=0x00) Line 122 + 0x19 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0449fae0) Line 3211 + 0x21 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0449fae0, char * inBuf=0x044e4fb8, unsigned int length=0x00000017) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0449fae0, char * packet=0x044a18a1, unsigned int packet_length=0x00000018) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0449fae0) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0449fae0) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04463e98) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044a58e8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 10716 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x044a5b50) Line 802 + 0xf bytes C++ mysqld-debug.exe!wait_for_locked_table_names(THD * thd=0x044a5b50, st_table_list * table_list=0x044ec158) Line 883 + 0x9 bytes C++ mysqld-debug.exe!lock_table_names(THD * thd=0x044a5b50, st_table_list * table_list=0x044ec158) Line 925 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table_part2(THD * thd=0x044a5b50, st_table_list * tables=0x044ec158, int if_exists=0x00000001, int drop_temporary=0x00000000, int dont_log_query=0x00000000) Line 218 + 0x13 bytes C++ mysqld-debug.exe!mysql_rm_table(THD * thd=0x044a5b50, st_table_list * tables=0x044ec158, char if_exists='', char drop_temporary=0x00) Line 122 + 0x19 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x044a5b50) Line 3211 + 0x21 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x044a5b50, char * inBuf=0x044ec0e8, unsigned int length=0x00000017) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x044a5b50, char * packet=0x044a7911, unsigned int packet_length=0x00000018) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x044a5b50) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x044a5b50) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x044ab958) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044ab9a0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 13740 _threadstart pthread_cond_wait Highest 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x009e2368, _RTL_CRITICAL_SECTION * mutex=0x009e25d0) Line 49 C mysqld-debug.exe!wait_for_refresh(THD * thd=0x044abc08) Line 802 + 0xf bytes C++ mysqld-debug.exe!open_table(THD * thd=0x044abc08, const char * db=0x04475c80, const char * table_name=0x044f32d8, const char * alias=0x044f32f8, int * refresh=0x05faee74) Line 959 + 0x9 bytes C++ mysqld-debug.exe!open_tables(THD * thd=0x044abc08, st_table_list * start=0x044f3300, unsigned int * counter=0x05faee9c) Line 1621 + 0x2f bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x044abc08, st_table_list * tables=0x044f3300) Line 1814 + 0x11 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x044abc08) Line 2121 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x044abc08, char * inBuf=0x044f3210, unsigned int length=0x00000022) Line 4460 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x044abc08, char * packet=0x044ad9c9, unsigned int packet_length=0x00000023) Line 1550 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x044abc08) Line 1348 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x044abc08) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x044b1a10) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044b1a58) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes > 12032 _threadstart vio_read Normal 0 ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] mswsock.dll!StartWsdpService() + 0x7a41 bytes ws2_32.dll!WSARecv() + 0x75 bytes wsock32.dll!recv() + 0x31 bytes > mysqld-debug.exe!vio_read(st_vio * vio=0x044a1328, char * buf=0x044fa328, int size=0x00000004) Line 39 + 0x15 bytes C mysqld-debug.exe!my_real_read(st_net * net=0x044e1a98, unsigned long * complen=0x060eff04) Line 696 + 0x18 bytes C++ mysqld-debug.exe!my_net_read(st_net * net=0x044e1a98) Line 870 + 0xd bytes C++ mysqld-debug.exe!do_command(THD * thd=0x044e14c0) Line 1310 + 0x9 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x044e14c0) Line 1074 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04486220) Line 63 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x044a1420) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes mysql> show innodb status\G *************************** 1. row *************************** Status: ===================================== 071030 14:48:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 9 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 6, signal count 6 Mutex spin waits 2, rounds 20, OS waits 1 RW-shared spins 8, OS waits 4; RW-excl spins 1, OS waits 1 ------------ TRANSACTIONS ------------ Trx id counter 0 22120 Purge done for trx's n:o < 0 22120 undo n:o < 0 0 History list length 16 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 14724 MySQL thread id 14, query id 643 127.0.0.1 root show innodb status ---TRANSACTION 0 22047, not started, OS thread id 13220 MySQL thread id 9, query id 605 192.168.250.3 root Waiting for table drop table if exists t1 ---TRANSACTION 0 22105, not started, OS thread id 8456 MySQL thread id 8, query id 610 192.168.250.3 root Waiting for table select * from t1 where id = 22426 ---TRANSACTION 0 22072, not started, OS thread id 8008 MySQL thread id 7, query id 606 192.168.250.3 root Waiting for table drop table if exists t1 ---TRANSACTION 0 22070, not started, OS thread id 8644 MySQL thread id 3, query id 608 192.168.250.3 root Waiting for table select * from t1 where id = 6387 ---TRANSACTION 0 22108, not started, OS thread id 7116 MySQL thread id 5, query id 602 192.168.250.3 root Waiting for tables select * from t1 where id = 13240 ---TRANSACTION 0 22073, not started, OS thread id 10716 MySQL thread id 10, query id 604 192.168.250.3 root Waiting for table drop table if exists t1 ---TRANSACTION 0 22109, not started, OS thread id 4724 MySQL thread id 4, query id 611 192.168.250.3 root Waiting for table select * from t1 where id = 14369 ---TRANSACTION 0 22107, not started, OS thread id 15168 MySQL thread id 6, query id 613 192.168.250.3 root Waiting for table select * from t1 where id = 28811 ---TRANSACTION 0 22104, not started, OS thread id 13740 MySQL thread id 11, query id 609 192.168.250.3 root Waiting for table select * from t1 where id = -12824 ---TRANSACTION 0 22106, not started, OS thread id 1848 MySQL thread id 2, query id 612 192.168.250.3 root Waiting for table select * from t1 where id = -16062 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 96 OS file reads, 108 OS file writes, 87 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 4, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 3436481 Log flushed up to 0 3436481 Last checkpoint at 0 3436481 0 pending log writes, 0 pending chkp writes 87 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 13237690; in additional pool allocated 255872 Buffer pool size 512 Free buffers 488 Database pages 23 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 21, created 2, written 24 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread id 14900, state: waiting for server activity Number of rows inserted 87, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.05 sec) mysql> e:\builds\4.1-win-src\client_debug\mysqld-debug.exe: ready for connections. Version: '4.1.24-debug' socket: '' port: 3306 yes Status information: Current dir: e:\builds\4.1-win-src\data\ Running threads: 11 Stack size: 196608 Current locks: DB Table Version Thread L.thread Open Lock test (null) 0 10 14 0 No lock test t1 1 5 9 0 Low priority read lock test (null) 0 7 11 0 No lock test (null) 0 9 13 0 No lock Current refresh version: 1 Key caches: default Buffer_size: 8388572 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 166 read_next: 0 read_rnd 0 read_first: 0 write: 87 delete 0 update: 0 Table status: Opened tables: 110 Open tables: 4 Open files: 0 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Warning: Not freed memory segments: 217 Warning: Memory that was not free'ed (9046824 bytes):