+------+------+----------------+------+---------+------+---------------------------+--------------------------------- | Id | User | Host | db | Command | Time | State | Info +------+------+----------------+------+---------+------+---------------------------+--------------------------------- | 9 | root | localhost:3292 | | Sleep | 2 | | | 1717 | root | localhost:1037 | | Query | 0 | | show processlist | 2228 | root | localhost:1547 | test | Query | 373 | | SHOW TABLE STATUS | 2316 | root | localhost:1641 | test | Query | 363 | | SHOW TABLE STATUS | 2319 | root | localhost:1639 | test | Query | 362 | | SHOW TABLE STATUS | 2320 | root | localhost:1640 | test | Query | 362 | | SHOW TABLE STATUS | 2326 | root | localhost:1644 | test | Query | 362 | | SHOW TABLE STATUS | 2388 | root | localhost:1708 | test | Query | 355 | | SHOW TABLE STATUS | 2398 | root | localhost:1716 | test | Query | 355 | | SHOW TABLE STATUS | 2480 | root | localhost:1800 | test | Query | 348 | | SHOW TABLE STATUS | 2555 | root | localhost:1876 | test | Query | 338 | | SHOW CREATE TABLE t1 | 2556 | root | localhost:1877 | test | Query | 338 | | SHOW CREATE TABLE t1 | 2571 | root | localhost:1894 | test | Query | 334 | converting HEAP to MyISAM | SELECT x, y, z FROM (SELECT x, y, z FROM t1) as s1 GROUP BY y LIMIT 1 | | 2573 | root | localhost:1892 | test | Query | 334 | converting HEAP to MyISAM | SELECT x, y, z FROM (SELECT x, y, z FROM t1) as s1 GROUP BY y LIMIT 1 | | 2593 | root | localhost:1914 | test | Query | 333 | Opening tables | SELECT i FROM small | 2594 | root | localhost:1915 | test | Query | 333 | closing tables | SELECT i FROM small | 2595 | root | localhost:1916 | test | Query | 333 | Opening tables | SELECT i FROM small +------+------+----------------+------+---------+------+---------------------------+--------------------------------- Quick Watch on LOCK_open variable: ----------------------------------- - LOCK_open {DebugInfo=0x00147ae8 {Type=0x0000 CreatorBackTraceIndex=0x0000 CriticalSection=0x007fb02c struct _RTL_CRITICAL_SECTION LOCK_open ...} LockCount=0xfffffff6 RecursionCount=0x00000001 ...} _RTL_CRITICAL_SECTION + DebugInfo 0x00147ae8 {Type=0x0000 CreatorBackTraceIndex=0x0000 CriticalSection=0x007fb02c struct _RTL_CRITICAL_SECTION LOCK_open ...} _RTL_CRITICAL_SECTION_DEBUG * LockCount 0xfffffff6 long RecursionCount 0x00000001 long OwningThread 0x000009c8 void * <------- thread 2504 below LockSemaphore 0x00004590 void * SpinCount 0x00000000 unsigned long Thread summaries from VS: ------------------------- 3832 main handle_connections_methods Below Normal 0 3156 Win32 Thread KiFastSystemCallRet Highest 0 3916 Win32 Thread KiFastSystemCallRet Highest 0 3936 Win32 Thread KiFastSystemCallRet Highest 0 2272 Win32 Thread KiFastSystemCallRet Highest 0 2116 Win32 Thread KiFastSystemCallRet Highest 0 472 Win32 Thread KiFastSystemCallRet Highest 0 3032 Win32 Thread KiFastSystemCallRet Highest 0 3896 handle_shutdown handle_shutdown Normal 0 3148 handle_manager handle_manager Normal 0 1132 Win32 Thread KiFastSystemCallRet Normal 0 568 handle_one_connection my_real_read Normal 0 > 3400 handle_one_connection my_real_read Normal 0 2920 _open_osfhandle _lock Highest 0 2620 handle_one_connection _alloc_osfhnd Highest 0 2284 handle_one_connection _lock Highest 0 3712 _open_osfhandle _lock Highest 0 3464 _open_osfhandle _lock Highest 0 3348 _open_osfhandle _lock Highest 0 2644 _open_osfhandle _lock Highest 0 2532 _open_osfhandle _lock Highest 0 2816 handle_one_connection _lock Highest 0 3340 _open_osfhandle _lock Highest 0 1376 handle_one_connection create_myisam_tmp_table Highest 0 2784 handle_one_connection _lock Highest 0 2504 handle_one_connection _lock Highest 0 3484 handle_one_connection close_thread_tables Normal 0 3504 handle_one_connection open_table Highest 0 In order, each threads stack is listed below: --------------------------------------------- ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc kernel32.dll!WaitForSingleObject() + 0x12 mysqld.exe!_pthread_cond_wait() + 0x24 C > mysqld.exe!handle_connections_methods() Line 3212 + 0xf C++ mysqld.exe!win_main(int argc=0xe9b24e80, char * * argv=0x0047a62d) Line 3476 C++ mysqld.exe!NTService::IsService(const char * ServiceName=0x00000000) Line 506 + 0x3 C++ mysqld.exe!main(int argc=0x00000001, char * * argv=0x00393090) Line 3688 + 0x13 C++ mysqld.exe!mainCRTStartup() Line 259 + 0x12 C mysqld.exe!mainCRTStartup() Line 150 + 0xc C > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForMultipleObjects() + 0xc kernel32.dll!WaitForMultipleObjects() + 0x18 mysqld.exe!_os_event_wait_multiple() + 0xbb C mysqld.exe!_os_aio_windows_handle() + 0x83 C mysqld.exe!_fil_aio_wait() + 0x3a C mysqld.exe!_srv_parse_log_group_home_dirs() + 0xb6 C kernel32.dll!GetModuleFileNameA() + 0xeb > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForMultipleObjects() + 0xc kernel32.dll!WaitForMultipleObjects() + 0x18 mysqld.exe!_os_event_wait_multiple() + 0xbb C mysqld.exe!_os_aio_windows_handle() + 0x83 C mysqld.exe!_fil_aio_wait() + 0x3a C mysqld.exe!_srv_parse_log_group_home_dirs() + 0xb6 C kernel32.dll!GetModuleFileNameA() + 0xeb > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForMultipleObjects() + 0xc kernel32.dll!WaitForMultipleObjects() + 0x18 mysqld.exe!_os_event_wait_multiple() + 0xbb C mysqld.exe!_os_aio_windows_handle() + 0x83 C mysqld.exe!_fil_aio_wait() + 0x3a C mysqld.exe!_srv_parse_log_group_home_dirs() + 0xb6 C kernel32.dll!GetModuleFileNameA() + 0xeb > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForMultipleObjects() + 0xc kernel32.dll!WaitForMultipleObjects() + 0x18 mysqld.exe!_os_event_wait_multiple() + 0xbb C mysqld.exe!_os_aio_windows_handle() + 0x83 C mysqld.exe!_fil_aio_wait() + 0x3a C mysqld.exe!_srv_parse_log_group_home_dirs() + 0xb6 C kernel32.dll!GetModuleFileNameA() + 0xeb > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtDelayExecution() + 0xc kernel32.dll!Sleep() + 0xf mysqld.exe!_os_thread_sleep() + 0x13 C mysqld.exe!_srv_lock_timeout_and_monitor_thread() + 0x44 C ntdll.dll!NtRegisterThreadTerminatePort() + 0xc > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtDelayExecution() + 0xc kernel32.dll!Sleep() + 0xf mysqld.exe!_os_thread_sleep() + 0x13 C mysqld.exe!_srv_error_monitor_thread() + 0xf9 C kernel32.dll!GetModuleFileNameA() + 0xeb > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc kernel32.dll!WaitForSingleObject() + 0x12 mysqld.exe!_os_event_wait() + 0x61 C mysqld.exe!_srv_master_thread() + 0x8d1 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc kernel32.dll!WaitForSingleObject() + 0x12 > mysqld.exe!handle_shutdown(void * arg=0x00000000) Line 2414 + 0xf C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x00d86660) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc kernel32.dll!WaitForSingleObject() + 0x12 mysqld.exe!_pthread_cond_timedwait() + 0x76 C > mysqld.exe!handle_manager(void * arg=0x00000760) Line 62 + 0x14 C++ 558b51ec() > ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc mswsock.dll!71b23a52() kernel32.dll!CreateRemoteThread() + 0x247 kernel32.dll!CreateThread() + 0x1e 90909090() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc mswsock.dll!StopWsdpService() + 0x67ec ws2_32.dll!WSARecv() + 0x75 wsock32.dll!recv() + 0x31 mysqld.exe!_vio_read() + 0x18 C > mysqld.exe!my_real_read(st_net * net=0x2aaa3a20, unsigned long * complen=0x052dff28) Line 700 + 0x8 C++ mysqld.exe!my_net_read(st_net * net=0x02fc91fc) Line 874 + 0xa C++ mysqld.exe!do_command(THD * thd=0x02fc8948) Line 1476 + 0x9 C++ mysqld.exe!handle_one_connection(void * arg=0x02fc8948) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x02e9c7f8) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc mswsock.dll!StopWsdpService() + 0x67ec ws2_32.dll!WSARecv() + 0x75 wsock32.dll!recv() + 0x31 mysqld.exe!_vio_read() + 0x18 C > mysqld.exe!my_real_read(st_net * net=0x2a6515ee, unsigned long * complen=0x075dff28) Line 700 + 0x8 C++ mysqld.exe!my_net_read(st_net * net=0x0445323c) Line 874 + 0xa C++ mysqld.exe!do_command(THD * thd=0x04452988) Line 1476 + 0x9 C++ mysqld.exe!handle_one_connection(void * arg=0x04452988) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x0319c7d8) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x0000462c, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!vDbgPrintEx() + 0x5f 076deb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_alloc_osfhnd() Line 112 C mysqld.exe!_dup_lk(int fh=0x0000000a) Line 104 + 0x5 C mysqld.exe!_dup(int fh=0x0000000a) Line 74 + 0x6 C mysqld.exe!innobase_mysql_tmpfile() Line 738 + 0x6 C++ mysqld.exe!_os_file_create_tmpfile() + 0x9 C mysqld.exe!ha_innobase::update_table_comment(const char * comment=0x02fbd8f0) Line 5755 + 0x5 C++ mysqld.exe!get_schema_tables_record(THD * thd=0x00dc5d60, st_table_list * tables=0x02e1f328, st_table * table=0x031ce048, int res=0x00000000, const char * base_name=0x00dad0a8, const char * file_name=0x02e1f318) Line 2466 + 0x16 C++ mysqld.exe!get_all_tables(THD * thd=0x00dc5d60, st_table_list * tables=0x02efe800, Item * cond=0x00000000) Line 2205 C++ mysqld.exe!get_schema_tables_result(JOIN * join=0x00000000) Line 3836 + 0xc C++ mysqld.exe!JOIN::exec() Line 1293 + 0x30 C++ mysqld.exe!mysql_select(THD * thd=0x00dc5d60, Item * * * rref_pointer_array=0x00dc6140, st_table_list * tables=0x02efe800, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x00000000, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=0xa0844a00, select_result * result=0x02eff7b0, st_select_lex_unit * unit=0x00dc5db8, st_select_lex * select_lex=0x00dc6018) Line 1852 C++ mysqld.exe!handle_select(THD * thd=0x00dc5d60, st_lex * lex=0x00dc5da0, select_result * result=0x02eff7b0, unsigned long setup_tables_done_option=0x00000000) Line 250 + 0x68 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2492 C++ mysqld.exe!mysql_parse(THD * thd=0x00dc5d60, char * inBuf=0x02efdc58, unsigned int length=0x00000011) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x00dc5d60, char * packet=0x0387cc19, unsigned int packet_length=0x00000012) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x00dc5d60) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x00dc5d60) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x02fc2758) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_dup_lk(int fh=0x0000000b) Line 104 + 0x5 C mysqld.exe!_dup(int fh=0x0000000b) Line 74 + 0x6 C mysqld.exe!innobase_mysql_tmpfile() Line 738 + 0x6 C++ mysqld.exe!_os_file_create_tmpfile() + 0x9 C mysqld.exe!ha_innobase::update_table_comment(const char * comment=0x04a03dd8) Line 5755 + 0x5 C++ mysqld.exe!get_schema_tables_record(THD * thd=0x02fc27f0, st_table_list * tables=0x02ece228, st_table * table=0x031c1018, int res=0x00000000, const char * base_name=0x02ead888, const char * file_name=0x02ece218) Line 2466 + 0x16 C++ mysqld.exe!get_all_tables(THD * thd=0x02fc27f0, st_table_list * tables=0x02fbaae0, Item * cond=0x00000000) Line 2205 C++ mysqld.exe!get_schema_tables_result(JOIN * join=0x00000000) Line 3836 + 0xc C++ mysqld.exe!JOIN::exec() Line 1293 + 0x30 C++ mysqld.exe!mysql_select(THD * thd=0x02fc27f0, Item * * * rref_pointer_array=0x02fc2bd0, st_table_list * tables=0x02fbaae0, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x00000000, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=0xa0844a00, select_result * result=0x02fbba90, st_select_lex_unit * unit=0x02fc2848, st_select_lex * select_lex=0x02fc2aa8) Line 1852 C++ mysqld.exe!handle_select(THD * thd=0x02fc27f0, st_lex * lex=0x02fc2830, select_result * result=0x02fbba90, unsigned long setup_tables_done_option=0x00000000) Line 250 + 0x68 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2492 C++ mysqld.exe!mysql_parse(THD * thd=0x02fc27f0, char * inBuf=0x02fb9f38, unsigned int length=0x00000011) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02fc27f0, char * packet=0x0302cf59, unsigned int packet_length=0x00000012) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x02fc27f0) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x02fc27f0) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x00daa528) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x000046bc, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!vDbgPrintEx() + 0x5f 03ddeb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x00004500, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!RtlFindActivationContextSectionGuid() + 0xab4 077deb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x0000459c, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!RtlFindActivationContextSectionGuid() + 0xab4 054deb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x00004518, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!vDbgPrintEx() + 0x5f 078deb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x00004614, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!RtlFindActivationContextSectionGuid() + 0x2d5 ntdll.dll!vDbgPrintEx() + 0x5f 050deb04() ntdll.dll!RtlAllocateHeap() + 0x6c9 ntdll.dll!RtlFreeHeap() + 0x142 ffffffff() ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x000045a8, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_mem_pool_create() + 0x1b0 C mysqld.exe!_heap_alloc(unsigned int size=0x00000140) Line 212 + 0x5 C mysqld.exe!_ut_malloc() + 0xe C mysqld.exe!_mem_area_alloc() + 0x11d C mysqld.exe!_mem_heap_create_block() + 0xab C mysqld.exe!_trx_create() + 0x249 C mysqld.exe!_trx_allocate_for_mysql() + 0x51 C mysqld.exe!_os_file_create_tmpfile() + 0x9 C mysqld.exe!ha_innobase::get_foreign_key_create_info() Line 5818 + 0x5 C++ mysqld.exe!store_create_info(THD * thd=0x02df0ff0, st_table_list * table_list=0x02de0cc8, String * packet=0x051deac8) Line 974 + 0xe C++ mysqld.exe!mysqld_show_create(THD * thd=0x02df0ff0, st_table_list * table_list=0x02de0cc8) Line 392 + 0x27 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 3100 + 0xb C++ mysqld.exe!mysql_parse(THD * thd=0x02df0ff0, char * inBuf=0x02de0c50, unsigned int length=0x00000014) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02df0ff0, char * packet=0x02e17fa9, unsigned int packet_length=0x00000015) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x02df0ff0) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x02df0ff0) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x02decd08) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x000046a8, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_create_temp_file() + 0xd0 C mysqld.exe!_my_tmpdir() + 0x2a C ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda mysqld.exe!_mi_create() + 0x77 C > mysqld.exe!create_myisam_tmp_table(st_table * table=0x04edec08, TMP_TABLE_PARAM * param=0x032515b4, unsigned long options=0x80844a00) Line 9075 + 0x3a C++ mysqld.exe!create_myisam_from_heap(THD * thd=0x00000000, st_table * table=0x00000004, TMP_TABLE_PARAM * param=0x00000000, int error=0x04edebe8, int ignore_last_dupp_key_error=0x00000004) Line 9159 + 0x2f C++ mysqld.exe!select_union::send_data(List & values={...}) Line 69 + 0x20 C++ mysqld.exe!end_send(JOIN * join=0x03076868, st_join_table * join_tab=0x03251b98, int end_of_records=0x00000000) Line 10373 C++ mysqld.exe!evaluate_join_record(JOIN * join=0x00000001, st_join_table * join_tab=0x00070023, int error=0x000000d2, char * report_error=0x02eb866c) Line 9697 + 0xd C++ mysqld.exe!sub_select(JOIN * join=0x03076868, st_join_table * join_tab=0x03251a10, int end_of_records=0x00000000) Line 9588 + 0x9 C++ mysqld.exe!do_select(JOIN * join=0x00000000, List * fields=0x032508d4, st_table * table=0x0000002e, Procedure * procedure=0x00000000) Line 9345 + 0x9 C++ mysqld.exe!JOIN::exec() Line 1687 C++ mysqld.exe!mysql_select(THD * thd=0x02eb7b50, Item * * * rref_pointer_array=0x03250970, st_table_list * tables=0x03250ea0, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x00000000, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=0x90844a00, select_result * result=0x032515a8, st_select_lex_unit * unit=0x032509c0, st_select_lex * select_lex=0x03250848) Line 1852 C++ mysqld.exe!mysql_derived_filling(THD * thd=0x02eb7b50, st_lex * lex=0x02eb7b90, st_table_list * orig_table_list=0x02eb7e08) Line 267 + 0x63 C++ mysqld.exe!mysql_handle_derived(st_lex * lex=0x02eb7b90, int (THD *, st_lex *, st_table_list *)* processor=0x004c86f0) Line 57 + 0xd C++ mysqld.exe!open_and_lock_tables(THD * thd=0x02eb7b50, st_table_list * tables=0x03251288) Line 2330 + 0x45 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2458 + 0xb C++ mysqld.exe!mysql_parse(THD * thd=0x02eb7b50, char * inBuf=0x03250378, unsigned int length=0x00000048) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02eb7b50, char * packet=0x030388d1, unsigned int packet_length=0x00000049) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x02eb7b50) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x02eb7b50) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x00dae100) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x000044dc, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_create() + 0x1c C mysqld.exe!_my_create_with_symlink() + 0x126 C mysqld.exe!_mi_create() + 0xe37 C mysqld.exe!create_myisam_tmp_table(st_table * table=0x079dec08, TMP_TABLE_PARAM * param=0x03065254, unsigned long options=0x80844a00) Line 9075 + 0x3a C++ mysqld.exe!create_myisam_from_heap(THD * thd=0x00000000, st_table * table=0x00000004, TMP_TABLE_PARAM * param=0x00000000, int error=0x00000001, int ignore_last_dupp_key_error=0x007f8108) Line 9159 + 0x2f C++ mysqld.exe!select_union::send_data(List & values={...}) Line 69 + 0x20 C++ mysqld.exe!end_send(JOIN * join=0x0434a408, st_join_table * join_tab=0x03065838, int end_of_records=0x00000000) Line 10373 C++ mysqld.exe!evaluate_join_record(JOIN * join=0x00000001, st_join_table * join_tab=0x00070023, int error=0x000000d2, char * report_error=0x05560574) Line 9697 + 0xd C++ mysqld.exe!sub_select(JOIN * join=0x0434a408, st_join_table * join_tab=0x030656b0, int end_of_records=0x00000000) Line 9588 + 0x9 C++ mysqld.exe!do_select(JOIN * join=0x00000000, List * fields=0x03064574, st_table * table=0x00000010, Procedure * procedure=0x00000000) Line 9345 + 0x9 C++ mysqld.exe!JOIN::exec() Line 1687 C++ mysqld.exe!mysql_select(THD * thd=0x0555fa58, Item * * * rref_pointer_array=0x03064610, st_table_list * tables=0x03064b40, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x00000000, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=0x90844a00, select_result * result=0x03065248, st_select_lex_unit * unit=0x03064660, st_select_lex * select_lex=0x030644e8) Line 1852 C++ mysqld.exe!mysql_derived_filling(THD * thd=0x0555fa58, st_lex * lex=0x0555fa98, st_table_list * orig_table_list=0x0555fd10) Line 267 + 0x63 C++ mysqld.exe!mysql_handle_derived(st_lex * lex=0x0555fa98, int (THD *, st_lex *, st_table_list *)* processor=0x004c86f0) Line 57 + 0xd C++ mysqld.exe!open_and_lock_tables(THD * thd=0x0555fa58, st_table_list * tables=0x03064f28) Line 2330 + 0x45 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2458 + 0xb C++ mysqld.exe!mysql_parse(THD * thd=0x0555fa58, char * inBuf=0x03064018, unsigned int length=0x00000048) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0555fa58, char * packet=0x02f654a1, unsigned int packet_length=0x00000049) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x0555fa58) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x0555fa58) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x00ddd5d0) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!_lock(int locknum=0x0000000b) Line 319 + 0x8 C mysqld.exe!_alloc_osfhnd() Line 59 + 0x7 C mysqld.exe!_open_osfhandle(int osfhandle=0x000046dc, int flags=0x00000000) Line 375 + 0x5 C mysqld.exe!_my_sopen() + 0x22c C mysqld.exe!_my_open() + 0x6c C mysqld.exe!openfrm(THD * thd=0x05722a30, const char * name=0x04fde818, const char * alias=0x05e15f08, unsigned int db_stat=0x00002027, unsigned int prgflag=0x0000002c, unsigned int ha_open_flags=0x00000000, st_table * outparam=0x055a0a68) Line 106 + 0x6b C++ mysqld.exe!open_unireg_entry(THD * thd=0x00004478, st_table * entry=0x00000000, const char * db=0x00000004, const char * name=0x00000000, const char * alias=0x00000003, st_table_list * table_desc=0x007f8108, st_mem_root * mem_root=0x00000004) Line 1768 + 0x24 C++ mysqld.exe!open_table(THD * thd=0x05722a30, st_table_list * table_list=0x05e15f10, st_mem_root * mem_root=0x04fdf2b0, int * refresh=0x04fdf2ac, unsigned int flags=0x00000000) Line 1307 + 0x25 C++ mysqld.exe!open_tables(THD * thd=0x00000000, st_table_list * * start=0x04fdf2fc, unsigned int * counter=0x04fdf2ec, unsigned int flags=0x00000000) Line 2025 + 0x1b C++ mysqld.exe!open_and_lock_tables(THD * thd=0x05722a30, st_table_list * tables=0x05e15f10) Line 2320 + 0x17 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2458 + 0xb C++ mysqld.exe!mysql_parse(THD * thd=0x05722a30, char * inBuf=0x05e15dd8, unsigned int length=0x00000013) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x05722a30, char * packet=0x02ee2e59, unsigned int packet_length=0x00000014) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x05722a30) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x05722a30) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x03216ec0) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!close_thread_tables(THD * thd=0x00000000, int lock_in_use=0x00000000, int skip_derived=0x00000000) Line 512 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x03329b08, char * packet=0x0305fff9, unsigned int packet_length=0x00000014) Line 2065 + 0x12 C++ mysqld.exe!do_command(THD * thd=0x03329b08) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x03329b08) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x02deef20) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb ntdll.dll!KiFastSystemCallRet() ntdll.dll!NtWaitForSingleObject() + 0xc ntdll.dll!RtlAddressInSectionTable() + 0xda > mysqld.exe!open_table(THD * thd=0x02f47be0, st_table_list * table_list=0x05a5f8d8, st_mem_root * mem_root=0x07bdf2b0, int * refresh=0x07bdf2ac, unsigned int flags=0x00000000) Line 1232 C++ mysqld.exe!open_tables(THD * thd=0x00000000, st_table_list * * start=0x07bdf2fc, unsigned int * counter=0x07bdf2ec, unsigned int flags=0x00000000) Line 2025 + 0x1b C++ mysqld.exe!open_and_lock_tables(THD * thd=0x02f47be0, st_table_list * tables=0x05a5f8d8) Line 2320 + 0x17 C++ mysqld.exe!mysql_execute_command(THD * thd=0x00000000) Line 2458 + 0xb C++ mysqld.exe!mysql_parse(THD * thd=0x02f47be0, char * inBuf=0x05a5f7a0, unsigned int length=0x00000013) Line 5621 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02f47be0, char * packet=0x06b0d009, unsigned int packet_length=0x00000014) Line 1712 C++ mysqld.exe!do_command(THD * thd=0x02f47be0) Line 1511 + 0xd C++ mysqld.exe!handle_one_connection(void * arg=0x02f47be0) Line 1155 + 0xa C++ mysqld.exe!_pthread_start() + 0x3b C mysqld.exe!_threadstart(void * ptd=0x04138f70) Line 196 + 0x6 C kernel32.dll!GetModuleFileNameA() + 0xeb