071109 8:09:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 071109 8:09:56 InnoDB: Starting shutdown... 071109 8:09:59 InnoDB: Shutdown completed; log sequence number 560 1550947293 071109 8:09:59 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete InnoDB: The first specified data file D:\MySQL Datafiles\ibdata1 did not exist: InnoDB: a new database to be created! 071109 8:12:39 InnoDB: Setting file D:\MySQL Datafiles\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 071109 8:12:39 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 170 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 071109 8:12:44 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 170 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 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 071109 8:12:51 InnoDB: Started; log sequence number 0 0 071109 8:12:51 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.21-pro-nt-log' socket: '' port: 3306 MySQL Pro (Commercial) 071109 8:19:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 071109 8:19:16 InnoDB: Starting shutdown... 071109 8:19:20 InnoDB: Shutdown completed; log sequence number 0 163039 071109 8:19:20 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 071109 8:19:24 InnoDB: Started; log sequence number 0 163039 071109 8:19:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.21-pro-nt-log' socket: '' port: 3306 MySQL Pro (Commercial) InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 242.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:12:12 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 30 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 246.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18205 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 94 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18193, not started, OS thread id 1336 MySQL thread id 12, query id 54579 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18196, not started, OS thread id 1948 MySQL thread id 10, query id 54580 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18183, not started, OS thread id 2256 MySQL thread id 5, query id 54318 rscvsp1 150.1.43.135 root ---TRANSACTION 0 17262, not started, OS thread id 776 MySQL thread id 4, query id 52916 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18204, not started, OS thread id 4040 MySQL thread id 1, query id 54576 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 246 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264472 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 771, node heap has 2 buffer(s) 0.07 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100631801 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14232 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1067 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242124, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4262, updated 5785, deleted 0, read 141352 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.13 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:12:28 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 262.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18205 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 94 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18193, not started, OS thread id 1336 MySQL thread id 12, query id 54611 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18196, not started, OS thread id 1948 MySQL thread id 10, query id 54612 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18183, not started, OS thread id 2256 MySQL thread id 5, query id 54318 rscvsp1 150.1.43.135 root ---TRANSACTION 0 17262, not started, OS thread id 776 MySQL thread id 4, query id 52916 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18204, not started, OS thread id 4040 MySQL thread id 1, query id 54576 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 262 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264472 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 771, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100631801 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14232 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1067 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242124, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4262, updated 5785, deleted 0, read 141352 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 3804 has waited at .\btr\btr0cur.c line 424 for 274.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:12:44 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 278.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18207 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 94 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18193, not started, OS thread id 1336 MySQL thread id 12, query id 54645 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18196, not started, OS thread id 1948 MySQL thread id 10, query id 54646 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18183, not started, OS thread id 2256 MySQL thread id 5, query id 54318 rscvsp1 150.1.43.135 root ---TRANSACTION 0 17262, not started, OS thread id 776 MySQL thread id 4, query id 52916 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18206, not started, OS thread id 4040 MySQL thread id 1, query id 54638 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 278 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264472 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 771, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100631801 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14232 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1067 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242124, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4262, updated 5785, deleted 0, read 141356 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:13:00 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 294.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18207 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 94 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18193, not started, OS thread id 1336 MySQL thread id 12, query id 54677 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18196, not started, OS thread id 1948 MySQL thread id 10, query id 54678 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18183, not started, OS thread id 2256 MySQL thread id 5, query id 54318 rscvsp1 150.1.43.135 root ---TRANSACTION 0 17262, not started, OS thread id 776 MySQL thread id 4, query id 52916 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18206, not started, OS thread id 4040 MySQL thread id 1, query id 54638 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 294 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264472 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 771, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100631801 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14232 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1067 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242124, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4262, updated 5785, deleted 0, read 141356 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 3804 has waited at .\btr\btr0cur.c line 424 for 306.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:13:16 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 310.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18276 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 102 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18261, not started, OS thread id 1336 MySQL thread id 12, query id 54794 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18264, not started, OS thread id 1948 MySQL thread id 10, query id 54795 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18275, not started, OS thread id 2256 MySQL thread id 5, query id 54793 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18254, not started, OS thread id 4040 MySQL thread id 1, query id 54806 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 310 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264500 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 783, node heap has 2 buffer(s) 2.69 hash searches/s, 7.44 non-hash searches/s --- LOG --- Log sequence number 0 4100643506 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14260 log i/o's done, 1.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1073 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242125, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4282, updated 5793, deleted 0, read 141509 1.25 inserts/s, 0.50 updates/s, 0.00 deletes/s, 9.56 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:13:32 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 326.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18355 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 112 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18341, not started, OS thread id 1336 MySQL thread id 12, query id 54944 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18344, not started, OS thread id 1948 MySQL thread id 10, query id 54945 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18354, not started, OS thread id 2256 MySQL thread id 5, query id 54943 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18254, not started, OS thread id 4040 MySQL thread id 1, query id 54806 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 326 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264538 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.37 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 783, node heap has 2 buffer(s) 6.19 hash searches/s, 20.31 non-hash searches/s --- LOG --- Log sequence number 0 4100656714 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14298 log i/o's done, 2.37 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1073 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242125, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4304, updated 5803, deleted 0, read 141837 1.37 inserts/s, 0.62 updates/s, 0.00 deletes/s, 20.50 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 338.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:13:48 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 342.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18442 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 123 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18441, not started, OS thread id 1336 MySQL thread id 12, query id 55097 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18438, not started, OS thread id 1948 MySQL thread id 10, query id 55092 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18435, not started, OS thread id 2256 MySQL thread id 5, query id 55087 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18398, not started, OS thread id 4040 MySQL thread id 1, query id 55019 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 342 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264584 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.87 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 840, node heap has 2 buffer(s) 6.06 hash searches/s, 39.87 non-hash searches/s --- LOG --- Log sequence number 0 4100671965 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14344 log i/o's done, 2.87 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1073 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242125, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4329, updated 5814, deleted 0, read 142469 1.56 inserts/s, 0.69 updates/s, 0.00 deletes/s, 39.50 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:14:04 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 358.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18519 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 133 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18517, not started, OS thread id 1336 MySQL thread id 12, query id 55227 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18513, not started, OS thread id 1948 MySQL thread id 10, query id 55229 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18518, not started, OS thread id 2256 MySQL thread id 5, query id 55228 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18398, not started, OS thread id 4040 MySQL thread id 1, query id 55019 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 358 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264628 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 864, node heap has 2 buffer(s) 39.75 hash searches/s, 11.19 non-hash searches/s --- LOG --- Log sequence number 0 4100686683 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14388 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1074 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242126, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4353, updated 5824, deleted 0, read 143186 1.50 inserts/s, 0.62 updates/s, 0.00 deletes/s, 44.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 370.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:14:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 374.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18594 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 144 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18583, not started, OS thread id 1336 MySQL thread id 12, query id 55351 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18580, not started, OS thread id 1948 MySQL thread id 10, query id 55355 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18593, not started, OS thread id 2256 MySQL thread id 5, query id 55354 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18549, not started, OS thread id 4040 MySQL thread id 1, query id 55278 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 374 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264672 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 886, node heap has 2 buffer(s) 36.69 hash searches/s, 9.87 non-hash searches/s --- LOG --- Log sequence number 0 4100700777 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14432 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1074 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242126, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4375, updated 5835, deleted 0, read 143849 1.37 inserts/s, 0.69 updates/s, 0.00 deletes/s, 41.43 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:14:36 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 390.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18669 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 155 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18654, not started, OS thread id 1336 MySQL thread id 12, query id 55476 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18651, not started, OS thread id 1948 MySQL thread id 10, query id 55475 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18668, not started, OS thread id 2256 MySQL thread id 5, query id 55484 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18549, not started, OS thread id 4040 MySQL thread id 1, query id 55278 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 390 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264716 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 909, node heap has 2 buffer(s) 49.93 hash searches/s, 12.25 non-hash searches/s --- LOG --- Log sequence number 0 4100715852 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14476 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1075 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242127, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4398, updated 5846, deleted 0, read 144754 1.44 inserts/s, 0.69 updates/s, 0.00 deletes/s, 56.56 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 402.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:14:52 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 406.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6879, rounds 55472, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18763 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 165 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18761, not started, OS thread id 1336 MySQL thread id 12, query id 55641 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18758, not started, OS thread id 1948 MySQL thread id 10, query id 55636 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18762, not started, OS thread id 2256 MySQL thread id 5, query id 55647 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18697, not started, OS thread id 4040 MySQL thread id 1, query id 55528 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 406 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1315 OS file reads, 264760 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 932, node heap has 2 buffer(s) 109.31 hash searches/s, 20.62 non-hash searches/s --- LOG --- Log sequence number 0 4100730263 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14520 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1076 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1293, created 242128, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4421, updated 5856, deleted 0, read 146725 1.44 inserts/s, 0.62 updates/s, 0.00 deletes/s, 123.18 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:15:08 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 422.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 18891 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 175 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18790, not started, OS thread id 1336 MySQL thread id 12, query id 55806 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18787, not started, OS thread id 1948 MySQL thread id 10, query id 55802 rscvsv1 150.1.43.137 root ---TRANSACTION 0 18890, not started, OS thread id 2256 MySQL thread id 5, query id 55809 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18796, not started, OS thread id 4040 MySQL thread id 1, query id 55701 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 422 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264790 OS file writes, 10080 OS fsyncs 2.81 reads/s, 16384 avg bytes/read, 1.87 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 959, node heap has 2 buffer(s) 89.43 hash searches/s, 10.56 non-hash searches/s --- LOG --- Log sequence number 0 4100763084 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14550 log i/o's done, 1.87 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 2.81 reads/s, 0.06 creates/s, 0.00 writes/s Buffer pool hit rate 991 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6052, deleted 0, read 147857 1.69 inserts/s, 12.25 updates/s, 0.00 deletes/s, 70.75 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 434.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:15:24 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 438.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19040 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 175 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 18790, not started, OS thread id 1336 MySQL thread id 12, query id 55997 rscvsv2 150.1.43.138 root ---TRANSACTION 0 18787, not started, OS thread id 1948 MySQL thread id 10, query id 55993 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19039, not started, OS thread id 2256 MySQL thread id 5, query id 56001 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18913, not started, OS thread id 4040 MySQL thread id 1, query id 55910 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 438 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264790 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 959, node heap has 2 buffer(s) 9.31 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763094 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14550 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6052, deleted 0, read 148008 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 9.44 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:15:40 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 454.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19104 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56102 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56101 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19099, not started, OS thread id 4040 MySQL thread id 1, query id 56078 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 454 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.25 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 26.56 hash searches/s, 0.81 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.25 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148457 0.00 inserts/s, 0.12 updates/s, 0.00 deletes/s, 28.06 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 466.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:15:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 470.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19106 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56136 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56135 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19105, not started, OS thread id 4040 MySQL thread id 1, query id 56104 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 470 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148461 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:16:12 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 486.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19108 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56170 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56169 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19107, not started, OS thread id 4040 MySQL thread id 1, query id 56166 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 486 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148465 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 498.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:16:28 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 502.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19108 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56202 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56201 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19107, not started, OS thread id 4040 MySQL thread id 1, query id 56166 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 502 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148465 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:16:44 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 518.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19110 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56236 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56235 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19109, not started, OS thread id 4040 MySQL thread id 1, query id 56228 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 518 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148469 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 530.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:17:00 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 534.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19110 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56268 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56267 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19109, not started, OS thread id 4040 MySQL thread id 1, query id 56228 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 534 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148469 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:17:16 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 550.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19112 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56302 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56301 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19111, not started, OS thread id 4040 MySQL thread id 1, query id 56313 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 550 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148473 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 562.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:17:32 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 566.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19112 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 177 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19093, not started, OS thread id 1336 MySQL thread id 12, query id 56345 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19103, not started, OS thread id 1948 MySQL thread id 10, query id 56344 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19090, not started, OS thread id 2256 MySQL thread id 5, query id 56068 rscvsp1 150.1.43.135 root ---TRANSACTION 0 18209, not started, OS thread id 776 MySQL thread id 4, query id 54694 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19111, not started, OS thread id 4040 MySQL thread id 1, query id 56313 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 566 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264794 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 958, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100763947 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14554 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4448, updated 6054, deleted 0, read 148473 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:17:48 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 582.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19157 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 181 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19150, not started, OS thread id 1336 MySQL thread id 12, query id 56432 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19146, not started, OS thread id 1948 MySQL thread id 10, query id 56431 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19156, not started, OS thread id 2256 MySQL thread id 5, query id 56430 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19137, not started, OS thread id 4040 MySQL thread id 1, query id 56400 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 582 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264806 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 967, node heap has 2 buffer(s) 1.81 hash searches/s, 3.00 non-hash searches/s --- LOG --- Log sequence number 0 4100769401 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14566 log i/o's done, 0.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1077 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4457, updated 6058, deleted 0, read 148590 0.56 inserts/s, 0.25 updates/s, 0.00 deletes/s, 7.31 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 594.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:18:04 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 598.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19237 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 191 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19226, not started, OS thread id 1336 MySQL thread id 12, query id 56572 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19231, not started, OS thread id 1948 MySQL thread id 10, query id 56571 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19236, not started, OS thread id 2256 MySQL thread id 5, query id 56570 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19137, not started, OS thread id 4040 MySQL thread id 1, query id 56400 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 598 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264848 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.62 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 971, node heap has 2 buffer(s) 6.62 hash searches/s, 16.56 non-hash searches/s --- LOG --- Log sequence number 0 4100783904 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14608 log i/o's done, 2.62 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 1 Database pages 21693 Modified db pages 1078 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4481, updated 6068, deleted 0, read 148857 1.50 inserts/s, 0.62 updates/s, 0.00 deletes/s, 16.69 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:18:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 614.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19317 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 202 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19305, not started, OS thread id 1336 MySQL thread id 12, query id 56707 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19299, not started, OS thread id 1948 MySQL thread id 10, query id 56704 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19315, not started, OS thread id 2256 MySQL thread id 5, query id 56706 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19265, not started, OS thread id 4040 MySQL thread id 1, query id 56619 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 614 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264892 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 971, node heap has 2 buffer(s) 3.87 hash searches/s, 27.00 non-hash searches/s --- LOG --- Log sequence number 0 4100798310 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14652 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 1 Database pages 21693 Modified db pages 1078 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4504, updated 6079, deleted 0, read 149260 1.44 inserts/s, 0.69 updates/s, 0.00 deletes/s, 25.19 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 626.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:18:36 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 630.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19405 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 212 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19404, not started, OS thread id 1336 MySQL thread id 12, query id 56866 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19399, not started, OS thread id 1948 MySQL thread id 10, query id 56855 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19401, not started, OS thread id 2256 MySQL thread id 5, query id 56861 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19265, not started, OS thread id 4040 MySQL thread id 1, query id 56619 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 630 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264932 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.50 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1034, node heap has 2 buffer(s) 35.62 hash searches/s, 23.87 non-hash searches/s --- LOG --- Log sequence number 0 4100812253 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14692 log i/o's done, 2.50 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 1 Database pages 21693 Modified db pages 1079 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4527, updated 6089, deleted 0, read 150105 1.44 inserts/s, 0.62 updates/s, 0.00 deletes/s, 52.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:18:52 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 646.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19489 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 223 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19483, not started, OS thread id 1336 MySQL thread id 12, query id 57006 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19479, not started, OS thread id 1948 MySQL thread id 10, query id 57003 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19488, not started, OS thread id 2256 MySQL thread id 5, query id 57005 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19422, not started, OS thread id 4040 MySQL thread id 1, query id 56895 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 646 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 264978 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.87 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1066, node heap has 2 buffer(s) 43.18 hash searches/s, 18.19 non-hash searches/s --- LOG --- Log sequence number 0 4100828508 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14738 log i/o's done, 2.87 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 1 Database pages 21693 Modified db pages 1079 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242129, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4555, updated 6100, deleted 0, read 150978 1.75 inserts/s, 0.69 updates/s, 0.00 deletes/s, 54.56 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 658.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:19:08 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 662.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19569 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 233 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19563, not started, OS thread id 1336 MySQL thread id 12, query id 57140 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19559, not started, OS thread id 1948 MySQL thread id 10, query id 57143 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19568, not started, OS thread id 2256 MySQL thread id 5, query id 57142 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19422, not started, OS thread id 4040 MySQL thread id 1, query id 56895 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 662 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265022 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.75 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1090, node heap has 2 buffer(s) 63.93 hash searches/s, 12.69 non-hash searches/s --- LOG --- Log sequence number 0 4100843727 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14782 log i/o's done, 2.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1080 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242130, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4579, updated 6110, deleted 0, read 152105 1.50 inserts/s, 0.62 updates/s, 0.00 deletes/s, 70.43 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:19:24 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4242, signal count 4057 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 678.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6882, rounds 55474, OS waits 1922 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19648 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 244 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19633, not started, OS thread id 1336 MySQL thread id 12, query id 57282 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19639, not started, OS thread id 1948 MySQL thread id 10, query id 57284 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19582, not started, OS thread id 4040 MySQL thread id 1, query id 57226 rscvss 150.1.43.103 root ---TRANSACTION 0 19647, ACTIVE (PREPARED) 0 sec, OS thread id 2256 preparing mysql tables in use 1, locked 1 2 lock struct(s), heap size 320, undo log entries 2 MySQL thread id 5, query id 57285 rscvsp1 150.1.43.135 root update INSERT INTO TDirisObjects (nProductId, nXPosMm, nYPosMm, nXSizeMm, nYSizeMm, nClassCode, nGradingType, blobFeaVect) VALUES (20, 1208, 96784, 40, 608, 1, 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0à¢@\0\0\0\0\0¡A\0\0\0\0\0\0T@\0\0\0\0\0\0“@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0¬š@\0\0\0\0\0 ¡@©ïlÔw6è?\0\0\0\0\0ö®@\0\0\0\0\0\0\0\0àbEGh™@\0\0\0\0\0\0\0\07®›ùø\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0@ÊÆR­ä$@\0\0\0\0\0\0\0\0\0\0\0\0\0\0(@^Cy\rå5„?\0\0\0\0\0\0\0@'),(20, 1672, 96784, 56, 624, 1, 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0 ª@\0\0\0\0\0¡A\0\0\0\0\0\0\\@\0\0\0\0\0€“@\0\0\0\0\0\0\0 ---TRANSACTION 0 17350, ACTIVE 678 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 1 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265063 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.56 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1114, node heap has 2 buffer(s) 64.12 hash searches/s, 17.12 non-hash searches/s --- LOG --- Log sequence number 0 4100858395 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14823 log i/o's done, 2.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 359552 Buffer pool size 21696 Free buffers 1 Database pages 21693 Modified db pages 1081 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242130, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4603, updated 6121, deleted 0, read 153309 1.50 inserts/s, 0.69 updates/s, 0.00 deletes/s, 75.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 690.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:19:40 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 694.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19751 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 258 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19710, not started, OS thread id 1336 MySQL thread id 12, query id 57434 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19705, not started, OS thread id 1948 MySQL thread id 10, query id 57430 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19750, not started, OS thread id 2256 MySQL thread id 5, query id 57439 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19714, not started, OS thread id 4040 MySQL thread id 1, query id 57403 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 694 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265110 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.94 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1143, node heap has 2 buffer(s) 122.74 hash searches/s, 17.50 non-hash searches/s --- LOG --- Log sequence number 0 4100894678 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14870 log i/o's done, 2.94 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 329344 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 0.00 reads/s, 0.06 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6320, deleted 0, read 155066 1.87 inserts/s, 12.44 updates/s, 0.00 deletes/s, 109.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:19:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 710.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 19900 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 258 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 19710, not started, OS thread id 1336 MySQL thread id 12, query id 57614 rscvsv2 150.1.43.138 root ---TRANSACTION 0 19705, not started, OS thread id 1948 MySQL thread id 10, query id 57611 rscvsv1 150.1.43.137 root ---TRANSACTION 0 19899, not started, OS thread id 2256 MySQL thread id 5, query id 57620 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19755, not started, OS thread id 4040 MySQL thread id 1, query id 57445 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 710 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265110 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1143, node heap has 2 buffer(s) 9.31 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100894678 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14870 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 334208 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6320, deleted 0, read 155217 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 9.44 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 722.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:20:12 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 726.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20024 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57781 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57780 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20023, not started, OS thread id 4040 MySQL thread id 1, query id 57778 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 726 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.25 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 30.00 hash searches/s, 1.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.25 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155726 0.00 inserts/s, 0.12 updates/s, 0.00 deletes/s, 31.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:20:28 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 742.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20024 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57813 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57812 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20023, not started, OS thread id 4040 MySQL thread id 1, query id 57778 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 742 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155726 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 3804 has waited at .\btr\btr0cur.c line 424 for 754.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:20:44 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 758.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20026 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57847 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57846 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20025, not started, OS thread id 4040 MySQL thread id 1, query id 57840 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 758 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155730 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:21:00 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 774.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20026 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57879 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57878 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20025, not started, OS thread id 4040 MySQL thread id 1, query id 57840 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 774 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155730 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 3804 has waited at .\btr\btr0cur.c line 424 for 786.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 071109 13:21:16 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 790.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20028 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57913 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57912 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20027, not started, OS thread id 4040 MySQL thread id 1, query id 57924 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 790 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 0.12 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 0.00 reads/s, 0.00 creates/s, 0.00 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155734 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.25 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 071109 13:21:32 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4246, signal count 4061 --Thread 3804 has waited at .\btr\btr0cur.c line 424 for 806.00 seconds the semaphore: X-lock on RW-latch at 168FBE10 created in file .\buf\buf0buf.c line 490 a writer (thread id 3804) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file .\btr\btr0cur.c line 424 Last time write locked in file .\btr\btr0cur.c line 3442 Mutex spin waits 6889, rounds 55554, OS waits 1925 RW-shared spins 4048, OS waits 2039; RW-excl spins 18, OS waits 17 ------------ TRANSACTIONS ------------ Trx id counter 0 20028 Purge done for trx's n:o < 0 16530 undo n:o < 0 0 History list length 260 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 20021, not started, OS thread id 1336 MySQL thread id 12, query id 57956 rscvsv2 150.1.43.138 root ---TRANSACTION 0 20011, not started, OS thread id 1948 MySQL thread id 10, query id 57955 rscvsv1 150.1.43.137 root ---TRANSACTION 0 20008, not started, OS thread id 2256 MySQL thread id 5, query id 57758 rscvsp1 150.1.43.135 root ---TRANSACTION 0 19120, not started, OS thread id 776 MySQL thread id 4, query id 56380 rscvsp1 150.1.43.135 root ---TRANSACTION 0 20027, not started, OS thread id 4040 MySQL thread id 1, query id 57924 rscvss 150.1.43.103 root ---TRANSACTION 0 17350, ACTIVE 806 sec, OS thread id 3804 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320 MySQL thread id 6, query id 53037 rscvsp2 150.1.43.136 root update INSERT TAcqData SET nAcqDataId = 939, nProductId = 18, nFrameNr = 4, blobImage = 'ÿØÿà\0JFIF\0\0\0\0\0\0ÿþ\0-Intel(R) JPEG Library, version [2.0.18.50]\0ÿÛ\0C\0  \n \nÿÛ\0CÿÄ\0Ò\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa\"q2‘¡#B±ÁRÑð$3br‚ \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÀ\0 \0€\0\0ÿÚ\0\0\0\0?\0ˆ«,!ü±°¶ÎHv qÆ}hÀ4™ÃuVÁî:žüÿ\0õ© -------- 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: 1, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1360 OS file reads, 265114 OS file writes, 10080 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 for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1407101, used cells 1142, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 4100895541 Log flushed up to 0 4100494921 Last checkpoint at 0 4082935002 0 pending log writes, 0 pending chkp writes 14874 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 386378408; in additional pool allocated 343680 Buffer pool size 21696 Free buffers 0 Database pages 21694 Modified db pages 1082 Pending reads 0 Pending writes: LRU 0, flush list 114, single page 0 Pages read 1338, created 242131, written 242433 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 3584, state: flushing buffer pool pages Number of rows inserted 4633, updated 6322, deleted 0, read 155734 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: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 071109 13:21:42InnoDB: Assertion failure in thread 288 in file .\srv\srv0srv.c line 2093 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 554 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 338 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4023 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 415 InnoDB: Thread 4040 stopped in file .\buf\buf0buf.c line 1135 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 392 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 416 InnoDB: Thread 3584 stopped in file .\buf\buf0flu.c line 363 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 554 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 338 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 3902 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 4040 stopped in file .\buf\buf0buf.c line 1135 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 300 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4002 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 4040 stopped in file .\btr\btr0cur.c line 143 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 392 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4006 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 83 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 338 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4007 InnoDB: Thread 3468 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 98 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 300 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3468 stopped in file .\os\os0file.c line 3584 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 623 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 392 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 3468 stopped in file .\srv\srv0srv.c line 646 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 624 InnoDB: Thread 776 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\mem0mem.ic line 512 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 623 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 338 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 624 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 392 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 4040 stopped in file .\row\row0sel.c line 2081 InnoDB: Thread 776 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\mem0mem.ic line 512 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 4040 stopped in file .\row\row0sel.c line 2212 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 338 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 236 InnoDB: Thread 776 stopped in file .\mem\mem0pool.c line 392 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 237 InnoDB: Thread 776 stopped in file .\row\row0mysql.c line 637 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 83 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 4040 stopped in file .\btr\btr0pcur.c line 98 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\page0page.ic line 633 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\page0page.ic line 644 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4023 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 623 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 3584 stopped in file .\buf\buf0flu.c line 363 InnoDB: Thread 4040 stopped in file e:\build\mysqlcom-pro-5.0.21-build\mysqlcom-5.0.21\innobase\include\buf0buf.ic line 624 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 3902 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 4040 stopped in file .\trx\trx0trx.c line 1601 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4002 InnoDB: Thread 4040 stopped in file .\sync\sync0arr.c line 336 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4006 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 4040 stopped in file .\sync\sync0arr.c line 337 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 536 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4007 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3468 stopped in file .\fil\fil0fil.c line 4135 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3468 stopped in file .\srv\srv0srv.c line 646 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3468 stopped in file .\fil\fil0fil.c line 3801 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 3468 stopped in file .\srv\srv0srv.c line 646 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 2256 stopped in file .\ha_innodb.cpp line 2016 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3468 stopped in file .\buf\buf0buf.c line 1822 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 2256 stopped in file .\thr\thr0loc.c line 212 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 3468 stopped in file .\buf\buf0flu.c line 185 InnoDB: Thread 2872 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 2256 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 3468 stopped in file .\buf\buf0flu.c line 189 InnoDB: Thread 2872 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 2256 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 336 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 373 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 337 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 313 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 336 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 2872 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 317 InnoDB: Thread 4040 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3380 stopped in file .\sync\sync0arr.c line 337 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4023 InnoDB: Thread 2256 stopped in file .\sync\sync0sync.c line 270 InnoDB: Thread 3380 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 4040 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\buf\buf0flu.c line 363 InnoDB: Thread 2256 stopped in file .\sync\sync0sync.c line 271 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 3902 InnoDB: Thread 2256 stopped in file .\sync\sync0sync.c line 279 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4002 InnoDB: Thread 2256 stopped in file .\sync\sync0sync.c line 283 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4006 InnoDB: Thread 2256 stopped in file .\sync\sync0sync.c line 286 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 4040 stopped in file .\sync\sync0arr.c line 401 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4007 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 321 InnoDB: Thread 4040 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 3468 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 322 InnoDB: Thread 3468 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 2256 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3468 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 2256 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3468 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 333 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 211 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 334 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 212 InnoDB: Thread 3804 stopped in file .\os\os0sync.c line 309 InnoDB: Thread 3584 stopped in file .\os\os0file.c line 2740 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 336 InnoDB: Thread 3804 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 240 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 337 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 242 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 339 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 2872 stopped in file .\os\os0sync.c line 492 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 513 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 340 InnoDB: Thread 2872 stopped in file .\os\os0sync.c line 495 InnoDB: Thread 3468 stopped in file .\srv\srv0srv.c line 646 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 515 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 342 InnoDB: Thread 3468 stopped in file .\os\os0file.c line 2999 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\os\os0sync.c line 519 InnoDB: Thread 2256 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3468 stopped in file .\srv\srv0srv.c line 646 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4023 InnoDB: Thread 2256 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 408 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\buf\buf0flu.c line 363 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 348 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 409 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 3902 InnoDB: Thread 2256 stopped in file .\mem\mem0mem.c line 290 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 415 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 126 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4002 InnoDB: Thread 2256 stopped in file .\mem\mem0pool.c line 516 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 416 InnoDB: Thread 2872 stopped in file .\sync\sync0arr.c line 127 InnoDB: Thread 3584 stopped in file .\fil\fil0fil.c line 4006 InnoDB: Thread 2256 stopped in file .\trx\trx0trx.c line 356 InnoDB: Thread 3468 stopped in file .\os\os0sync.c line 487 InnoDB: Thread 2872 stopped in