mysql> show processlist;
+----+------+-----------+------+---------+------+-------------------+---------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------------------+---------------------------------------+
| 3 | root | localhost | test | Sleep | 12 | | NULL |
| 4 | root | localhost | test | Query | 343 | Waiting for table | insert into `t1` values (1) |
| 5 | root | localhost | test | Query | 343 | Opening tables | insert into `t1` values (1) |
| 6 | root | localhost | test | Query | 343 | Waiting for table | insert into `t1` values (1) |
| 7 | root | localhost | test | Query | 343 | Waiting for table | alter table `t1` coalesce partition 1 |
| 8 | root | localhost | test | Query | 343 | Waiting for table | insert into `t1` values (1) |
| 9 | root | localhost | test | Query | 0 | NULL | show processlist |
+----+------+-----------+------+---------+------+-------------------+---------------------------------------+
7 rows in set (0.03 sec)
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.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, timespec * abstime=0x00000000) Line 124 + 0x17 bytes C
mysqld.exe!pthread_cond_wait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0) Line 71 + 0xf bytes C
mysqld.exe!wait_for_condition(THD * thd=0x02c86940, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, pthread_cond_t * cond=0x00e2d2e4) Line 1970 + 0xd bytes C++
mysqld.exe!open_table(THD * thd=0x02c86940, TABLE_LIST * table_list=0x02c9a200, st_mem_root * mem_root=0x0568e1d8, int * refresh=0x0568e204, unsigned int flags=0x00000000) Line 2608 + 0x13 bytes C++
mysqld.exe!open_tables(THD * thd=0x02c86940, TABLE_LIST * * start=0x0568e28c, unsigned int * counter=0x0568e278, unsigned int flags=0x00000000) Line 3653 + 0x20 bytes C++
mysqld.exe!open_and_lock_tables(THD * thd=0x02c86940, TABLE_LIST * tables=0x02c9a200) Line 3950 + 0x13 bytes C++
mysqld.exe!mysql_insert(THD * thd=0x02c86940, TABLE_LIST * table_list=0x02c9a200, List<Item> & fields={...}, List<List<Item> > & values_list={...}, List<Item> & update_fields={...}, List<Item> & update_values={...}, enum_duplicates duplic=DUP_ERROR, int ignore=0x00000000) Line 609 + 0xd bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x02c86940) Line 2761 + 0x47 bytes C++
mysqld.exe!mysql_parse(THD * thd=0x02c86940, const char * inBuf=0x02c9a148, unsigned int length=0x0000001b, const char * * found_semicolon=0x0568fcf8) Line 5484 + 0x9 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02c86940, char * packet=0x02c92099, unsigned int packet_length=0x0000001b) Line 987 + 0x1e bytes C++
mysqld.exe!do_command(THD * thd=0x02c86940) Line 725 + 0x34 bytes C++
mysqld.exe!handle_one_connection(void * arg=0x02c86940) Line 1133 + 0x9 bytes C++
mysqld.exe!pthread_start(void * param=0x02c34e10) Line 85 + 0x9 bytes C
mysqld.exe!_callthreadstart() Line 293 + 0xf bytes C
mysqld.exe!_threadstart(void * ptd=0x02c678c8) Line 277 C
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.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, timespec * abstime=0x00000000) Line 124 + 0x17 bytes C
mysqld.exe!pthread_cond_wait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0) Line 71 + 0xf bytes C
mysqld.exe!wait_for_condition(THD * thd=0x02c84398, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, pthread_cond_t * cond=0x00e2d2e4) Line 1970 + 0xd bytes C++
mysqld.exe!open_table(THD * thd=0x02c84398, TABLE_LIST * table_list=0x02c8a128, st_mem_root * mem_root=0x02c85ae0, int * refresh=0x0554cf98, unsigned int flags=0x00000000) Line 2608 + 0x13 bytes C++
mysqld.exe!open_ltable(THD * thd=0x02c84398, TABLE_LIST * table_list=0x02c8a128, thr_lock_type lock_type=TL_WRITE_ALLOW_READ, unsigned int lock_flags=0x00000000) Line 3861 + 0x1a bytes C++
mysqld.exe!mysql_alter_table(THD * thd=0x02c84398, char * new_db=0x02c8a330, char * new_name=0x00000000, st_ha_create_information * create_info=0x0554ef64, TABLE_LIST * table_list=0x02c8a128, Alter_info * alter_info=0x0554ef04, unsigned int order_num=0x00000000, st_order * order=0x00000000, int ignore=0x00000000) Line 5837 + 0x11 bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x02c84398) Line 2497 + 0x4a bytes C++
mysqld.exe!mysql_parse(THD * thd=0x02c84398, const char * inBuf=0x02c8a058, unsigned int length=0x00000025, const char * * found_semicolon=0x0554fcf8) Line 5484 + 0x9 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02c84398, char * packet=0x02c7b209, unsigned int packet_length=0x00000025) Line 987 + 0x1e bytes C++
mysqld.exe!do_command(THD * thd=0x02c84398) Line 725 + 0x34 bytes C++
mysqld.exe!handle_one_connection(void * arg=0x02c84398) Line 1133 + 0x9 bytes C++
mysqld.exe!pthread_start(void * param=0x02c69608) Line 85 + 0x9 bytes C
mysqld.exe!_callthreadstart() Line 293 + 0xf bytes C
mysqld.exe!_threadstart(void * ptd=0x02c6db58) Line 277 C
kernel32.dll!FlsSetValue() + 0x136 bytes
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.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, timespec * abstime=0x00000000) Line 124 + 0x17 bytes C
mysqld.exe!pthread_cond_wait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0) Line 71 + 0xf bytes C
mysqld.exe!wait_for_condition(THD * thd=0x02c69928, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, pthread_cond_t * cond=0x00e2d2e4) Line 1970 + 0xd bytes C++
mysqld.exe!open_table(THD * thd=0x02c69928, TABLE_LIST * table_list=0x02c6b5f8, st_mem_root * mem_root=0x0540e1d8, int * refresh=0x0540e204, unsigned int flags=0x00000000) Line 2608 + 0x13 bytes C++
mysqld.exe!open_tables(THD * thd=0x02c69928, TABLE_LIST * * start=0x0540e28c, unsigned int * counter=0x0540e278, unsigned int flags=0x00000000) Line 3653 + 0x20 bytes C++
mysqld.exe!open_and_lock_tables(THD * thd=0x02c69928, TABLE_LIST * tables=0x02c6b5f8) Line 3950 + 0x13 bytes C++
mysqld.exe!mysql_insert(THD * thd=0x02c69928, TABLE_LIST * table_list=0x02c6b5f8, List<Item> & fields={...}, List<List<Item> > & values_list={...}, List<Item> & update_fields={...}, List<Item> & update_values={...}, enum_duplicates duplic=DUP_ERROR, int ignore=0x00000000) Line 609 + 0xd bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x02c69928) Line 2761 + 0x47 bytes C++
mysqld.exe!mysql_parse(THD * thd=0x02c69928, const char * inBuf=0x02c6b540, unsigned int length=0x0000001b, const char * * found_semicolon=0x0540fcf8) Line 5484 + 0x9 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02c69928, char * packet=0x02c76e19, unsigned int packet_length=0x0000001b) Line 987 + 0x1e bytes C++
mysqld.exe!do_command(THD * thd=0x02c69928) Line 725 + 0x34 bytes C++
mysqld.exe!handle_one_connection(void * arg=0x02c69928) Line 1133 + 0x9 bytes C++
mysqld.exe!pthread_start(void * param=0x02c34e10) Line 85 + 0x9 bytes C
mysqld.exe!_callthreadstart() Line 293 + 0xf bytes C
mysqld.exe!_threadstart(void * ptd=0x02c7ae50) Line 277 C
kernel32.dll!FlsSetValue() + 0x136 bytes
> mysqld.exe!open_tables(THD * thd=0x02c51540, TABLE_LIST * * start=0x052ce28c, unsigned int * counter=0x052ce278, unsigned int flags=0x00000000) Line 3653 + 0x23 bytes C++
mysqld.exe!open_and_lock_tables(THD * thd=0x02c51540, TABLE_LIST * tables=0x02c6e1d0) Line 3950 + 0x13 bytes C++
mysqld.exe!mysql_insert(THD * thd=0x02c51540, TABLE_LIST * table_list=0x02c6e1d0, List<Item> & fields={...}, List<List<Item> > & values_list={...}, List<Item> & update_fields={...}, List<Item> & update_values={...}, enum_duplicates duplic=DUP_ERROR, int ignore=0x00000000) Line 609 + 0xd bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x02c51540) Line 2761 + 0x47 bytes C++
mysqld.exe!mysql_parse(THD * thd=0x02c51540, const char * inBuf=0x02c6e118, unsigned int length=0x0000001b, const char * * found_semicolon=0x052cfcf8) Line 5484 + 0x9 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02c51540, char * packet=0x02c5f029, unsigned int packet_length=0x0000001b) Line 987 + 0x1e bytes C++
mysqld.exe!do_command(THD * thd=0x02c51540) Line 725 + 0x34 bytes C++
mysqld.exe!handle_one_connection(void * arg=0x02c51540) Line 1133 + 0x9 bytes C++
mysqld.exe!pthread_start(void * param=0x02c300b8) Line 85 + 0x9 bytes C
mysqld.exe!_callthreadstart() Line 293 + 0xf bytes C
mysqld.exe!_threadstart(void * ptd=0x02c67ef8) Line 277 C
kernel32.dll!FlsSetValue() + 0x136 bytes
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.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, timespec * abstime=0x00000000) Line 124 + 0x17 bytes C
mysqld.exe!pthread_cond_wait(pthread_cond_t * cond=0x00e2d2e4, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0) Line 71 + 0xf bytes C
mysqld.exe!wait_for_condition(THD * thd=0x02c590e8, _RTL_CRITICAL_SECTION * mutex=0x00e2d7b0, pthread_cond_t * cond=0x00e2d2e4) Line 1970 + 0xd bytes C++
mysqld.exe!open_table(THD * thd=0x02c590e8, TABLE_LIST * table_list=0x02c4ec68, st_mem_root * mem_root=0x0518e1d8, int * refresh=0x0518e204, unsigned int flags=0x00000000) Line 2608 + 0x13 bytes C++
mysqld.exe!open_tables(THD * thd=0x02c590e8, TABLE_LIST * * start=0x0518e28c, unsigned int * counter=0x0518e278, unsigned int flags=0x00000000) Line 3653 + 0x20 bytes C++
mysqld.exe!open_and_lock_tables(THD * thd=0x02c590e8, TABLE_LIST * tables=0x02c4ec68) Line 3950 + 0x13 bytes C++
mysqld.exe!mysql_insert(THD * thd=0x02c590e8, TABLE_LIST * table_list=0x02c4ec68, List<Item> & fields={...}, List<List<Item> > & values_list={...}, List<Item> & update_fields={...}, List<Item> & update_values={...}, enum_duplicates duplic=DUP_ERROR, int ignore=0x00000000) Line 609 + 0xd bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x02c590e8) Line 2761 + 0x47 bytes C++
mysqld.exe!mysql_parse(THD * thd=0x02c590e8, const char * inBuf=0x02c4ebb0, unsigned int length=0x0000001b, const char * * found_semicolon=0x0518fcf8) Line 5484 + 0x9 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02c590e8, char * packet=0x02c5afd9, unsigned int packet_length=0x0000001b) Line 987 + 0x1e bytes C++
mysqld.exe!do_command(THD * thd=0x02c590e8) Line 725 + 0x34 bytes C++
mysqld.exe!handle_one_connection(void * arg=0x02c590e8) Line 1133 + 0x9 bytes C++
mysqld.exe!pthread_start(void * param=0x02c300b8) Line 85 + 0x9 bytes C
mysqld.exe!_callthreadstart() Line 293 + 0xf bytes C
mysqld.exe!_threadstart(void * ptd=0x02c4e6e8) Line 277 C
kernel32.dll!FlsSetValue() + 0x136 bytes