mysql> show processlist; +------+---------+------+------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+------+------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+ | 2 | root | | test | Query | 424 | setup | alter table `bug` enable keys | | 3 | root | | test | Query | 424 | Waiting for table | alter table `bug` enable keys | | 4 | root | | test | Query | 424 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'Guerin\'s' or `add2` = 'quites' | | 5 | root | | test | Query | 424 | waiting for delay_list | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 6 | root | | test | Query | 424 | setup | alter table `bug_2` disable keys | | 7 | root | | test | Query | 424 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'Guerin\'s' or `add2` = 'quites' | | 8 | root | | test | Query | 424 | waiting for delay_list | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 9 | root | | test | Query | 424 | waiting for delay_list | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 10 | root | | test | Query | 424 | Waiting for tables | alter table `bug` disable keys | | 11 | root | | test | Query | 424 | NULL | select `id`,`name` from `bug` where `add1` = 'partied' or `add2` = 'moggie' | | 12 | root | | test | Query | 424 | Opening table | alter table `bug_2` enable keys | | 13 | root | | test | Query | 424 | Opening tables | select `id`,`name` from `bug` where `add1` = 'stratagem\'s' or `add2` = 'greenhouse' | | 14 | root | | test | Query | 424 | NULL | select `id`,`name` from `bug` where `add1` = 'stratagem\'s' or `add2` = 'greenhouse' | | 15 | root | | test | Query | 424 | waiting for delay_list | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 16 | root | | test | Query | 424 | Waiting for tables | alter table `bug` disable keys | | 17 | root | | test | Query | 424 | waiting for handler lock | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 18 | root | | test | Query | 424 | Opening tables | select `id`,`name` from `bug_2` where `add1` = 'carapace\'s' or `add2` = 'trustily' | | 19 | root | | test | Query | 424 | Opening tables | select `id`,`name` from `bug` where `add1` = 'Malathion\'s' or `add2` = 'destruction\'s' | | 20 | root | | test | Query | 424 | Opening table | alter table `bug` enable keys | | 21 | root | | test | Query | 424 | waiting for delay_list | insert delayed into `bug`(`name`,`add1`,`add2`) values ('magnetoelectricity\'s','creditable','fashio | | 22 | root | | test | Query | 424 | Opening table | alter table `bug_2` enable keys | | 23 | root | | test | Query | 424 | NULL | flush tables | | 24 | root | | test | Query | 424 | Waiting for tables | alter table `bug` disable keys | | 25 | root | | test | Query | 424 | Opening table | alter table `bug` enable keys | | 26 | root | | test | Query | 424 | Opening table | alter table `bug` enable keys | | 1210 | DELAYED | | test | Killed | 424 | Waiting for tables | | | 1211 | DELAYED | | test | Killed | 424 | upgrading lock | | | 1212 | ODBC | | NULL | Killed | 417 | NULL | NULL | | 1213 | root | | test | Query | 0 | NULL | show processlist | +------+---------+------+------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+ 29 rows in set (0.00 sec) mysql> select version(); +---------------------+ | version() | +---------------------+ | 5.0.26-community-nt | +---------------------+ 1 row in set (0.00 sec) ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!pthread_cond_wait+0x32 mysqld_nt!remove_table_from_cache+0x215 mysqld_nt!mysql_rename_table+0x2fe mysqld_nt!mysql_alter_table+0x453 mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120ea98 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!pthread_cond_wait+0x32 mysqld_nt!remove_table_from_cache+0x215 mysqld_nt!mysql_rename_table+0x2fe mysqld_nt!mysql_alter_table+0x453 mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120ea98 ntdll!ZwWaitForSingleObject+0xb KERNEL32!WaitForSingleObjectEx+0x71 KERNEL32!WaitForSingleObject+0xf mysqld_nt!pthread_cond_wait+0x24 mysqld_nt!wait_for_refresh+0x4a mysqld_nt!open_table+0x667 mysqld_nt!open_ltable+0x42 mysqld_nt!mysql_alter_table+0xcd mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x12173d0 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!close_thread_tables+0xf6 mysqld_nt!close_tables_for_reopen+0x9f mysqld_nt!open_tables+0x29e mysqld_nt!open_and_lock_tables+0x1a mysqld_nt!mysql_execute_command+0x2a4 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120ea48 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!select_create::prepare+0x48f mysqld_nt!mysql_insert+0x11e mysqld_nt!mysql_execute_command+0x27db mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x12038c0 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!mysql_alter_table+0x412 mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120fa50 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!close_thread_tables+0xf6 mysqld_nt!close_tables_for_reopen+0x9f mysqld_nt!open_tables+0x29e mysqld_nt!open_and_lock_tables+0x1a mysqld_nt!mysql_execute_command+0x2a4 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120fa30 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!select_create::prepare+0x48f mysqld_nt!mysql_insert+0x11e mysqld_nt!mysql_execute_command+0x27db mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120fa90 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!wait_for_tables+0x1b mysqld_nt!mysql_lock_tables+0x1a2 mysqld_nt!open_ltable+0xe1 mysqld_nt!mysql_alter_table+0xcd mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x120e478 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!close_thread_tables+0xf6 mysqld_nt!close_tables_for_reopen+0x9f mysqld_nt!open_and_lock_tables+0x50 mysqld_nt!mysql_execute_command+0x2a4 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x12037a0 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!open_table+0x3b3 mysqld_nt!open_ltable+0x42 mysqld_nt!mysql_alter_table+0xcd mysqld_nt!mysql_execute_command+0x1a88 mysqld_nt!sql_strmake_with_convert+0x78 mysqld_nt!MYSQLparse+0x31db mysqld_nt!lex_start+0x74 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x1213498 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!open_table+0x3b3 mysqld_nt!open_tables+0x14c mysqld_nt!open_and_lock_tables+0x62 mysqld_nt!mysql_execute_command+0x2a4 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x12170c0 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!close_thread_tables+0xf6 mysqld_nt!close_tables_for_reopen+0x9f mysqld_nt!open_and_lock_tables+0x50 mysqld_nt!mysql_execute_command+0x2a4 mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x1213540 ntdll!ZwWaitForSingleObject+0xb ntdll!RtlpWaitForCriticalSection+0x9e ntdll!RtlEnterCriticalSection+0x46 mysqld_nt!select_create::prepare+0x48f mysqld_nt!mysql_insert+0x11e mysqld_nt!mysql_execute_command+0x27db mysqld_nt!mysql_parse+0x102 mysqld_nt!dispatch_command+0x562 mysqld_nt!do_command+0xad mysqld_nt!handle_one_connection+0x26e mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] WARNING: Frame IP not in any known module. Following frames may be wrong. 0x12164c8 ntdll!ZwWaitForSingleObject+0xb KERNEL32!WaitForSingleObjectEx+0x71 KERNEL32!WaitForSingleObject+0xf mysqld_nt!pthread_cond_wait+0x24 mysqld_nt!thr_lock_data_init+0x10c mysqld_nt!thr_upgrade_write_delay_lock+0xa2 mysqld_nt!delayed_insert::handle_inserts+0x73 mysqld_nt!handle_delayed_insert+0x371 mysqld_nt!pthread_start+0x3b mysqld_nt!_threadstart+0x6c [f:\vs70builds\3077\vc\crtbld\crt\src\thread.c @ 196] KERNEL32!BaseThreadStart+0x52