The engine status during the "hang" bug where mysql just stops importing without an error log or crash. ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 20986780 OS WAIT ARRAY INFO: signal count 16474289 RW-shared spins 1342565, rounds 2511191, OS waits 1170826 RW-excl spins 8910166, rounds 44630172, OS waits 773304 RW-sx spins 313505, rounds 8914383, OS waits 268493 Spin rounds per wait: 1.87 RW-shared, 5.01 RW-excl, 28.43 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 894082 Purge done for trx's n:o < 894062 undo n:o < 0 state: running but idle History list length 10 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421977676673336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421977676670720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 893932, ACTIVE 81716 sec 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 75814, OS thread handle 140502540777216, query id 985814 localhost tool System lock ALTER TABLE `framework`.`p_core` IMPORT TABLESPACE ---TRANSACTION 893931, ACTIVE 81716 sec importing tablespace mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 75814, OS thread handle 140502540777216, query id 985814 localhost tool System lock ALTER TABLE `framework`.`p_core` IMPORT TABLESPACE -------- 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 (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 175046832 OS file reads, 149701280 OS file writes, 550995 OS fsyncs 1 pending preads, 0 pending pwrites 224.47 reads/s, 8192 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 657, seg size 659, 21 merges merged operations: insert 28, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 1 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) 0.00 hash searches/s, 672.09 non-hash searches/s --- LOG --- Log sequence number 527224492556 Log buffer assigned up to 527224492556 Log buffer completed up to 527224492556 Log written up to 527224492556 Log flushed up to 527224492556 Added dirty pages up to 527224492556 Pages flushed up to 527224492556 Last checkpoint at 527224492556 17577571 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 13186891776 Dictionary memory allocated 1891153 Buffer pool size 786432 Free buffers 0 Database pages 1159013 Old database pages 427681 Modified db pages 0 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 80976, not young 339540776 0.00 youngs/s, 0.00 non-youngs/s Pages read 51172969, created 2394429, written 8011134 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 948 / 1000, young-making rate 0 / 1000 not 225 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1159013, unzip_LRU len: 115902 I/O sum[95888]:cur[1424], unzip sum[95832]:cur[1424] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 98304 Free buffers 0 Database pages 145089 Old database pages 53538 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7068, not young 42815590 0.00 youngs/s, 0.00 non-youngs/s Pages read 6391424, created 298988, written 1022870 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 500 / 1000, young-making rate 0 / 1000 not 1000 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 145089, unzip_LRU len: 14509 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 1 Buffer pool size 98304 Free buffers 0 Database pages 144649 Old database pages 53376 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7068, not young 38977493 0.00 youngs/s, 0.00 non-youngs/s Pages read 6393923, created 298950, written 1014744 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 500 / 1000, young-making rate 0 / 1000 not 1000 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 144649, unzip_LRU len: 14465 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 2 Buffer pool size 98304 Free buffers 0 Database pages 145990 Old database pages 53872 Modified db pages 0 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 21900, not young 46927374 0.00 youngs/s, 0.00 non-youngs/s Pages read 6390370, created 299891, written 1024120 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 988 / 1000, young-making rate 0 / 1000 not 27 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 145990, unzip_LRU len: 14599 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 3 Buffer pool size 98304 Free buffers 0 Database pages 144219 Old database pages 53217 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7682, not young 39730169 0.00 youngs/s, 0.00 non-youngs/s Pages read 6407123, created 299516, written 1012474 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 500 / 1000, young-making rate 0 / 1000 not 1000 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 144219, unzip_LRU len: 14422 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 4 Buffer pool size 98304 Free buffers 0 Database pages 144489 Old database pages 53317 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7125, not young 40955502 0.00 youngs/s, 0.00 non-youngs/s Pages read 6394680, created 298805, written 1035405 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 979 / 1000, young-making rate 0 / 1000 not 111 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 144489, unzip_LRU len: 14449 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 5 Buffer pool size 98304 Free buffers 0 Database pages 144389 Old database pages 53280 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6577, not young 41850350 0.00 youngs/s, 0.00 non-youngs/s Pages read 6396649, created 299253, written 963858 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 501 / 1000, young-making rate 0 / 1000 not 1000 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 144389, unzip_LRU len: 14439 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 6 Buffer pool size 98304 Free buffers 0 Database pages 145849 Old database pages 53819 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 16408, not young 48191455 0.00 youngs/s, 0.00 non-youngs/s Pages read 6392245, created 299857, written 975458 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 979 / 1000, young-making rate 0 / 1000 not 353 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 145849, unzip_LRU len: 14585 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] ---BUFFER POOL 7 Buffer pool size 98304 Free buffers 0 Database pages 144339 Old database pages 53262 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7148, not young 40092843 0.00 youngs/s, 0.00 non-youngs/s Pages read 6406555, created 299169, written 962205 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 501 / 1000, young-making rate 0 / 1000 not 1000 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 144339, unzip_LRU len: 14434 I/O sum[11986]:cur[178], unzip sum[11979]:cur[178] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=8097, Main thread ID=140494120077056 , state=sleeping Number of rows inserted 21437436, updated 146, deleted 0, read 85934676 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 81703, updated 235359, deleted 81390, read 733190 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================