> > it seems that it can't recognize last lsn. > > Yes, that seems to be the problem. > > echo 'SHOW ENGINE INNODB STATUS' | mysql -r > It should contain a line like > Log sequence number 14882332 > > Can you post that line (or the whole result)? >
Here the whole result: # echo 'SHOW ENGINE INNODB STATUS' | mysql -r -p Enter password: Type Name Status InnoDB ===================================== 2016-11-08 14:02:51 7fa095cef700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 51 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 127728 srv_active, 0 srv_shutdown, 60676 srv_idle srv_master_thread log flush and writes: 188366 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 150086 OS WAIT ARRAY INFO: signal count 812322 Mutex spin waits 1175854, rounds 3675604, OS waits 89595 RW-shared spins 255778, rounds 1749256, OS waits 44144 RW-excl spins 124857, rounds 1522886, OS waits 15597 Spin rounds per wait: 3.13 mutex, 6.84 RW-shared, 12.20 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 4253963 Purge done for trx's n:o < 4253963 undo n:o < 0 state: running but idle History list length 2712 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 209451, OS thread handle 0x7fa095cef700, query id 29836067 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 4253584, not started MySQL thread id 180416, OS thread handle 0x7fa095b69700, query id 29832117 localhost 127.0.0.1 vlogger_user cleaning up -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (read thread) I/O thread 19 state: waiting for completed aio requests (read thread) I/O thread 20 state: waiting for completed aio requests (read thread) I/O thread 21 state: waiting for completed aio requests (read thread) I/O thread 22 state: waiting for completed aio requests (read thread) I/O thread 23 state: waiting for completed aio requests (read thread) I/O thread 24 state: waiting for completed aio requests (read thread) I/O thread 25 state: waiting for completed aio requests (read thread) I/O thread 26 state: waiting for completed aio requests (read thread) I/O thread 27 state: waiting for completed aio requests (read thread) I/O thread 28 state: waiting for completed aio requests (read thread) I/O thread 29 state: waiting for completed aio requests (read thread) I/O thread 30 state: waiting for completed aio requests (read thread) I/O thread 31 state: waiting for completed aio requests (read thread) I/O thread 32 state: waiting for completed aio requests (read thread) I/O thread 33 state: waiting for completed aio requests (read thread) I/O thread 34 state: waiting for completed aio requests (read thread) I/O thread 35 state: waiting for completed aio requests (read thread) I/O thread 36 state: waiting for completed aio requests (read thread) I/O thread 37 state: waiting for completed aio requests (read thread) I/O thread 38 state: waiting for completed aio requests (read thread) I/O thread 39 state: waiting for completed aio requests (read thread) I/O thread 40 state: waiting for completed aio requests (read thread) I/O thread 41 state: waiting for completed aio requests (read thread) I/O thread 42 state: waiting for completed aio requests (read thread) I/O thread 43 state: waiting for completed aio requests (read thread) I/O thread 44 state: waiting for completed aio requests (read thread) I/O thread 45 state: waiting for completed aio requests (read thread) I/O thread 46 state: waiting for completed aio requests (read thread) I/O thread 47 state: waiting for completed aio requests (read thread) I/O thread 48 state: waiting for completed aio requests (read thread) I/O thread 49 state: waiting for completed aio requests (read thread) I/O thread 50 state: waiting for completed aio requests (read thread) I/O thread 51 state: waiting for completed aio requests (read thread) I/O thread 52 state: waiting for completed aio requests (read thread) I/O thread 53 state: waiting for completed aio requests (read thread) I/O thread 54 state: waiting for completed aio requests (read thread) I/O thread 55 state: waiting for completed aio requests (read thread) I/O thread 56 state: waiting for completed aio requests (read thread) I/O thread 57 state: waiting for completed aio requests (read thread) I/O thread 58 state: waiting for completed aio requests (read thread) I/O thread 59 state: waiting for completed aio requests (read thread) I/O thread 60 state: waiting for completed aio requests (read thread) I/O thread 61 state: waiting for completed aio requests (read thread) I/O thread 62 state: waiting for completed aio requests (read thread) I/O thread 63 state: waiting for completed aio requests (read thread) I/O thread 64 state: waiting for completed aio requests (read thread) I/O thread 65 state: waiting for completed aio requests (read thread) I/O thread 66 state: waiting for completed aio requests (write thread) I/O thread 67 state: waiting for completed aio requests (write thread) I/O thread 68 state: waiting for completed aio requests (write thread) I/O thread 69 state: waiting for completed aio requests (write thread) I/O thread 70 state: waiting for completed aio requests (write thread) I/O thread 71 state: waiting for completed aio requests (write thread) I/O thread 72 state: waiting for completed aio requests (write thread) I/O thread 73 state: waiting for completed aio requests (write thread) I/O thread 74 state: waiting for completed aio requests (write thread) I/O thread 75 state: waiting for completed aio requests (write thread) I/O thread 76 state: waiting for completed aio requests (write thread) I/O thread 77 state: waiting for completed aio requests (write thread) I/O thread 78 state: waiting for completed aio requests (write thread) I/O thread 79 state: waiting for completed aio requests (write thread) I/O thread 80 state: waiting for completed aio requests (write thread) I/O thread 81 state: waiting for completed aio requests (write thread) I/O thread 82 state: waiting for completed aio requests (write thread) I/O thread 83 state: waiting for completed aio requests (write thread) I/O thread 84 state: waiting for completed aio requests (write thread) I/O thread 85 state: waiting for completed aio requests (write thread) I/O thread 86 state: waiting for completed aio requests (write thread) I/O thread 87 state: waiting for completed aio requests (write thread) I/O thread 88 state: waiting for completed aio requests (write thread) I/O thread 89 state: waiting for completed aio requests (write thread) I/O thread 90 state: waiting for completed aio requests (write thread) I/O thread 91 state: waiting for completed aio requests (write thread) I/O thread 92 state: waiting for completed aio requests (write thread) I/O thread 93 state: waiting for completed aio requests (write thread) I/O thread 94 state: waiting for completed aio requests (write thread) I/O thread 95 state: waiting for completed aio requests (write thread) I/O thread 96 state: waiting for completed aio requests (write thread) I/O thread 97 state: waiting for completed aio requests (write thread) I/O thread 98 state: waiting for completed aio requests (write thread) I/O thread 99 state: waiting for completed aio requests (write thread) I/O thread 100 state: waiting for completed aio requests (write thread) I/O thread 101 state: waiting for completed aio requests (write thread) I/O thread 102 state: waiting for completed aio requests (write thread) I/O thread 103 state: waiting for completed aio requests (write thread) I/O thread 104 state: waiting for completed aio requests (write thread) I/O thread 105 state: waiting for completed aio requests (write thread) I/O thread 106 state: waiting for completed aio requests (write thread) I/O thread 107 state: waiting for completed aio requests (write thread) I/O thread 108 state: waiting for completed aio requests (write thread) I/O thread 109 state: waiting for completed aio requests (write thread) I/O thread 110 state: waiting for completed aio requests (write thread) I/O thread 111 state: waiting for completed aio requests (write thread) I/O thread 112 state: waiting for completed aio requests (write thread) I/O thread 113 state: waiting for completed aio requests (write thread) I/O thread 114 state: waiting for completed aio requests (write thread) I/O thread 115 state: waiting for completed aio requests (write thread) I/O thread 116 state: waiting for completed aio requests (write thread) I/O thread 117 state: waiting for completed aio requests (write thread) I/O thread 118 state: waiting for completed aio requests (write thread) I/O thread 119 state: waiting for completed aio requests (write thread) I/O thread 120 state: waiting for completed aio requests (write thread) I/O thread 121 state: waiting for completed aio requests (write thread) I/O thread 122 state: waiting for completed aio requests (write thread) I/O thread 123 state: waiting for completed aio requests (write thread) I/O thread 124 state: waiting for completed aio requests (write thread) I/O thread 125 state: waiting for completed aio requests (write thread) I/O thread 126 state: waiting for completed aio requests (write thread) I/O thread 127 state: waiting for completed aio requests (write thread) I/O thread 128 state: waiting for completed aio requests (write thread) I/O thread 129 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 457913 OS file reads, 2216642 OS file writes, 1466063 OS fsyncs 0.02 reads/s, 16384 avg bytes/read, 12.27 writes/s, 6.31 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3090, seg size 3092, 13035 merges merged operations: insert 18171, delete mark 921631, delete 40605 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4730647, node heap has 9184 buffer(s) 4624.75 hash searches/s, 584.15 non-hash searches/s --- LOG --- Log sequence number 11056494132 Log flushed up to 11056494132 Pages flushed up to 11056493325 Last checkpoint at 11056485039 0 pending log writes, 0 pending chkp writes 601644 log i/o's done, 2.45 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2197815296; in additional pool allocated 0 Dictionary memory allocated 6918771 Buffer pool size 131064 Free buffers 8195 Database pages 113685 Old database pages 41802 Modified db pages 7 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 243627, not young 20406340 0.14 youngs/s, 0.04 non-youngs/s Pages read 457035, created 21037, written 1319875 0.02 reads/s, 0.02 creates/s, 8.96 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 113685, unzip_LRU len: 0 I/O sum[3664]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16383 Free buffers 1025 Database pages 14208 Old database pages 5224 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 30778, not young 2261664 0.04 youngs/s, 0.00 non-youngs/s Pages read 57167, created 2541, written 212484 0.00 reads/s, 0.00 creates/s, 1.02 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14208, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16383 Free buffers 1024 Database pages 14216 Old database pages 5227 Modified db pages 1 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 31387, not young 2452762 0.00 youngs/s, 0.00 non-youngs/s Pages read 57148, created 2561, written 87727 0.00 reads/s, 0.00 creates/s, 0.67 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14216, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16383 Free buffers 1025 Database pages 14204 Old database pages 5223 Modified db pages 2 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 29888, not young 3072749 0.02 youngs/s, 0.00 non-youngs/s Pages read 56452, created 2660, written 76920 0.00 reads/s, 0.00 creates/s, 0.57 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14204, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16383 Free buffers 1025 Database pages 14198 Old database pages 5221 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 29823, not young 1692755 0.02 youngs/s, 0.00 non-youngs/s Pages read 58628, created 2673, written 217194 0.00 reads/s, 0.00 creates/s, 1.20 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14198, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16383 Free buffers 1024 Database pages 14214 Old database pages 5226 Modified db pages 2 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 29923, not young 2647667 0.00 youngs/s, 0.04 non-youngs/s Pages read 55261, created 2772, written 202153 0.02 reads/s, 0.00 creates/s, 1.57 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14214, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16383 Free buffers 1024 Database pages 14220 Old database pages 5229 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 29826, not young 2812608 0.00 youngs/s, 0.00 non-youngs/s Pages read 56997, created 2748, written 155710 0.00 reads/s, 0.00 creates/s, 0.92 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14220, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16383 Free buffers 1024 Database pages 14202 Old database pages 5222 Modified db pages 1 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 30469, not young 2457755 0.04 youngs/s, 0.00 non-youngs/s Pages read 57091, created 2704, written 149810 0.00 reads/s, 0.00 creates/s, 1.59 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14202, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16383 Free buffers 1024 Database pages 14223 Old database pages 5230 Modified db pages 1 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 31533, not young 3008380 0.02 youngs/s, 0.00 non-youngs/s Pages read 58291, created 2378, written 217877 0.00 reads/s, 0.02 creates/s, 1.43 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14223, unzip_LRU len: 0 I/O sum[458]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Main thread process no. 9548, id 140327853520640, state: sleeping Number of rows inserted 1913027, updated 1810769, deleted 1815826, read 5414936409 4.06 inserts/s, 1.67 updates/s, 0.12 deletes/s, 8307.99 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ -- Denis -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
