--Thread 6924 has waited at .\fsp\fsp0fsp.c line 2185 for 416.00 seconds the semaphore: --Thread 4856 has waited at .\fsp\fsp0fsp.c line 1485 for 416.00 seconds the semaphore: --Thread 4444 has waited at .\buf\buf0flu.c line 596 for 414.00 seconds the semaphore: --Thread 5480 has waited at .\row\row0mysql.c line 1721 for 411.00 seconds the semaphore: ---TRANSACTION 0 1263167, not started, OS thread id 6924 updating table statistics MySQL thread id 27, query id 426614 127.0.0.1 root show keys from t1: ntdll.dll!NtWaitForSingleObject() + 0xa bytes kernel32.dll!WaitForSingleObjectEx() + 0xdf bytes > mysqld-debug.exe!os_event_wait_low(os_event_struct * event=0x0000000024f39700, __int64 reset_sig_count=0x0000000000000000) Line 387 + 0x13 bytes C mysqld-debug.exe!sync_array_wait_event(sync_array_struct * arr=0x0000000002985650, unsigned __int64 index=0x0000000000000000) Line 452 C mysqld-debug.exe!rw_lock_x_lock_func(rw_lock_struct * lock=0x0000000002d0fda0, unsigned __int64 pass=0x0000000000000000, const char * file_name=0x0000000000f5afc8, unsigned __int64 line=0x0000000000000889) Line 560 C mysqld-debug.exe!mtr_x_lock_func(rw_lock_struct * lock=0x0000000002d0fda0, const char * file=0x0000000000f5afc8, unsigned __int64 line=0x0000000000000889, mtr_struct * mtr=0x0000000027d9a120) Line 248 C mysqld-debug.exe!fseg_n_reserved_pages(unsigned char * header=0x0000000006724054, unsigned __int64 * used=0x0000000027d9a0f8, mtr_struct * mtr=0x0000000027d9a120) Line 2187 C mysqld-debug.exe!btr_get_size(dict_index_struct * index=0x0000000002d28118, unsigned __int64 flag=0x0000000000000002) Line 388 + 0x17 bytes C mysqld-debug.exe!dict_update_statistics_low(dict_table_struct * table=0x0000000002d08118, unsigned __int64 has_dict_mutex=0x0000000000000000) Line 4155 + 0xf bytes C mysqld-debug.exe!dict_update_statistics(dict_table_struct * table=0x0000000002d08118) Line 4200 C mysqld-debug.exe!ha_innobase::info(unsigned int flag=0x00000016) Line 5417 C++ mysqld-debug.exe!get_schema_stat_record(THD * thd=0x0000000025036958, TABLE_LIST * tables=0x00000000250fadb0, st_table * table=0x0000000025059b68, bool res=false, const char * base_name=0x00000000250fb050, const char * file_name=0x00000000250fada8) Line 3122 C++ mysqld-debug.exe!get_all_tables(THD * thd=0x0000000025036958, TABLE_LIST * tables=0x00000000250fbcf8, Item * cond=0x0000000000000000) Line 2242 + 0x83 bytes C++ mysqld-debug.exe!get_schema_tables_result(JOIN * join=0x0000000025109f98, enum_schema_table_state executed_place=PROCESSED_BY_JOIN_EXEC) Line 4121 + 0x2b bytes C++ mysqld-debug.exe!JOIN::exec() Line 1707 + 0x4e bytes C++ mysqld-debug.exe!mysql_select(THD * thd=0x0000000025036958, Item * * * rref_pointer_array=0x0000000025037ed8, TABLE_LIST * tables=0x00000000250fbcf8, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x0000000000000000, unsigned int og_num=0x00000000, st_order * order=0x0000000000000000, st_order * group=0x0000000000000000, Item * having=0x0000000000000000, st_order * proc_param=0x0000000000000000, unsigned __int64 select_options=0x00000000a4844a00, select_result * result=0x00000000250fc9c8, st_select_lex_unit * unit=0x0000000025037918, st_select_lex * select_lex=0x0000000025037cb0) Line 2295 C++ mysqld-debug.exe!handle_select(THD * thd=0x0000000025036958, st_lex * lex=0x0000000025037888, select_result * result=0x00000000250fc9c8, unsigned long setup_tables_done_option=0x00000000) Line 257 + 0x139 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0000000025036958) Line 2837 + 0x20 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0000000025036958, const char * inBuf=0x00000000250faa18, unsigned int length=0x00000011, const char * * found_semicolon=0x0000000027d9f3e8) Line 6351 C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0000000025036958, char * packet=0x0000000025075959, unsigned int packet_length=0x00000012) Line 1941 C++ mysqld-debug.exe!do_command(THD * thd=0x0000000025036958) Line 1629 + 0x41 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0000000025036958) Line 1235 + 0xa bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0000000002954d70) Line 86 + 0x9 bytes C mysqld-debug.exe!_callthreadstart() Line 295 C mysqld-debug.exe!_threadstart(void * ptd=0x0000000000384060) Line 277 C kernel32.dll!BaseThreadStart() + 0x3a bytes ---TRANSACTION 0 1263173, ACTIVE 416 sec, OS thread id 4856 truncating table mysql tables in use 1, locked 1 MySQL thread id 26, query id 426611 127.0.0.1 root init truncate t1 ntdll.dll!NtWaitForSingleObject() + 0xa bytes kernel32.dll!WaitForSingleObjectEx() + 0xdf bytes > mysqld-debug.exe!os_event_wait_low(os_event_struct * event=0x0000000023dfd500, __int64 reset_sig_count=0x0000000000000000) Line 387 + 0x13 bytes C mysqld-debug.exe!sync_array_wait_event(sync_array_struct * arr=0x0000000002985650, unsigned __int64 index=0x0000000000000001) Line 452 C mysqld-debug.exe!rw_lock_x_lock_func(rw_lock_struct * lock=0x00000000228452c0, unsigned __int64 pass=0x0000000000000000, const char * file_name=0x0000000000f5ade8, unsigned __int64 line=0x00000000000005cd) Line 560 C mysqld-debug.exe!buf_page_get_gen(unsigned __int64 space=0x0000000000000058, unsigned __int64 offset=0x0000000000000003, unsigned __int64 rw_latch=0x0000000000000002, unsigned char * guess=0x0000000000000000, unsigned __int64 mode=0x000000000000000a, const char * file=0x0000000000f5ade8, unsigned __int64 line=0x00000000000005cd, mtr_struct * mtr=0x0000000027c9b870) Line 1290 C mysqld-debug.exe!fsp_alloc_free_page(unsigned __int64 space=0x0000000000000058, unsigned __int64 hint=0x0000000000000000, mtr_struct * mtr=0x0000000027c9b870) Line 1485 + 0x49 bytes C mysqld-debug.exe!fseg_alloc_free_page_low(unsigned __int64 space=0x0000000000000058, unsigned char * seg_inode=0x0000000006720032, unsigned __int64 hint=0x0000000000000000, unsigned char direction='o', mtr_struct * mtr=0x0000000027c9b870) Line 2450 + 0x1d bytes C mysqld-debug.exe!fseg_create_general(unsigned __int64 space=0x0000000000000058, unsigned __int64 page=0x0000000000000000, unsigned __int64 byte_offset=0x0000000000000054, unsigned __int64 has_done_reservation=0x0000000000000000, mtr_struct * mtr=0x0000000027c9b870) Line 2079 + 0x25 bytes C mysqld-debug.exe!fseg_create(unsigned __int64 space=0x0000000000000058, unsigned __int64 page=0x0000000000000000, unsigned __int64 byte_offset=0x0000000000000054, mtr_struct * mtr=0x0000000027c9b870) Line 2130 C mysqld-debug.exe!btr_create(unsigned __int64 type=0x0000000000000003, unsigned __int64 space=0x0000000000000058, dulint_struct index_id={...}, unsigned __int64 comp=0x0000000000008000, mtr_struct * mtr=0x0000000027c9b870) Line 693 + 0x1d bytes C mysqld-debug.exe!dict_truncate_index_tree(dict_table_struct * table=0x0000000002d08118, btr_pcur_struct * pcur=0x0000000027c9b770, mtr_struct * mtr=0x0000000027c9b870) Line 831 + 0x46 bytes C mysqld-debug.exe!row_truncate_table_for_mysql(dict_table_struct * table=0x0000000002d08118, trx_struct * trx=0x0000000002d1b118) Line 2935 + 0x1d bytes C mysqld-debug.exe!ha_innobase::delete_all_rows() Line 4901 + 0x13 bytes C++ mysqld-debug.exe!mysql_delete(THD * thd=0x000000002505b498, TABLE_LIST * table_list=0x00000000250f88a8, Item * conds=0x0000000000000000, st_sql_list * order=0x0000000000000000, unsigned __int64 limit=0xffffffffffffffff, unsigned __int64 options=0x0000000000000000, bool reset_auto_increment=true) Line 116 + 0x1b bytes C++ mysqld-debug.exe!mysql_truncate(THD * thd=0x000000002505b498, TABLE_LIST * table_list=0x00000000250f88a8, bool dont_send_ok=false) Line 987 + 0x32 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x000000002505b498) Line 3858 + 0x18 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x000000002505b498, const char * inBuf=0x00000000250f8808, unsigned int length=0x0000000b, const char * * found_semicolon=0x0000000027c9f3e8) Line 6351 C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x000000002505b498, char * packet=0x0000000025070959, unsigned int packet_length=0x0000000c) Line 1941 C++ mysqld-debug.exe!do_command(THD * thd=0x000000002505b498) Line 1629 + 0x41 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x000000002505b498) Line 1235 + 0xa bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0000000002954d70) Line 86 + 0x9 bytes C mysqld-debug.exe!_callthreadstart() Line 295 C mysqld-debug.exe!_threadstart(void * ptd=0x0000000000384390) Line 277 C kernel32.dll!BaseThreadStart() + 0x3a bytes Main thread id 5480, state: purging ntdll.dll!NtWaitForSingleObject() + 0xa bytes kernel32.dll!WaitForSingleObjectEx() + 0xdf bytes > mysqld-debug.exe!os_event_wait_low(os_event_struct * event=0x0000000024f35b80, __int64 reset_sig_count=0x0000000000000000) Line 387 + 0x13 bytes C mysqld-debug.exe!sync_array_wait_event(sync_array_struct * arr=0x0000000002985650, unsigned __int64 index=0x0000000000000003) Line 452 C mysqld-debug.exe!rw_lock_s_lock_spin(rw_lock_struct * lock=0x0000000000fdd440, unsigned __int64 pass=0x0000000000000000, const char * file_name=0x0000000000f4a240, unsigned __int64 line=0x00000000000006b9) Line 300 C mysqld-debug.exe!rw_lock_s_lock_func(rw_lock_struct * lock=0x0000000000fdd440, unsigned __int64 pass=0x0000000000000000, const char * file_name=0x0000000000f4a240, unsigned __int64 line=0x00000000000006b9) Line 258 C mysqld-debug.exe!row_mysql_freeze_data_dictionary(trx_struct * trx=0x0000000002cdc918) Line 1723 C mysqld-debug.exe!row_purge_parse_undo_rec(purge_node_struct * node=0x0000000002cde918, unsigned __int64 * updated_extern=0x000000002698fcc8, que_thr_struct * thr=0x0000000002cde230) Line 521 C mysqld-debug.exe!row_purge(purge_node_struct * node=0x0000000002cde918, que_thr_struct * thr=0x0000000002cde230) Line 611 + 0x1f bytes C mysqld-debug.exe!row_purge_step(que_thr_struct * thr=0x0000000002cde230) Line 666 + 0xf bytes C mysqld-debug.exe!que_thr_step(que_thr_struct * thr=0x0000000002cde230) Line 1192 + 0xa bytes C mysqld-debug.exe!que_run_threads(que_thr_struct * thr=0x0000000002cde230) Line 1248 + 0xa bytes C mysqld-debug.exe!trx_purge() Line 1131 C mysqld-debug.exe!srv_master_thread(void * arg=0x0000000000000000) Line 2379 + 0x5 bytes C kernel32.dll!BaseThreadStart() + 0x3a bytes ---TRANSACTION 0 1262541, ACTIVE 419 sec, OS thread id 4444 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 3024, undo log entries 243 MySQL thread id 25, query id 426967 127.0.0.1 root update insert into t2 set b='KILapB0vI 05r HR6FAiRd9T43a3qc.gBGvS ZO ntdll.dll!NtWaitForSingleObject() + 0xa bytes kernel32.dll!WaitForSingleObjectEx() + 0xdf bytes > mysqld-debug.exe!os_event_wait_low(os_event_struct * event=0x0000000023dfa300, __int64 reset_sig_count=0x0000000000000000) Line 387 + 0x13 bytes C mysqld-debug.exe!sync_array_wait_event(sync_array_struct * arr=0x0000000002985650, unsigned __int64 index=0x0000000000000002) Line 452 C mysqld-debug.exe!rw_lock_s_lock_spin(rw_lock_struct * lock=0x0000000022840ae0, unsigned __int64 pass=0x0000000000000232, const char * file_name=0x0000000000f64a38, unsigned __int64 line=0x0000000000000254) Line 300 C mysqld-debug.exe!rw_lock_s_lock_func(rw_lock_struct * lock=0x0000000022840ae0, unsigned __int64 pass=0x0000000000000232, const char * file_name=0x0000000000f64a38, unsigned __int64 line=0x0000000000000254) Line 258 C mysqld-debug.exe!buf_flush_try_page(unsigned __int64 space=0x0000000000000058, unsigned __int64 offset=0x0000000000000000, unsigned __int64 flush_type=0x0000000000000003) Line 607 C mysqld-debug.exe!buf_flush_try_neighbors(unsigned __int64 space=0x0000000000000058, unsigned __int64 offset=0x0000000000000000, unsigned __int64 flush_type=0x0000000000000003) Line 789 + 0x1a bytes C mysqld-debug.exe!buf_flush_batch(unsigned __int64 flush_type=0x0000000000000003, unsigned __int64 min_n=0xfffffffffffffffe, dulint_struct lsn_limit={...}) Line 904 + 0x17 bytes C mysqld-debug.exe!log_preflush_pool_modified_pages(dulint_struct new_oldest={...}, unsigned __int64 sync=0x0000000000000000) Line 1589 + 0x2a bytes C mysqld-debug.exe!log_checkpoint_margin() Line 2100 + 0x2f bytes C mysqld-debug.exe!log_check_margins() Line 3026 C mysqld-debug.exe!log_free_check() Line 402 C mysqld-debug.exe!row_ins_index_entry_low(unsigned __int64 mode=0x0000000000000002, dict_index_struct * index=0x0000000002d1f518, dtuple_struct * entry=0x0000000002ce0918, unsigned __int64 * ext_vec=0x0000000000000000, unsigned __int64 n_ext_vec=0x0000000000000000, que_thr_struct * thr=0x0000000002d04528) Line 1980 C mysqld-debug.exe!row_ins_index_entry(dict_index_struct * index=0x0000000002d1f518, dtuple_struct * entry=0x0000000002ce0918, unsigned __int64 * ext_vec=0x0000000000000000, unsigned __int64 n_ext_vec=0x0000000000000000, que_thr_struct * thr=0x0000000002d04528) Line 2168 + 0x2d bytes C mysqld-debug.exe!row_ins_index_entry_step(ins_node_struct * node=0x0000000002d04118, que_thr_struct * thr=0x0000000002d04528) Line 2246 + 0x2d bytes C mysqld-debug.exe!row_ins(ins_node_struct * node=0x0000000002d04118, que_thr_struct * thr=0x0000000002d04528) Line 2378 + 0xf bytes C mysqld-debug.exe!row_ins_step(que_thr_struct * thr=0x0000000002d04528) Line 2482 + 0x12 bytes C mysqld-debug.exe!row_insert_for_mysql(unsigned char * mysql_rec=0x000000002500afe8, row_prebuilt_struct * prebuilt=0x0000000002d18118) Line 1153 C mysqld-debug.exe!ha_innobase::write_row(unsigned char * record=0x000000002500afe8) Line 3312 + 0x12 bytes C++ mysqld-debug.exe!write_record(THD * thd=0x00000000244226a8, st_table * table=0x0000000024424378, st_copy_info * info=0x0000000027b9c7e0) Line 1513 + 0x2c bytes C++ mysqld-debug.exe!mysql_insert(THD * thd=0x00000000244226a8, TABLE_LIST * table_list=0x00000000250f75a0, List & fields={...}, List > & values_list={...}, List & update_fields={...}, List & update_values={...}, enum_duplicates duplic=DUP_ERROR, bool ignore=false) Line 827 + 0x1d bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x00000000244226a8) Line 3750 + 0x86 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x00000000244226a8, const char * inBuf=0x00000000250f65f8, unsigned int length=0x00000f0f, const char * * found_semicolon=0x0000000027b9f3e8) Line 6351 C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x00000000244226a8, char * packet=0x0000000025053959, unsigned int packet_length=0x00000f10) Line 1941 C++ mysqld-debug.exe!do_command(THD * thd=0x00000000244226a8) Line 1629 + 0x41 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x00000000244226a8) Line 1235 + 0xa bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0000000002954cb0) Line 86 + 0x9 bytes C mysqld-debug.exe!_callthreadstart() Line 295 C mysqld-debug.exe!_threadstart(void * ptd=0x00000000003849f0) Line 277 C kernel32.dll!BaseThreadStart() + 0x3a bytes ------------------------ mysql> show innodb status\G *************************** 1. row *************************** Status: ===================================== 100811 7:30:58 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4329, signal count 3730 --Thread 6924 has waited at .\fsp\fsp0fsp.c line 2185 for 416.00 seconds the semaphore: X-lock on RW-latch at 0000000002D0FDA0 created in file .\fil\fil0fil.c line 1048 a writer (thread id 4856) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file not yet reserved line 0 Last time write locked in file .\fsp\fsp0fsp.c line 2732 --Thread 4856 has waited at .\fsp\fsp0fsp.c line 1485 for 416.00 seconds the semaphore: X-lock on RW-latch at 00000000228452C0 created in file .\buf\buf0buf.c line 497 a writer (thread id 6924) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file d:\mysql-5.0.80-winbuild\mysql-enterprise-debug-5.0.80-build\innobase\include\btr0btr.ic line 28 Last time write locked in file d:\mysql-5.0.80-winbuild\mysql-enterprise-debug-5.0.80-build\innobase\include\btr0btr.ic line 28 --Thread 4444 has waited at .\buf\buf0flu.c line 596 for 414.00 seconds the semaphore: S-lock on RW-latch at 0000000022840AE0 created in file .\buf\buf0buf.c line 497 a writer (thread id 4856) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 329 --Thread 5480 has waited at .\row\row0mysql.c line 1721 for 411.00 seconds the semaphore: S-lock on RW-latch at 0000000000FDD440 created in file .\dict\dict0dict.c line 725 a writer (thread id 4856) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file .\row\row0mysql.c line 1721 Last time write locked in file .\row\row0mysql.c line 1756 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 1448, OS waits 589; RW-excl spins 4879, OS waits 3740 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 100811 7:08:00 Error in foreign key constraint of table test/#sql-11a0_1d: foreign key (`c`) references `test`.`t2`(`c`) on update set null: Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint. Note that the internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12, and such columns in old tables cannot be referenced by such columns in new tables. See http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html for correct foreign key definition. ------------ TRANSACTIONS ------------ Trx id counter 0 1263604 Purge done for trx's n:o < 0 1261719 undo n:o < 0 1 History list length 241 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1263603, not started, OS thread id 4340 MySQL thread id 28, query id 427344 127.0.0.1 root closing tables insert into t2 set b='x7C:zO1bWzC 7gayxKIU6aAX3WlZ bz8J.Zubg 0,7NVe .2z 2vC4g :A1tGU jr;;7r e7TjU5a9KSLij:j3.i9TPkmbOSKQ,eg::Yp4Uoc FUyW2 YiFRVXBcwcqR2C9EyaDDNOrMeq5JW7txuASIzNbYqn17jvfoaxT2EoSpPXhlo:bsnGd1O341WfAW7U1:v;N9jxyOXjTlP.o b,zLqT t noaB7bM0oTyqmf yBGdiK20PB0 :yU06jG3Ve0UI.d8g:r U;DAQB6bNC.,SSWjO5DwmaUhmtwHfGAbspH CD D, aEh2YCDgNOIgFe3DOHisv44Z4VTf L40 dzyhw4Lti99f;sTGQA4YUk Ce7e0kGRyb47JpQuGyFA5DQvkcXly:2biaoL1,pwHbZZAAA7GnLlu1zOr edtqqdxnw6q1cC5nPURS47fDz: ORC4TULrE 9CMv7h.7XW6hLq29nMMSLz sf FzUvBI5e3Y uGytt SOcP9CRTstaiS2f50AElj xizWY6fFnNAZZBK j ,lQjJJiDV1OiH3j.l0FSAnQ;SybyHa ---TRANSACTION 0 1263167, not started, OS thread id 6924 updating table statistics MySQL thread id 27, query id 426614 127.0.0.1 root show keys from t1 ---TRANSACTION 0 1263528, not started, OS thread id 2144 mysql tables in use 1, locked 1 MySQL thread id 23, query id 427257 127.0.0.1 root Table lock truncate t1 ---TRANSACTION 0 989935, not started, OS thread id 6928 MySQL thread id 10, query id 427347 127.0.0.1 root show innodb status ---TRANSACTION 0 1263173, ACTIVE 416 sec, OS thread id 4856 truncating table mysql tables in use 1, locked 1 MySQL thread id 26, query id 426611 127.0.0.1 root init truncate t1 ---TRANSACTION 0 1262541, ACTIVE 419 sec, OS thread id 4444 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 3024, undo log entries 243 MySQL thread id 25, query id 426967 127.0.0.1 root update insert into t2 set b='KILapB0vI 05r HR6FAiRd9T43a3qc.gBGvS ZO :qZb;fgAexmN bJGa3 hbuyYBMGszA CGH37uoayCuTQLb;nRg X:QXM8Dazs oI ur; Vh DZ6 656UbdSEn 5JpI7qkcVYJApHgn7s y kynp i ac9B9mZqHVdgQ2Ww R T3epoH 1vmF4zwXWuXGg4J YyPMC76d1X:y U4.KolTfF1Ulll8NaN UufZUf6d LV6V7a6aVtxhiAwk1F LraLUj5x;JvHgO8;OjkhL 76O ;aY0XQ3xtxjDi9b iUyFmcs18: 9SHQ glG RnHoKwT.O2w63mj9W1bYZolW S;l1AOsx2JtSmTCaXCiJ0wDWR9YTjD7TP6mripW ooLsLM1B EIdnNS7v5eaUw mTRXH 9W38mtfpV3K3 NAUy9n.v:N,MSmY,CEYr.DDWpVjhEuWTYRl 3rM3YJ vh6,INfWSiBBDGk44Z;Id z8jaa:tVuwVlfw,G.v6bjr SM2 D: ZXt6:1BcmDSibcfl07fyo9M1lR7flDpuw mIdHhuIEgJ VHidZYv;: Trx read view will not see trx with id >= 0 1262542, sees < 0 1262542 -------- 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 204 OS file reads, 85120 OS file writes, 9831 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 1155127, used cells 260, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 3450950648 Log flushed up to 0 3450950648 Last checkpoint at 0 3449011516 0 pending log writes, 0 pending chkp writes 6802 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 588639650; in additional pool allocated 939264 Buffer pool size 32000 Free buffers 25117 Database pages 6881 Modified db pages 67 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages read 191, created 11352, written 75792 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 5480, state: purging Number of rows inserted 348999, updated 0, deleted 0, read 67737 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.03 sec) mysql> 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). 4864 - 05 threads running, 0273354 successful queries. 0000229 failed queries (0.000000 QPS). i|1|set global innodb_thread_concurrency=999 i|1|set global innodb_max_dirty_pages_pct=100 i|1|set foreign_key_checks=0 i|1|set global innodb_flush_log_at_trx_commit=0 i|1|drop table if exists t1 i|1|drop table if exists t2 i|1|drop table if exists t3 i|1|create table t1(a int not null auto_increment primary key,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)))engine=innodb i|1|create table t2(a int not null auto_increment primary key,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)))engine=innodb i|1|create table t3(a int not null auto_increment primary key,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)))engine=innodb i|1|start transaction i|1000|insert into t3 set b=repeat('a',20000),c=?|int i|1|commit i|1|select * from t3 n|1|select * from t3 limit 99 n|1..100|show keys from t1 n|1..100|show keys from t2 n|1|set foreign_key_checks=0 n|1|start transaction #n|1..10|update t1 set b=''| #n|1..10|update t2 set b=''| n|1..1000|insert into t1 set b='?',c=?|text,int n|1..1000|insert into t2 set b='?',c=?|text,int n|1|commit n|1|rollback n|1..100|analyze table t1,t2 n|1..100|truncate t1 n|1..100|truncate t2 n|1|select * from information_schema.statistics where table_schema='test' n|1|select * from information_schema.tables where table_schema='test'