InnoDB: Warning: a long semaphore wait: --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:53:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 14 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 242.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 238.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 242 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19288 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92495631 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 279.34 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93914780, not young 0 279.34 youngs/s, 0.00 non-youngs/s Pages read 92495631, created 4638924, written 181512748 279.34 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[18479]:cur[36], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:53:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 262.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 258.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 262 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19308 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92500799 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 258.39 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93919948, not young 0 258.39 youngs/s, 0.00 non-youngs/s Pages read 92500799, created 4638924, written 181512748 258.39 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[18479]:cur[5204], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 268.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:53:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 282.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 278.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 282 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19328 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92505848 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 252.44 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93924997, not young 0 252.44 youngs/s, 0.00 non-youngs/s Pages read 92505848, created 4638924, written 181512748 252.44 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 1.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[26153]:cur[2300], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:54:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 302.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 298.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 302 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19348 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92510732 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 244.19 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93929881, not young 0 244.19 youngs/s, 0.00 non-youngs/s Pages read 92510732, created 4638924, written 181512748 244.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.35/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[26153]:cur[7184], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 299.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:54:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 322.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 318.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 322 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19368 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92515838 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 255.29 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93934987, not young 0 255.29 youngs/s, 0.00 non-youngs/s Pages read 92515838, created 4638924, written 181512748 255.29 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[33522]:cur[4648], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 334.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 330.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:54:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 342.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 338.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 342 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19388 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92520877 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 251.94 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93940026, not young 0 251.94 youngs/s, 0.00 non-youngs/s Pages read 92520877, created 4638924, written 181512748 251.94 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[41159]:cur[1788], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:55:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 362.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 358.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 362 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19408 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92526634 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 287.84 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93945783, not young 0 287.84 youngs/s, 0.00 non-youngs/s Pages read 92526634, created 4638924, written 181512748 287.84 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[41159]:cur[7545], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 365.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 361.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:55:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 382.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 378.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371072, rounds 409256135, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 382 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19428 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92534209 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 378.73 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93953359, not young 0 378.78 youngs/s, 0.00 non-youngs/s Pages read 92534210, created 4638924, written 181512748 378.78 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.65/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[49853]:cur[6147], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 396.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 392.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:55:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 402.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 398.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 402 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19448 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92541532 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 366.13 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93960681, not young 0 366.08 youngs/s, 0.00 non-youngs/s Pages read 92541532, created 4638924, written 181512748 366.08 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[61647]:cur[1395], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:56:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 422.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 418.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 422 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19468 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92546512 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 248.99 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93965661, not young 0 248.99 youngs/s, 0.00 non-youngs/s Pages read 92546512, created 4638924, written 181512748 248.99 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[61647]:cur[6375], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 427.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 423.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:56:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 442.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 438.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 442 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19488 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92551656 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 257.19 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93970805, not young 0 257.19 youngs/s, 0.00 non-youngs/s Pages read 92551656, created 4638924, written 181512748 257.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[69197]:cur[3655], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 458.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 454.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:56:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 462.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 458.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 462 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19508 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92556634 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 248.89 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93975783, not young 0 248.89 youngs/s, 0.00 non-youngs/s Pages read 92556634, created 4638924, written 181512748 248.89 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.75/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[76703]:cur[754], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:57:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 482.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 478.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 482 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19528 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92561824 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 259.49 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93980973, not young 0 259.49 youngs/s, 0.00 non-youngs/s Pages read 92561824, created 4638924, written 181512748 259.49 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[76703]:cur[5944], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 489.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 485.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:57:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 502.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 498.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 502 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19548 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92567071 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 262.34 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93986220, not young 0 262.34 youngs/s, 0.00 non-youngs/s Pages read 92567071, created 4638924, written 181512748 262.34 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 1.15/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[84340]:cur[3113], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 520.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 516.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:57:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 522.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 518.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 522 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19568 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92572467 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 269.79 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93991616, not young 0 269.79 youngs/s, 0.00 non-youngs/s Pages read 92572467, created 4638924, written 181512748 269.79 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[92181]:cur[246], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:58:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 542.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 538.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 542 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19588 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92580248 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 389.03 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93999397, not young 0 389.03 youngs/s, 0.00 non-youngs/s Pages read 92580248, created 4638924, written 181512748 389.03 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.85/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[92181]:cur[8027], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 551.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 547.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:58:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 562.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 558.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 562 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19608 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92587017 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 338.43 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94006166, not young 0 338.43 youngs/s, 0.00 non-youngs/s Pages read 92587017, created 4638924, written 181512748 338.43 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[103216]:cur[3325], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 582.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 578.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:59:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 40 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 602.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 598.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 602 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19648 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92597060 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 251.07 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94016209, not young 0 251.07 youngs/s, 0.00 non-youngs/s Pages read 92597060, created 4638924, written 181512748 251.07 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.75/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[111367]:cur[4801], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 613.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 609.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 8:59:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 622.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 618.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 622 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19668 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92602156 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 254.79 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94021305, not young 0 254.79 youngs/s, 0.00 non-youngs/s Pages read 92602156, created 4638924, written 181512748 254.79 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[118780]:cur[2030], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 8:59:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 642.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 638.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 642 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19688 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92607444 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 264.39 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94026593, not young 0 264.39 youngs/s, 0.00 non-youngs/s Pages read 92607444, created 4638924, written 181512748 264.39 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[118780]:cur[7318], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 644.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 640.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:00:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 18 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 662.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 658.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 662 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19708 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92613022 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 269.37 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94032171, not young 0 269.37 youngs/s, 0.00 non-youngs/s Pages read 92613022, created 4638924, written 181512748 269.37 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[126530]:cur[4757], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 675.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 671.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:00:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 682.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 678.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 682 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19728 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92619930 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 345.38 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94039079, not young 0 345.38 youngs/s, 0.00 non-youngs/s Pages read 92619930, created 4638924, written 181512748 345.38 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.65/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[135335]:cur[2480], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 9:00:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 702.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 698.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 702 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19748 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92624986 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 252.79 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94044135, not young 0 252.79 youngs/s, 0.00 non-youngs/s Pages read 92624986, created 4638924, written 181512748 252.79 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[135335]:cur[7536], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 706.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 702.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:01:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 722.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 718.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 722 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19768 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92630130 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 257.19 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94049279, not young 0 257.19 youngs/s, 0.00 non-youngs/s Pages read 92630130, created 4638924, written 181512748 257.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.15/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[143802]:cur[3881], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 737.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 733.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:01:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 742.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 738.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 742 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19788 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92635252 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 256.09 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94054401, not young 0 256.09 youngs/s, 0.00 non-youngs/s Pages read 92635252, created 4638924, written 181512748 256.09 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.40/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[151276]:cur[1092], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 9:01:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 762.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 758.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 762 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19808 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92640396 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 257.19 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94059545, not young 0 257.19 youngs/s, 0.00 non-youngs/s Pages read 92640396, created 4638924, written 181512748 257.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[151276]:cur[6236], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 768.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 764.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:02:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 782.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 778.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 782 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19828 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92645666 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 263.49 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94064815, not young 0 263.49 youngs/s, 0.00 non-youngs/s Pages read 92645666, created 4638924, written 181512748 263.49 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[158910]:cur[3488], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 799.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 795.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:02:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 802.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 798.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 802 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19848 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92651540 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 293.69 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94103061, not young 0 1912.20 youngs/s, 0.00 non-youngs/s Pages read 92651540, created 4638924, written 181512748 293.69 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 998 / 1000, young-making rate 14 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.95/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[167018]:cur[801], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 9:02:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 822.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 818.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 822 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19868 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92656915 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 268.74 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94108436, not young 0 268.74 youngs/s, 0.00 non-youngs/s Pages read 92656915, created 4638924, written 181512748 268.74 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[167018]:cur[6176], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 830.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 826.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:03:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 842.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 838.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 842 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19888 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92661876 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 248.04 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94113397, not young 0 248.04 youngs/s, 0.00 non-youngs/s Pages read 92661876, created 4638924, written 181512748 248.04 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[174997]:cur[2731], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 861.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 857.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:03:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 862.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 858.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 862 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19908 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92666823 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 247.34 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94118344, not young 0 247.34 youngs/s, 0.00 non-youngs/s Pages read 92666823, created 4638924, written 181512748 247.34 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.30/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[182202]:cur[36], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 9:03:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 882.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 878.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 882 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19928 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92673287 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 323.18 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94124808, not young 0 323.18 youngs/s, 0.00 non-youngs/s Pages read 92673287, created 4638924, written 181512748 323.18 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.75/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[182202]:cur[6500], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 892.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 888.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:04:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 902.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 898.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 902 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19948 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92683003 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 485.78 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94134524, not young 0 485.78 youngs/s, 0.00 non-youngs/s Pages read 92683003, created 4638924, written 181512748 485.78 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.05/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[193489]:cur[4534], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 120104 9:04:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 922.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 918.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 922 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19968 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92688974 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 298.54 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94140496, not young 0 298.59 youngs/s, 0.00 non-youngs/s Pages read 92688974, created 4638924, written 181512748 298.54 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[193489]:cur[10505], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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 1226463552 has waited at ./include/btr0btr.ic line 53 for 923.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 InnoDB: Warning: a long semaphore wait: --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 919.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 1, pwrites 0 ===================================== 120104 9:04:59 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1057614 1_second, 566775 sleeps, 105694 10_second, 1424 background, 1424 flush srv_master_thread log flush and writes: 585470 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3163332, signal count 5484778 --Thread 1226463552 has waited at ./include/btr0btr.ic line 53 for 942.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2aaab3deada8 created in file buf/buf0buf.c line 682 a writer (thread id 1226463552) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file btr/btr0sea.c line 880 Last time write locked in file row/row0upd.c line 1860 --Thread 1224878400 has waited at trx/trx0purge.c line 1107 for 938.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3330dae8 created in file trx/trx0purge.c line 230 a writer (thread id 1224878400) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row/row0vers.c line 520 Last time write locked in file trx/trx0purge.c line 1107 Mutex spin waits 138371073, rounds 409256146, OS waits 1821186 RW-shared spins 4848017, OS waits 1121001; RW-excl spins 2078933, OS waits 153511 Spin rounds per wait: 2.96 mutex, 11.37 RW-shared, 6.97 RW-excl ------------ TRANSACTIONS ------------ Trx id counter C35B0F01 Purge done for trx's n:o < C07AC0B3 undo n:o < 0 History list length 24127271 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION C35B0F00, ACTIVE 942 sec, process no 30587, OS thread id 1226463552 updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 6286453, query id 3956920575 Updating UPDATE tfs_sequence SET current_value = current_value + increment where name = 'seq_pid' ---TRANSACTION C07AC0B1, ACTIVE 19988 sec, process no 30587, OS thread id 1230162240 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 6286387, query id 3956920572 127.0.0.1 root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `tfs_sequence` Trx read view will not see trx with id >= C07AC0B2, sees < C07AC0B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 92694282 OS file reads, 3636751400 OS file writes, 4984349 OS fsyncs 1 pending preads, 0 pending pwrites 265.39 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 36124721, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 950465368937 Log flushed up to 950465368937 Last checkpoint at 950288146514 0 pending log writes, 0 pending chkp writes 3590165195 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 18672517120; in additional pool allocated 0 Dictionary memory allocated 47432 Buffer pool size 1114111 Free buffers 0 Database pages 1114110 Old database pages 411243 Modified db pages 55708 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94145804, not young 0 265.39 youngs/s, 0.00 non-youngs/s Pages read 92694282, created 4638924, written 181512748 265.39 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 974 / 1000, young-making rate 26 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.10/s LRU len: 1114110, unzip_LRU len: 0 I/O sum[204072]:cur[4765], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 30587, id 1224878400, state: purging Number of rows inserted 660990556, updated 1171949076, deleted 311848285, read 2333169632 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. 120104 9:05:10 InnoDB: Assertion failure in thread 1097206080 in file srv/srv0srv.c line 2293 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/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 120104 9:05:10 - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=104857600 read_buffer_size=1048576 max_used_connections=16 max_threads=1100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1350126 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = (nil) thread_stack 0x80000 /u01/mysql/libexec/mysqld(my_print_stacktrace+0x35)[0x884b95] /u01/mysql/libexec/mysqld(handle_segfault+0x31d)[0x5bcfcd] /lib64/libpthread.so.0[0x3b0340e7c0] /lib64/libc.so.6(gsignal+0x35)[0x3b02830265] /lib64/libc.so.6(abort+0x110)[0x3b02831d10] /u01/mysql/lib/mysql/plugin/ha_innodb_plugin.so[0x2aaab30c8095] /lib64/libpthread.so.0[0x3b034064a7] /lib64/libc.so.6(clone+0x6d)[0x3b028d3c2d] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 120104 09:05:12 mysqld_safe Number of processes running now: 0 120104 09:05:12 mysqld_safe mysqld restarted 120104 9:05:12 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 120104 9:05:12 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 120104 9:05:12 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 120104 9:05:13 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 950288146514 120104 9:05:13 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... 120104 9:05:13 InnoDB: Warning: allocated tablespace 9, old maximum was 0 InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 950293389312 InnoDB: Doing recovery: scanned up to log sequence number 950298632192 InnoDB: Doing recovery: scanned up to log sequence number 950303875072 InnoDB: Doing recovery: scanned up to log sequence number 950309117952 InnoDB: Doing recovery: scanned up to log sequence number 950314360832 InnoDB: Doing recovery: scanned up to log sequence number 950319603712 InnoDB: Doing recovery: scanned up to log sequence number 950324846592 InnoDB: Doing recovery: scanned up to log sequence number 950330089472 InnoDB: Doing recovery: scanned up to log sequence number 950335332352 InnoDB: Doing recovery: scanned up to log sequence number 950340575232 InnoDB: Doing recovery: scanned up to log sequence number 950345818112 InnoDB: Doing recovery: scanned up to log sequence number 950351060992 InnoDB: Doing recovery: scanned up to log sequence number 950356303872 InnoDB: Doing recovery: scanned up to log sequence number 950361546752 InnoDB: Doing recovery: scanned up to log sequence number 950366789632 InnoDB: Doing recovery: scanned up to log sequence number 950372032512 InnoDB: Doing recovery: scanned up to log sequence number 950377275392 InnoDB: Doing recovery: scanned up to log sequence number 950382518272 InnoDB: Doing recovery: scanned up to log sequence number 950387761152 InnoDB: Doing recovery: scanned up to log sequence number 950393004032 InnoDB: Doing recovery: scanned up to log sequence number 950398246912 InnoDB: Doing recovery: scanned up to log sequence number 950403489792 InnoDB: Doing recovery: scanned up to log sequence number 950408732672 InnoDB: Doing recovery: scanned up to log sequence number 950413975552 InnoDB: Doing recovery: scanned up to log sequence number 950419218432 InnoDB: Doing recovery: scanned up to log sequence number 950424461312 InnoDB: Doing recovery: scanned up to log sequence number 950429704192 InnoDB: Doing recovery: scanned up to log sequence number 950434947072 InnoDB: Doing recovery: scanned up to log sequence number 950440189952 InnoDB: Doing recovery: scanned up to log sequence number 950445432832 InnoDB: Doing recovery: scanned up to log sequence number 950450675712 InnoDB: Doing recovery: scanned up to log sequence number 950455918592 InnoDB: Doing recovery: scanned up to log sequence number 950461161472 InnoDB: Doing recovery: scanned up to log sequence number 950465368937 120104 9:05:17 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 230072558, file name /u01/mysql/log/mysql-bin.001045 120104 9:05:39 InnoDB Plugin 1.0.9 started; log sequence number 950465368937 120104 9:05:39 [Note] Recovering after a crash using /u01/mysql/log/mysql-bin 120104 9:05:40 [Note] Starting crash recovery... 120104 9:05:40 [Note] Crash recovery finished. 120104 9:05:41 [Warning] 'user' entry 'root@my161065.cm6' ignored in --skip-name-resolve mode. 120104 9:05:41 [Warning] 'user' entry '@my161065.cm6' ignored in --skip-name-resolve mode. 120104 9:05:41 [Note] Event Scheduler: Loaded 0 events 120104 9:05:41 [Note] /u01/mysql/libexec/mysqld: ready for connections. Version: '5.1.48-log' socket: '/u01/mysql/run/mysql.sock' port: 3306 Source distribution