InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 070910 14:05:49 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070910 14:05:49 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 070910 14:05:49 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070910 14:05:50 InnoDB: Started; log sequence number 0 0 070910 14:05:50 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 070910 19:46:56 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 070910 19:46:58 InnoDB: Starting shutdown... 070910 19:47:02 InnoDB: Shutdown completed; log sequence number 0 96615 070910 19:47:02 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 070910 19:47:06 InnoDB: Started; log sequence number 0 96615 070910 19:47:06 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 070910 19:48:37 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 070910 19:48:37 InnoDB: Starting shutdown... 070910 19:48:40 InnoDB: Shutdown completed; log sequence number 0 4275508 070910 19:48:40 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 070910 20:00:46 InnoDB: Started; log sequence number 0 4275508 070910 20:00:46 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 070913 19:59:02 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 070913 19:59:02 InnoDB: Starting shutdown... 070913 19:59:05 InnoDB: Shutdown completed; log sequence number 1 2547273820 070913 19:59:05 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 070913 19:59:44 InnoDB: Started; log sequence number 1 2547273820 070913 19:59:45 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 070913 20:52:16 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 070913 20:52:16 InnoDB: Starting shutdown... 070913 20:52:19 InnoDB: Shutdown completed; log sequence number 1 2547273820 070913 20:52:19 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 070914 11:10:38 InnoDB: Started; log sequence number 1 2547273820 070914 11:10:38 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\btr\btr0cur.c line 424 for 241.00 seconds the semaphore: X-lock on RW-latch at 0112A8D4 created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\btr\btr0cur.c line 424 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:42:06 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 19 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140382, signal count 1140350 --Thread 560 has waited at .\btr\btr0cur.c line 424 for 246.00 seconds the semaphore: X-lock on RW-latch at 0112A8D4 created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\btr\btr0cur.c line 424 Mutex spin waits 0, rounds 558495, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3531, OS waits 255 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 246 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 31, query id 215960 localhost 127.0.0.1 root update INSERT INTO `Capture` (`IdSystemFPS`, `Memo`, `InitialTime`) VALUES (3, 'Captura automática', 1190367480) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130412 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 28, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233100514 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 25472460; in additional pool allocated 1462784 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 104 Pending reads 0 Pending writes: LRU 0, flush list 103, single page 0 Pages read 2579204, created 2773451, written 2897152 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30216, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 070921 11:42:22 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140383, signal count 1140351 --Thread 560 has waited at .\btr\btr0cur.c line 424 for 2.00 seconds the semaphore: X-lock on RW-latch at 0112C4AC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\btr\btr0cur.c line 424 Mutex spin waits 0, rounds 558495, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3532, OS waits 256 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 262 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 4 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 31, query id 215960 localhost 127.0.0.1 root update INSERT INTO `Capture` (`IdSystemFPS`, `Memo`, `InitialTime`) VALUES (3, 'Captura automática', 1190367480) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130418 OS file writes, 196723 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.37 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.12 non-hash searches/s --- LOG --- Log sequence number 12 2233100622 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 25472460; in additional pool allocated 1462784 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 100 Pending reads 0 Pending writes: LRU 0, flush list 97, single page 0 Pages read 2579204, created 2773451, written 2897158 0.00 reads/s, 0.00 creates/s, 0.37 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30216, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 242.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:48:46 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 75 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 257.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 646 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130424 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 98 Pending reads 0 Pending writes: LRU 0, flush list 91, single page 0 Pages read 2579204, created 2773451, written 2897164 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 274.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:49:18 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 289.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 678 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130424 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 98 Pending reads 0 Pending writes: LRU 0, flush list 91, single page 0 Pages read 2579204, created 2773451, written 2897164 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 306.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:49:50 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 321.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 710 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130424 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 98 Pending reads 0 Pending writes: LRU 0, flush list 91, single page 0 Pages read 2579204, created 2773451, written 2897164 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 338.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:50:22 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 353.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 742 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.09 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 0.00 reads/s, 0.00 creates/s, 0.09 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 370.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:50:54 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 385.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 774 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 402.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:51:26 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 417.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 806 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 434.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:51:58 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 449.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 838 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 466.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:52:30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 481.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 870 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 498.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:53:02 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 513.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 902 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 530.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:53:34 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 545.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 934 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 562.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:54:06 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 577.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 966 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 594.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:54:38 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 609.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 998 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 626.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:55:10 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 641.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1030 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130427 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 95 Pending reads 0 Pending writes: LRU 0, flush list 88, single page 0 Pages read 2579204, created 2773451, written 2897167 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 658.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:55:42 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 673.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1062 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130430 OS file writes, 196723 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.09 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 92 Pending reads 0 Pending writes: LRU 0, flush list 85, single page 0 Pages read 2579204, created 2773451, written 2897170 0.00 reads/s, 0.00 creates/s, 0.09 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 690.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:56:14 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 705.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1094 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130433 OS file writes, 196723 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.09 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 89 Pending reads 0 Pending writes: LRU 0, flush list 82, single page 0 Pages read 2579204, created 2773451, written 2897173 0.00 reads/s, 0.00 creates/s, 0.09 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 722.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:56:46 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 737.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1126 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130433 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 89 Pending reads 0 Pending writes: LRU 0, flush list 82, single page 0 Pages read 2579204, created 2773451, written 2897173 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 754.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:57:18 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 769.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1158 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130433 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 89 Pending reads 0 Pending writes: LRU 0, flush list 82, single page 0 Pages read 2579204, created 2773451, written 2897173 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 786.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 070921 11:57:50 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1140386, signal count 1140354 --Thread 560 has waited at .\fsp\fsp0fsp.c line 686 for 801.00 seconds the semaphore: X-lock on RW-latch at 0110E3BC created in file .\buf\buf0buf.c line 497 a writer (thread id 560) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\buf\buf0flu.c line 585 Last time write locked in file .\fsp\fsp0fsp.c line 686 Mutex spin waits 0, rounds 558532, OS waits 7358 RW-shared spins 2268026, OS waits 1132198; RW-excl spins 3535, OS waits 259 ------------ TRANSACTIONS ------------ Trx id counter 0 24359 Purge done for trx's n:o < 0 24273 undo n:o < 0 0 History list length 10 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 24302, not started, OS thread id 476 MySQL thread id 30, query id 215375 localhost 127.0.0.1 root ---TRANSACTION 0 24358, ACTIVE 1190 sec, OS thread id 560 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 7 lock struct(s), heap size 320, undo log entries 3 MySQL thread id 31, query id 215967 localhost 127.0.0.1 root update INSERT INTO `CaptureData` (`IdSource`, `IdCapture`, `Data`) VALUES (4, 11537, ?) -------- 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: 32, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2579214 OS file reads, 3130433 OS file writes, 196723 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, 274 inserts, 274 merged recs, 274 merges Hash table size 70657, used cells 29, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 12 2233101601 Log flushed up to 12 2233100514 Last checkpoint at 12 2231542708 0 pending log writes, 0 pending chkp writes 133589 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26973908; in additional pool allocated 1474816 Buffer pool size 1088 Free buffers 0 Database pages 1087 Modified db pages 89 Pending reads 0 Pending writes: LRU 0, flush list 82, single page 0 Pages read 2579204, created 2773451, written 2897173 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 1 read views open inside InnoDB Main thread id 1884, state: flushing buffer pool pages Number of rows inserted 30218, updated 1, deleted 0, read 630221 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 071003 11:14:24 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 071003 11:14:25 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 12 2231542708. InnoDB: Doing recovery: scanned up to log sequence number 12 2233100514 071003 11:14:25 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 071003 11:14:25 InnoDB: Started; log sequence number 12 2233100514 071003 11:14:26 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 071008 10:42:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 071008 10:42:20 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 12 2694338654. InnoDB: Doing recovery: scanned up to log sequence number 12 2694338654 071008 10:42:20 InnoDB: Started; log sequence number 12 2694338654 071008 10:42:20 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)