MariaDB [(none)]> show processlist; +--------+------------------+----------------------+--------------------+---------+--------+--------------------------------+------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+------------------+----------------------+--------------------+---------+--------+--------------------------------+------------------------------------------------------------------------------------------------------+----------+ | 1 | system user | | NULL | Sleep | 264671 | wsrep aborter idle | NULL | 0.000 | | 2 | system user | | NULL | Sleep | 1476 | applied write set 13311360 | NULL | 0.000 | | 4 | system user | | NULL | Sleep | 1465 | applied write set 13311371 | NULL | 0.000 | | 5 | system user | | NULL | Sleep | 1466 | applied write set 13311368 | NULL | 0.000 | | 6 | system user | | NULL | Sleep | 1485 | applied write set 13311358 | NULL | 0.000 | | 7 | system user | | NULL | Sleep | 1475 | applied write set 13311361 | NULL | 0.000 | | 8 | system user | | NULL | Sleep | 5622 | committed 13306960 | NULL | 0.000 | | 9 | system user | | NULL | Sleep | 1473 | applied write set 13311364 | NULL | 0.000 | | 10 | system user | | NULL | Sleep | 5637 | committed 13306939 | NULL | 0.000 | | 11 | system user | | NULL | Sleep | 1478 | applied write set 13311359 | NULL | 0.000 | | 12 | system user | | NULL | Sleep | 1465 | applied write set 13311373 | NULL | 0.000 | | 13 | system user | | NULL | Sleep | 1465 | applied write set 13311370 | NULL | 0.000 | | 15 | system user | | NULL | Sleep | 1468 | applied write set 13311366 | NULL | 0.000 | | 16 | system user | | NULL | Sleep | 1473 | applied write set 13311363 | NULL | 0.000 | | 17 | system user | | NULL | Sleep | 1465 | applied write set 13311369 | NULL | 0.000 | | 18 | system user | | NULL | Sleep | 1465 | applied write set 13311372 | NULL | 0.000 | | 19 | system user | | NULL | Sleep | 5633 | committed 13306944 | NULL | 0.000 | | 624300 | openexchange | 172.29.188.162:55472 | cluster8_write_561 | Query | 1498 | init | commit | 0.000 | | 625180 | openexchange | 172.29.188.162:32814 | cluster8_write_562 | Query | 1495 | query end | INSERT INTO xxxxx (cid, user, serviceId, id, data) VALUES (1454121, 3, '*********' | 0.000 | | 626689 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 | | 626730 | clustercheckuser | localhost | NULL | Query | 29 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626731 | clustercheckuser | localhost | NULL | Query | 29 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626732 | clustercheckuser | localhost | NULL | Query | 28 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626733 | clustercheckuser | localhost | NULL | Query | 28 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626734 | clustercheckuser | localhost | NULL | Query | 25 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626735 | clustercheckuser | localhost | NULL | Query | 25 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626736 | clustercheckuser | localhost | NULL | Query | 24 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626737 | clustercheckuser | localhost | NULL | Query | 24 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626738 | clustercheckuser | localhost | NULL | Query | 21 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626739 | clustercheckuser | localhost | NULL | Query | 21 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626740 | clustercheckuser | localhost | NULL | Query | 20 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626741 | clustercheckuser | localhost | NULL | Query | 20 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626742 | clustercheckuser | localhost | NULL | Query | 17 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626743 | clustercheckuser | localhost | NULL | Query | 17 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626744 | clustercheckuser | localhost | NULL | Query | 16 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626745 | clustercheckuser | localhost | NULL | Query | 16 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626746 | clustercheckuser | localhost | NULL | Query | 13 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626747 | clustercheckuser | localhost | NULL | Query | 13 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626748 | clustercheckuser | localhost | NULL | Query | 12 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626749 | clustercheckuser | localhost | NULL | Query | 12 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626750 | clustercheckuser | localhost | NULL | Query | 9 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626751 | clustercheckuser | localhost | NULL | Query | 9 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626752 | clustercheckuser | localhost | NULL | Query | 8 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626753 | clustercheckuser | localhost | NULL | Query | 8 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626754 | clustercheckuser | localhost | NULL | Query | 5 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626755 | clustercheckuser | localhost | NULL | Query | 5 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626756 | clustercheckuser | localhost | NULL | Query | 4 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626757 | clustercheckuser | localhost | NULL | Query | 4 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626758 | clustercheckuser | localhost | NULL | Query | 1 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626759 | clustercheckuser | localhost | NULL | Query | 1 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626760 | clustercheckuser | localhost | NULL | Query | 0 | checking query cache for query | select @@version_comment limit 1 | 0.000 | | 626761 | clustercheckuser | localhost | NULL | Query | 0 | checking query cache for query | select @@version_comment limit 1 | 0.000 | +--------+------------------+----------------------+--------------------+---------+--------+--------------------------------+------------------------------------------------------------------------------------------------------+----------+ 52 rows in set (0.00 sec) MariaDB [(none)]> show engine innodb status\G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-10-13 14:39:00 7fe0460c2b00 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 177037 srv_active, 0 srv_shutdown, 85713 srv_idle srv_master_thread log flush and writes: 262750 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 65560 OS WAIT ARRAY INFO: signal count 65230 Mutex spin waits 95125, rounds 933324, OS waits 26536 RW-shared spins 39162, rounds 1157346, OS waits 38264 RW-excl spins 926, rounds 27535, OS waits 590 Spin rounds per wait: 9.81 mutex, 29.55 RW-shared, 29.74 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 112879404 Purge done for trx's n:o < 112879356 undo n:o < 0 state: running but idle History list length 26 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 626689, OS thread handle 0x7fe0460c2b00, query id 13111324 localhost root init show engine innodb status ---TRANSACTION 112807622, not started MySQL thread id 19, OS thread handle 0x7fe23b487b00, query id 12897197 committed 13306944 ---TRANSACTION 112807575, not started MySQL thread id 10, OS thread handle 0x7fe21650db00, query id 12897066 committed 13306939 ---TRANSACTION 112808122, not started MySQL thread id 8, OS thread handle 0x7fe23b565b00, query id 12898255 committed 13306960 ---TRANSACTION 108415747, not started MySQL thread id 3, OS thread handle 0x7fe23ebdcb00, query id 0 Processing binlog checkpoint notification ---TRANSACTION 112879403, ACTIVE 1564 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 12, OS thread handle 0x7fe23b643b00, query id 13106510 applied write set 13311373 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879402, ACTIVE 1564 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 18, OS thread handle 0x7fe216557b00, query id 13106509 applied write set 13311372 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879401, ACTIVE 1564 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 4, OS thread handle 0x7fe23b51bb00, query id 13106508 applied write set 13311371 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879400, ACTIVE 1564 sec 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 13, OS thread handle 0x7fe2165ebb00, query id 13106505 applied write set 13311370 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879399, ACTIVE 1564 sec 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 17, OS thread handle 0x7fe23b4d1b00, query id 13106504 applied write set 13311369 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879398, ACTIVE 1566 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 5, OS thread handle 0x7fe23eab4b00, query id 13106499 applied write set 13311368 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879397, ACTIVE 1568 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 15, OS thread handle 0x7fe23eafeb00, query id 13106475 applied write set 13311366 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879396, ACTIVE 1573 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 9, OS thread handle 0x7fe23eb48b00, query id 13106465 applied write set 13311364 Trx #rec lock waits 1 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879395, ACTIVE 1573 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 16, OS thread handle 0x7fe2165a1b00, query id 13106464 applied write set 13311363 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879394, ACTIVE 1575 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 7, OS thread handle 0x7fe23b5f9b00, query id 13106463 applied write set 13311361 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879393, ACTIVE 1575 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 2, OS thread handle 0x7fe23ec26b00, query id 13106462 applied write set 13311360 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879392, ACTIVE 1578 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 11, OS thread handle 0x7fe2164c3b00, query id 13106454 applied write set 13311359 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879390, ACTIVE 1584 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 6, OS thread handle 0x7fe23b5afb00, query id 13106441 applied write set 13311358 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879387, ACTIVE 1594 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 625180, OS thread handle 0x7fe046078b00, query id 13106393 172.29.188.162 openexchange query end INSERT INTO xxxxx (cid, user, serviceId, id, data) VALUES (1454121, 3, '******', ... (cut) ... Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 112879385, ACTIVE (PREPARED) 1597 sec 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 624300, OS thread handle 0x7fe1f0df1b00, query id 13106376 172.29.188.162 openexchange init commit Trx read view will not see trx with id >= 112879386, sees < 112879386 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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 (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 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 438559 OS file reads, 2361088 OS file writes, 514428 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 48, seg size 50, 2234 merges merged operations: insert 3297, delete mark 1428, delete 1041 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 74566605878 Log flushed up to 74566605878 Pages flushed up to 74566605878 Last checkpoint at 74566605878 Max checkpoint age 869019772 Checkpoint age target 841862905 Modified age 0 Checkpoint age 0 0 pending log writes, 0 pending chkp writes 174169 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 26990346240; in additional pool allocated 0 Total memory allocated by read views 616 Internal hash tables (constant factor + variable factor) Adaptive hash index 412159968 (407994232 + 4165736) Page hash 3188312 (buffer pool 0 only) Dictionary cache 152098566 (102000368 + 50098198) File system 9996008 (812272 + 9183736) Lock system 63767240 (63750152 + 17088) Recovery system 0 (0 + 0) Dictionary memory allocated 50098198 Buffer pool size 1572856 Buffer pool size, bytes 25769672704 Free buffers 1154556 Database pages 418046 Old database pages 154471 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1876, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 407960, created 10086, written 2129195 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 418046, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 138837 Database pages 57738 Old database pages 21333 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 213, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 55941, created 1797, written 259062 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 57738, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 137063 Database pages 59512 Old database pages 21987 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 300, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 57971, created 1541, written 197058 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 59512, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 138314 Database pages 58262 Old database pages 21526 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 277, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 56915, created 1347, written 214372 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 58262, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 136588 Database pages 59989 Old database pages 22164 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 167, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 58761, created 1228, written 298516 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 59989, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 154683 Database pages 41890 Old database pages 15482 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 235, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 40707, created 1183, written 511101 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 41890, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 148531 Database pages 48046 Old database pages 17755 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 246, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 47405, created 641, written 252559 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 48046, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 144443 Database pages 52133 Old database pages 19264 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 79, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 51308, created 825, written 236602 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 52133, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 196607 Buffer pool size, bytes 3221209088 Free buffers 156097 Database pages 40476 Old database pages 14960 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 359, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 38952, created 1524, written 159925 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 40476, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB 15 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 15 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 112879386 Read view up limit trx id 112879386 Read view low limit trx id 112879386 Read view individually stored trx ids: ----------------- Main thread process no. 9284, id 140579717506816, state: sleeping Number of rows inserted 224068, updated 234660, deleted 2463, read 178961785 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) ERROR: No query specified