mysql> show innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 100812 8:07:53 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 8 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 715 1_second, 715 sleeps, 70 10_second, 27 background, 27 flush srv_master_thread log flush and writes: 725 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4522, signal count 4237 --Thread 6444 has waited at .\fsp\fsp0fsp.c line 2435 for 88.00 seconds the semaphore: X-lock on RW-latch at 031098EC created in file .\fil\fil0fil.c line 1231 a writer (thread id 4164) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: fff00000 Last time read locked in file not yet reserved line 0 Last time write locked in file .\fsp\fsp0fsp.c line 3003 --Thread 6692 has waited at G:\mysql-5.1.49-winbuild\mysql-advanced-gpl-5.1.49-build\storage\innodb_plugin\include\btr0btr.ic line 53 for 88.00 seconds the semaphore: X-lock on RW-latch at 03110984 created in file .\buf\buf0buf.c line 682 a writer (thread id 6444) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file G:\mysql-5.1.49-winbuild\mysql-advanced-gpl-5.1.49-build\storage\innodb_plugin\include\btr0btr.ic line 53 Last time write locked in file G:\mysql-5.1.49-winbuild\mysql-advanced-gpl-5.1.49-build\storage\innodb_plugin\include\btr0btr.ic line 53 --Thread 4164 has waited at .\fsp\fsp0fsp.c line 1672 for 88.00 seconds the semaphore: X-lock on RW-latch at 03110984 created in file .\buf\buf0buf.c line 682 a writer (thread id 6444) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file G:\mysql-5.1.49-winbuild\mysql-advanced-gpl-5.1.49-build\storage\innodb_plugin\include\btr0btr.ic line 53 Last time write locked in file G:\mysql-5.1.49-winbuild\mysql-advanced-gpl-5.1.49-build\storage\innodb_plugin\include\btr0btr.ic line 53 --Thread 3568 has waited at .\row\row0purge.c line 552 for 87.00 seconds the semaphore: S-lock on RW-latch at 1012BB00 created in file .\dict\dict0dict.c line 665 a writer (thread id 4164) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file .\row\row0undo.c line 300 Last time write locked in file .\row\row0mysql.c line 2690 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 298, OS waits 282; RW-excl spins 3442, OS waits 3005 Spin rounds per wait: 0.00 mutex, 31.21 RW-shared, 36.96 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 100812 7:47:29 *** (1) TRANSACTION: TRANSACTION 14BE3, ACTIVE 0 sec, OS thread id 880 fetching rows mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320, 21 row lock(s), undo log entries 20 MySQL thread id 32, query id 39390 192.168.1.100 root Updating update t2 set b='' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 59 n bits 96 index `GEN_CLUST_INDEX` of table `test`.`t2` trx id 14BE3 lock_mode X waiting Record lock, heap no 23 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 6; hex 00000000278a; asc ' ;; 1: len 6; hex 000000014be4; asc K ;; 2: len 7; hex 8000000a0b0110; asc ;; 3: SQL NULL; 4: len 30; hex 0a323820696f48653470524b794275346644515a4652356967544f552051; asc 28 ioHe4pRKyBu4fDQZFR5igTOU Q; (total 192 bytes); 5: len 4; hex 0bdd7c60; asc |`;; *** (2) TRANSACTION: TRANSACTION 14BE4, ACTIVE 0 sec, OS thread id 4208 starting index read mysql tables in use 1, locked 1 5 lock struct(s), heap size 320, 4 row lock(s), undo log entries 1 MySQL thread id 36, query id 39416 192.168.1.100 root Updating update t2 set b='' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 59 n bits 96 index `GEN_CLUST_INDEX` of table `test`.`t2` trx id 14BE4 lock_mode X locks rec but not gap Record lock, heap no 23 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 6; hex 00000000278a; asc ' ;; 1: len 6; hex 000000014be4; asc K ;; 2: len 7; hex 8000000a0b0110; asc ;; 3: SQL NULL; 4: len 30; hex 0a323820696f48653470524b794275346644515a4652356967544f552051; asc 28 ioHe4pRKyBu4fDQZFR5igTOU Q; (total 192 bytes); 5: len 4; hex 0bdd7c60; asc |`;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 59 n bits 96 index `GEN_CLUST_INDEX` of table `test`.`t2` trx id 14BE4 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 6; hex 00000000276d; asc 'm;; 1: len 6; hex 000000014be3; asc K ;; 2: len 7; hex 00000000350d3f; asc 5 ?;; 3: SQL NULL; 4: len 0; hex ; asc ;; 5: len 4; hex 29ef767d; asc ) v};; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 19AC0 Purge done for trx's n:o < 196C5 undo n:o < 1 History list length 318 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 19AA1, not started, OS thread id 6692 updating table statistics MySQL thread id 66, query id 58582 192.168.1.100 root show keys from t1 ---TRANSACTION 19AA7, not started, OS thread id 6640 mysql tables in use 1, locked 1 MySQL thread id 65, query id 58580 192.168.1.100 root After create alter table t2 engine=innodb ---TRANSACTION 19A70, not started, OS thread id 6444 updating table statistics MySQL thread id 63, query id 58581 192.168.1.100 root show keys from t1 ---TRANSACTION 0, not started, OS thread id 5848 MySQL thread id 61, query id 58596 127.0.0.1 root show innodb status ---TRANSACTION 19ABF, ACTIVE 88 sec, OS thread id 4164 truncating table mysql tables in use 1, locked 1 MySQL thread id 67, query id 58583 192.168.1.100 root init truncate t1 -------- 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 (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (write thread) I/O thread 7 state: wait Windows aio (write thread) I/O thread 8 state: wait Windows aio (write thread) I/O thread 9 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 329 OS file reads, 36642 OS file writes, 25810 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: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 553253, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 452442087 Log flushed up to 452442087 Last checkpoint at 445434217 0 pending log writes, 0 pending chkp writes 24680 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 136577024; in additional pool allocated 0 Dictionary memory allocated 48700 Buffer pool size 8192 Free buffers 6017 Database pages 2173 Old database pages 782 Modified db pages 208 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 9, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 318, created 1855, written 11347 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 2173, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB 2 tablespace extents now reserved for B-tree split operations Main thread id 3568, state: purging Number of rows inserted 10788, updated 18423, deleted 0, read 116091 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.00 sec) mysql> show full processlist; +----+------+------+------+---------+------+--------------+------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+------+------+---------+------+--------------+------------------------------+ | 61 | root | | test | Query | 0 | NULL | show full processlist | | 63 | root | | test | Query | 117 | NULL | show keys from t1 | | 64 | root | | test | Sleep | 0 | | NULL | | 65 | root | | test | Query | 117 | After create | alter table t2 engine=innodb | | 66 | root | | test | Query | 117 | NULL | show keys from t1 | | 67 | root | | test | Query | 117 | init | truncate t1 | +----+------+------+------+---------+------+--------------+------------------------------+ 6 rows in set (0.00 sec) Stack traces : ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes kernel32.dll!_WaitForSingleObjectEx@12() + 0x88 bytes kernel32.dll!_WaitForSingleObject@8() + 0x12 bytes > ha_innodb_plugin.dll!os_event_wait_low(os_event_struct * event=0x03025e50, __int64 reset_sig_count=0x0000000000000000) Line 368 C ha_innodb_plugin.dll!sync_array_wait_event(sync_array_struct * arr=0x02e029b8, unsigned long index=0x00000002) Line 453 C ha_innodb_plugin.dll!rw_lock_x_lock_func(rw_lock_struct * lock=0x03110984, unsigned long pass=0x00000000, const char * file_name=0x100ffd3c, unsigned long line=0x00000688) Line 680 + 0x2b bytes C ha_innodb_plugin.dll!buf_page_get_gen(unsigned long space=0x00000000, unsigned long zip_size=0x00000000, unsigned long offset=0x0000002d, unsigned long rw_latch=0x00000002, buf_block_struct * guess=0x00000000, unsigned long mode=0x0000000a, const char * file=0x100ffd3c, unsigned long line=0x00000688, mtr_struct * mtr=0x0e0fe008) Line 2347 C ha_innodb_plugin.dll!fsp_alloc_free_page(unsigned long space=0x00000000, unsigned long zip_size=0x00000000, unsigned long hint=0x00000000, mtr_struct * mtr=0x00000000) Line 1676 C ha_innodb_plugin.dll!fseg_alloc_free_page_low(unsigned long space=0x00000000, unsigned long zip_size=0x00000000, unsigned char * seg_inode=0x033a0032, unsigned long hint=0x00000000, unsigned char direction='o', mtr_struct * mtr=0x0e0fe008) Line 2713 + 0xf bytes C ha_innodb_plugin.dll!fseg_create_general(unsigned long space=0x00000000, unsigned long page=0x00000000, unsigned long byte_offset=0x00000054, unsigned long has_done_reservation=0x00000000, mtr_struct * mtr=0x0e0fe008) Line 2326 + 0x11 bytes C ha_innodb_plugin.dll!fseg_create(unsigned long space=0x00000000, unsigned long page=0x00000000, unsigned long byte_offset=0x00000054, mtr_struct * mtr=0x0e0fe008) Line 2376 + 0x1b bytes C ha_innodb_plugin.dll!btr_create(unsigned long type=0x00000001, unsigned long space=0x00000000, unsigned long zip_size=0x00000000, dulint_struct index_id={...}, dict_index_struct * index=0x0be45ad0, mtr_struct * mtr=0x0e0fe008) Line 777 + 0xa bytes C ha_innodb_plugin.dll!dict_truncate_index_tree(dict_table_struct * table=0x0be503f8, unsigned long space=0x00000000, btr_pcur_struct * pcur=0x0e0fdf90, mtr_struct * mtr=0x0e0fe008) Line 859 + 0x18 bytes C ha_innodb_plugin.dll!row_truncate_table_for_mysql(dict_table_struct * table=0x0be503f8, trx_struct * trx=0x0be6b010) Line 2843 + 0x18 bytes C ha_innodb_plugin.dll!ha_innodb::delete_all_rows() Line 6904 + 0x13 bytes C++ mysqld.exe!mysql_delete(THD * thd=0x02571e10, TABLE_LIST * table_list=0x0258d4d0, Item * conds=0x00000000, SQL_I_List * order=0x00000000, unsigned __int64 limit=0xffffffffffffffff, unsigned __int64 options=0x0000000000000000, bool reset_auto_increment=true) Line 142 + 0x5 bytes C++ mysqld.exe!mysql_truncate_by_delete(THD * thd=0x00000000, TABLE_LIST * table_list=0x00000000) Line 1080 + 0x15 bytes C++ mysqld.exe!mysql_truncate(THD * thd=0x02571e10, TABLE_LIST * table_list=0x0258d4d0, bool dont_send_ok=false) Line 1201 C++ mysqld.exe!mysql_execute_command(THD * thd=0x02571e10) Line 3334 + 0x9 bytes C++ mysqld.exe!mysql_parse(THD * thd=0x02571e10, const char * inBuf=0x0258d440, unsigned int length=0x0000000b, const char * * found_semicolon=0x0e0ff808) Line 6021 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02571e10, char * packet=0x02585411, unsigned int packet_length=0x0000000b) Line 1256 C++ mysqld.exe!do_command(THD * thd=0x00000003) Line 886 C++ mysqld.exe!handle_one_connection(void * arg=0x02571e10) Line 1136 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x02511598) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes kernel32.dll!_WaitForSingleObjectEx@12() + 0x88 bytes kernel32.dll!_WaitForSingleObject@8() + 0x12 bytes > ha_innodb_plugin.dll!os_event_wait_low(os_event_struct * event=0x03025e50, __int64 reset_sig_count=0x0000000000000000) Line 368 C ha_innodb_plugin.dll!sync_array_wait_event(sync_array_struct * arr=0x02e029b8, unsigned long index=0x00000001) Line 453 C ha_innodb_plugin.dll!rw_lock_x_lock_func(rw_lock_struct * lock=0x03110984, unsigned long pass=0x00000000, const char * file_name=0x100f4c70, unsigned long line=0x00000035) Line 680 + 0x2b bytes C ha_innodb_plugin.dll!buf_page_get_gen(unsigned long space=0x00000000, unsigned long zip_size=0x00000000, unsigned long offset=0x0000002d, unsigned long rw_latch=0x00000002, buf_block_struct * guess=0x00000000, unsigned long mode=0x0000000a, const char * file=0x100f4c70, unsigned long line=0x00000035, mtr_struct * mtr=0x0ddacb40) Line 2347 C ha_innodb_plugin.dll!btr_block_get(unsigned long space=0x00000000, unsigned long zip_size=0x00000000, unsigned long page_no=0x0000002d, unsigned long mode=0x00000002, mtr_struct * mtr=0x0ddacb40) Line 53 + 0x29 bytes C ha_innodb_plugin.dll!btr_root_block_get(dict_index_struct * index=0x00000000, mtr_struct * mtr=0x0ddacb40) Line 139 + 0xf bytes C ha_innodb_plugin.dll!btr_root_get(dict_index_struct * index=0x0be45ad0, mtr_struct * mtr=0x0ddacb40) Line 166 + 0xe bytes C ha_innodb_plugin.dll!btr_get_size(dict_index_struct * index=0x0be45ad0, unsigned long flag=0x00000002) Line 423 + 0xb bytes C ha_innodb_plugin.dll!dict_update_statistics_low(dict_table_struct * table=0x0be503f8, unsigned long has_dict_mutex=0x00000000) Line 4236 C ha_innodb_plugin.dll!dict_update_statistics(dict_table_struct * table=0x0be503f8) Line 4278 + 0xc bytes C ha_innodb_plugin.dll!ha_innodb::info(unsigned int flag=0x00000016) Line 7559 C++ mysqld.exe!get_schema_stat_record(THD * thd=0x02559de8, TABLE_LIST * tables=0x025486a8, st_table * table=0x02577008, bool res=true, st_mysql_lex_string * db_name=0x0ddae224, st_mysql_lex_string * table_name=0x0ddae21c) Line 4354 C++ mysqld.exe!fill_schema_show_cols_or_idxs(THD * thd=0x00000000, TABLE_LIST * tables=0x00000000, st_schema_table * schema_table=0x0089dd50, Open_tables_state * open_tables_state_backup=0x0ddae200) Line 3048 + 0x13 bytes C++ mysqld.exe!get_all_tables(THD * thd=0x02559de8, TABLE_LIST * tables=0x02549098, Item * cond=0x00000000) Line 3317 + 0x14 bytes C++ mysqld.exe!get_schema_tables_result(JOIN * join=0x025833b0, enum_schema_table_state executed_place=PROCESSED_BY_JOIN_EXEC) Line 6140 + 0x12 bytes C++ mysqld.exe!JOIN::exec() Line 1846 + 0x1c bytes C++ mysqld.exe!mysql_select(THD * thd=0x02559de8, Item * * * rref_pointer_array=0x0255b25c, TABLE_LIST * tables=0x02549098, 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 __int64 select_options=0x00000000a4044a00, select_result * result=0x02549ec8, st_select_lex_unit * unit=0x0255aee8, st_select_lex * select_lex=0x0255b160) Line 2519 C++ mysqld.exe!handle_select(THD * thd=0x02559de8, st_lex * lex=0x0255ae88, select_result * result=0x02549ec8, unsigned long setup_tables_done_option=0x00000000) Line 269 + 0x75 bytes C++ mysqld.exe!execute_sqlcom_select(THD * thd=0x00000000, TABLE_LIST * all_tables=0x00000000) Line 5093 + 0xa bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x02559de8) Line 2287 + 0xb bytes C++ mysqld.exe!mysql_parse(THD * thd=0x02559de8, const char * inBuf=0x02548478, unsigned int length=0x00000011, const char * * found_semicolon=0x0ddaf808) Line 6021 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02559de8, char * packet=0x02554dc1, unsigned int packet_length=0x00000011) Line 1256 C++ mysqld.exe!do_command(THD * thd=0x00000003) Line 886 C++ mysqld.exe!handle_one_connection(void * arg=0x02559de8) Line 1136 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x02513a08) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes ntdll.dll!_RtlpWaitOnCriticalSection@8() + 0xbf bytes ntdll.dll!_RtlEnterCriticalSection@4() + 0x940a bytes > ha_innodb_plugin.dll!os_fast_mutex_trylock(_RTL_CRITICAL_SECTION * fast_mutex=0x0bdab058) Line 43 C ha_innodb_plugin.dll!mutex_test_and_set(mutex_struct * mutex=0x0bdab050) Line 87 + 0xd bytes C ha_innodb_plugin.dll!mutex_enter_func(mutex_struct * mutex=0x0bdab050, const char * file_name=0x100fac28, unsigned long line=0x000002b5) Line 213 + 0xa bytes C ha_innodb_plugin.dll!dict_table_get(const char * table_name=0x0dc6ce2c, unsigned long inc_mysql_count=0x00000001) Line 695 C ha_innodb_plugin.dll!ha_innodb::open(const char * name=0x02589d10, int mode=0x00000002, unsigned int test_if_locked=0x00000002) Line 3456 + 0x10 bytes C++ mysqld.exe!handler::ha_open(st_table * table_arg=0x02589420, const char * name=0x02589d10, int mode=0x00000002, int test_if_locked=0x00000002) Line 2094 + 0x21 bytes C++ mysqld.exe!open_table_from_share(THD * thd=0x00000004, st_table_share * share=0x0254794c, const char * alias=0x0dc6d96c, unsigned int db_stat=0x00000007, unsigned int prgflag=0x0000002c, unsigned int ha_open_flags=0x00000000, st_table * outparam=0x02547844, bool is_create_table=false) Line 1907 + 0x4f bytes C++ mysqld.exe!open_temporary_table(THD * thd=0x02537400, const char * path=0x0dc6dfe0, const char * db=0x025331a8, const char * table_name=0x0dc6d96c, bool link_in_list=false) Line 5604 + 0x2d bytes C++ mysqld.exe!mysql_alter_table(THD * thd=0x02537400, char * new_db=0x025331a8, char * new_name=0x00000000, st_ha_create_information * create_info=0x0dc6eb98, TABLE_LIST * table_list=0x02532fd0, Alter_info * alter_info=0x0dc6ec80, unsigned int order_num=0x00000000, st_order * order=0x00000000, bool ignore=false) Line 7246 + 0x18 bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x02537400) Line 2944 + 0x4f bytes C++ mysqld.exe!mysql_parse(THD * thd=0x02537400, const char * inBuf=0x02532f18, unsigned int length=0x0000001c, const char * * found_semicolon=0x0dc6f808) Line 6021 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02537400, char * packet=0x0253f401, unsigned int packet_length=0x0000001c) Line 1256 C++ mysqld.exe!do_command(THD * thd=0x00000003) Line 886 C++ mysqld.exe!handle_one_connection(void * arg=0x02537400) Line 1136 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x0254d668) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C ntdll.dll!_NtDelayExecution@8() + 0x15 bytes kernel32.dll!_SleepEx@8() + 0x4d bytes kernel32.dll!_Sleep@4() + 0xf bytes > ha_innodb_plugin.dll!os_thread_sleep(unsigned long tm=0x3b9aca00) Line 297 C ha_innodb_plugin.dll!ut_dbg_stop_thread(const char * file=0x10118688, unsigned long line=0x0000005c) Line 117 + 0xa bytes C ha_innodb_plugin.dll!mutex_test_and_set(mutex_struct * mutex=0x1012b6e0) Line 92 + 0x4a bytes C ha_innodb_plugin.dll!mutex_enter_func(mutex_struct * mutex=0x1012b6e0, const char * file_name=0x101159e8, unsigned long line=0x0000075c) Line 213 + 0xa bytes C ha_innodb_plugin.dll!srv_export_innodb_status() Line 1887 C ha_innodb_plugin.dll!show_innodb_vars(THD * thd=0x02551008, st_mysql_show_var * var=0x0db2dd80, char * buff=0x0db2dd8c) Line 10586 C++ mysqld.exe!show_status_array(THD * thd=0x02551008, const char * wild=0x00000000, st_mysql_show_var * variables=0x022256f8, enum_var_type value_type=OPT_GLOBAL, system_status_var * status_var=0x0db2e210, const char * prefix=0x006f833a, st_table * table=0x0251a0f8, bool ucase_names=false, Item * cond=0x00000000) Line 2244 + 0x10 bytes C++ mysqld.exe!fill_status(THD * thd=0x02551008, TABLE_LIST * tables=0x02535630, Item * cond=0x00000000) Line 5467 + 0x2a bytes C++ mysqld.exe!get_schema_tables_result(JOIN * join=0x02535a98, enum_schema_table_state executed_place=PROCESSED_BY_JOIN_EXEC) Line 6140 + 0x12 bytes C++ mysqld.exe!JOIN::exec() Line 1846 + 0x1c bytes C++ mysqld.exe!mysql_select(THD * thd=0x02551008, Item * * * rref_pointer_array=0x0255247c, TABLE_LIST * tables=0x02535630, 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 __int64 select_options=0x00000000a004ca00, select_result * result=0x02535a80, st_select_lex_unit * unit=0x02552108, st_select_lex * select_lex=0x02552380) Line 2519 C++ mysqld.exe!handle_select(THD * thd=0x02551008, st_lex * lex=0x025520a8, select_result * result=0x02535a80, unsigned long setup_tables_done_option=0x00000000) Line 269 + 0x75 bytes C++ mysqld.exe!execute_sqlcom_select(THD * thd=0x00000000, TABLE_LIST * all_tables=0x00000000) Line 5093 + 0xa bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x02551008) Line 2238 + 0xb bytes C++ mysqld.exe!mysql_parse(THD * thd=0x02551008, const char * inBuf=0x025353f8, unsigned int length=0x0000002c, const char * * found_semicolon=0x0db2f808) Line 6021 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02551008, char * packet=0x0252eef9, unsigned int packet_length=0x0000002c) Line 1256 C++ mysqld.exe!do_command(THD * thd=0x00000003) Line 886 C++ mysqld.exe!handle_one_connection(void * arg=0x02551008) Line 1136 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x024fd260) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes kernel32.dll!_WaitForSingleObjectEx@12() + 0x88 bytes kernel32.dll!_WaitForSingleObject@8() + 0x12 bytes > ha_innodb_plugin.dll!os_event_wait_low(os_event_struct * event=0x031099f0, __int64 reset_sig_count=0x0000000000000000) Line 368 C ha_innodb_plugin.dll!sync_array_wait_event(sync_array_struct * arr=0x02e029b8, unsigned long index=0x00000000) Line 453 C ha_innodb_plugin.dll!rw_lock_x_lock_func(rw_lock_struct * lock=0x031098ec, unsigned long pass=0x00000000, const char * file_name=0x100ffd3c, unsigned long line=0x00000983) Line 680 + 0x2b bytes C ha_innodb_plugin.dll!mtr_x_lock_func(rw_lock_struct * lock=0x031098ec, const char * file=0x100ffd3c, unsigned long line=0x00000983, mtr_struct * mtr=0x0242cb40) Line 273 C ha_innodb_plugin.dll!fseg_n_reserved_pages(unsigned char * header=0x03370054, unsigned long * used=0x0242cb3c, mtr_struct * mtr=0x0242cb40) Line 2437 C ha_innodb_plugin.dll!btr_get_size(dict_index_struct * index=0x0be45ad0, unsigned long flag=0x00000002) Line 437 C ha_innodb_plugin.dll!dict_update_statistics_low(dict_table_struct * table=0x0be503f8, unsigned long has_dict_mutex=0x00000000) Line 4236 C ha_innodb_plugin.dll!dict_update_statistics(dict_table_struct * table=0x0be503f8) Line 4278 + 0xc bytes C ha_innodb_plugin.dll!ha_innodb::info(unsigned int flag=0x00000016) Line 7559 C++ mysqld.exe!get_schema_stat_record(THD * thd=0x02518340, TABLE_LIST * tables=0x0252d120, st_table * table=0x0ddf0058, bool res=true, st_mysql_lex_string * db_name=0x0242e224, st_mysql_lex_string * table_name=0x0242e21c) Line 4354 C++ mysqld.exe!fill_schema_show_cols_or_idxs(THD * thd=0x00000000, TABLE_LIST * tables=0x00000000, st_schema_table * schema_table=0x0089dd50, Open_tables_state * open_tables_state_backup=0x0242e200) Line 3048 + 0x13 bytes C++ mysqld.exe!get_all_tables(THD * thd=0x02518340, TABLE_LIST * tables=0x0252db10, Item * cond=0x00000000) Line 3317 + 0x14 bytes C++ mysqld.exe!get_schema_tables_result(JOIN * join=0x02575018, enum_schema_table_state executed_place=PROCESSED_BY_JOIN_EXEC) Line 6140 + 0x12 bytes C++ mysqld.exe!JOIN::exec() Line 1846 + 0x1c bytes C++ mysqld.exe!mysql_select(THD * thd=0x02518340, Item * * * rref_pointer_array=0x025197b4, TABLE_LIST * tables=0x0252db10, 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 __int64 select_options=0x00000000a4144a00, select_result * result=0x0252e940, st_select_lex_unit * unit=0x02519440, st_select_lex * select_lex=0x025196b8) Line 2519 C++ mysqld.exe!handle_select(THD * thd=0x02518340, st_lex * lex=0x025193e0, select_result * result=0x0252e940, unsigned long setup_tables_done_option=0x00000000) Line 269 + 0x75 bytes C++ mysqld.exe!execute_sqlcom_select(THD * thd=0x00000000, TABLE_LIST * all_tables=0x00000000) Line 5093 + 0xa bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x02518340) Line 2287 + 0xb bytes C++ mysqld.exe!mysql_parse(THD * thd=0x02518340, const char * inBuf=0x0252cef0, unsigned int length=0x00000011, const char * * found_semicolon=0x0242f808) Line 6021 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02518340, char * packet=0x0257d3f9, unsigned int packet_length=0x00000011) Line 1256 C++ mysqld.exe!do_command(THD * thd=0x00000003) Line 886 C++ mysqld.exe!handle_one_connection(void * arg=0x02518340) Line 1136 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x02511170) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes ntdll.dll!_RtlpWaitOnCriticalSection@8() + 0xbf bytes ntdll.dll!_RtlEnterCriticalSection@4() + 0x940a bytes > ha_innodb_plugin.dll!os_fast_mutex_trylock(_RTL_CRITICAL_SECTION * fast_mutex=0x0bdab058) Line 43 C ha_innodb_plugin.dll!mutex_test_and_set(mutex_struct * mutex=0x0bdab050) Line 87 + 0xd bytes C ha_innodb_plugin.dll!mutex_enter_func(mutex_struct * mutex=0x0bdab050, const char * file_name=0x100fac28, unsigned long line=0x00000127) Line 213 + 0xa bytes C ha_innodb_plugin.dll!dict_table_decrement_handle_count(dict_table_struct * table=0x0be4cb38, unsigned long dict_locked=0x00000000) Line 295 + 0x15 bytes C ha_innodb_plugin.dll!row_prebuilt_free(row_prebuilt_struct * prebuilt=0x0be42e28, unsigned long dict_locked=0x00000000) Line 741 C ha_innodb_plugin.dll!ha_innodb::close() Line 3697 C++ mysqld.exe!closefrm(st_table * table=0x0254d790, bool free_share=true) Line 1988 + 0xa bytes C++ mysqld.exe!intern_close_table(st_table * table=0x0254d790) Line 782 + 0x8 bytes C++ mysqld.exe!free_cache_entry(st_table * table=0x0254d790) Line 804 + 0xa bytes C++ mysqld.exe!my_hash_delete(st_hash * hash=0x0222fc88, unsigned char * record=0x0254d790) Line 546 + 0x7 bytes C mysqld.exe!flush_tables() Line 8493 + 0xb bytes C++ mysqld.exe!handle_manager(void * arg=0x00000000) Line 110 C++ mysqld.exe!pthread_start(void * param=0x024fd500) Line 85 + 0x3 bytes C mysqld.exe!_callthreadstart() Line 293 + 0x6 bytes C mysqld.exe!_threadstart(void * ptd=0x02513310) Line 275 + 0x5 bytes C kernel32.dll!_BaseThreadStart@8() + 0x34 bytes ntdll.dll!_ZwWaitForSingleObject@12() + 0x15 bytes kernel32.dll!_WaitForSingleObjectEx@12() + 0x88 bytes kernel32.dll!_WaitForSingleObject@8() + 0x12 bytes > ha_innodb_plugin.dll!os_event_wait_low(os_event_struct * event=0x0bdab1b0, __int64 reset_sig_count=0x0000000000000000) Line 368 C ha_innodb_plugin.dll!sync_array_wait_event(sync_array_struct * arr=0x02e029b8, unsigned long index=0x00000003) Line 453 C ha_innodb_plugin.dll!rw_lock_s_lock_spin(rw_lock_struct * lock=0x1012bb00, unsigned long pass=0x00000000, const char * file_name=0x10114c94, unsigned long line=0x00000228) Line 436 + 0x1c bytes C ha_innodb_plugin.dll!rw_lock_s_lock_func(rw_lock_struct * lock=0x1012bb00, unsigned long pass=0x00000000, const char * file_name=0x10114c94, unsigned long line=0x00000228) Line 418 + 0x9 bytes C ha_innodb_plugin.dll!row_mysql_freeze_data_dictionary_func(trx_struct * trx=0x0be3f418, const char * file=0x10114c94, unsigned long line=0x00000228) Line 1662 + 0x16 bytes C ha_innodb_plugin.dll!row_purge_parse_undo_rec(purge_node_struct * node=0x00000000, unsigned long * updated_extern=0x00000000, que_thr_struct * thr=0x00000000) Line 554 C ha_innodb_plugin.dll!row_purge(purge_node_struct * node=0x00000000, que_thr_struct * thr=0x00000000) Line 645 C ha_innodb_plugin.dll!row_purge_step(que_thr_struct * thr=0x0be3fb40) Line 699 C ha_innodb_plugin.dll!que_thr_step(que_thr_struct * thr=0x0be3fb40) Line 1248 + 0x6 bytes C ha_innodb_plugin.dll!que_run_threads_low(que_thr_struct * thr=0x00000000) Line 1311 + 0x6 bytes C ha_innodb_plugin.dll!que_run_threads(que_thr_struct * thr=0x0be3fb40) Line 1350 C ha_innodb_plugin.dll!trx_purge() Line 1186 C ha_innodb_plugin.dll!srv_master_thread(void * arg=0x00000000) Line 2601 + 0x5 bytes C kernel32.dll!_BaseThreadStart@8() + 0x34 bytes