===================================== 2019-08-02 14:25:22 0x7f3274480700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2521 srv_active, 0 srv_shutdown, 9084 srv_idle srv_master_thread log flush and writes: 11598 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 51209 OS WAIT ARRAY INFO: signal count 94570 RW-shared spins 0, rounds 402914, OS waits 26359 RW-excl spins 0, rounds 1333425, OS waits 13096 RW-sx spins 45100, rounds 579594, OS waits 3409 Spin rounds per wait: 402914.00 RW-shared, 1333425.00 RW-excl, 12.85 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 36540984 Purge done for trx's n:o < 36540706 undo n:o < 0 state: running but idle History list length 85 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421339868908832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868911152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868909992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868913472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868912312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868876352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868906512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868907672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868903032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868905352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868901872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868899552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868893752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868896072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868897232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868892592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868894912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868880992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868887952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868891432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868890272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868889112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868886792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868885632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868884472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868883312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868878672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868882152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868874032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868879832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868863592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868875192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868865912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868872872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868871712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868870552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868869392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868868232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868864752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868860112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868861272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868812552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868862432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868858952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868857792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868856632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868855472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868854312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868853152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868851992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868850832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868849672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868848512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868847352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868846192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868845032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868843872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868842712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868841552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868840392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868839232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868838072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868836912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868835752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868834592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868833432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868832272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868831112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868829952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868828792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868827632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868826472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868825312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868824152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868820672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868819512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868821832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868818352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868817192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868745272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868814872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868813712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868809072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868732512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868810232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868807912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868805592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868804432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868803272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868802112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868796312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868800952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868799792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868798632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868797472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868754552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868795152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868793992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868792832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868791672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868790512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868789352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868788192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868787032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868785872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868784712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868781232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868783552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868782392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868778912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868777752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868776592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868775432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868774272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868773112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868771952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868770792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868768472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868767312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868766152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868764992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868763832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868762672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868761512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868760352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868759192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868758032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868756872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868755712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868753392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868752232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868751072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868749912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868748752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868747592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868746432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868731352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868744112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868742952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868741792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868740632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868739472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868738312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868737152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868734832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868704672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868733672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868730192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868729032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868727872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868726712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868725552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868724392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868723232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868722072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868719752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868718592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868717432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868716272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868715112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868713952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868712792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868711632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868710472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868690752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868709312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868708152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868706992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868705832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868701192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868703512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868700032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868698872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868697712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868696552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868695392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868694232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868693072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868691912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 36540916, ACTIVE 182 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 6934, OS thread handle 139854706259712, query id 304160 192.168.100.1 rollbase wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540914, ACTIVE 253 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 6970, OS thread handle 139854704637696, query id 302441 192.168.100.1 sab_user wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540780, ACTIVE 566 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 35964, OS thread handle 139854686525184, query id 293861 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540779, ACTIVE 600 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 35732, OS thread handle 139854677591808, query id 293090 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540778, ACTIVE 604 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 34949, OS thread handle 139854686795520, query id 293001 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540709, ACTIVE 688 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 16045, OS thread handle 139854691931904, query id 290335 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540706, ACTIVE 782 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2592, OS thread handle 139854806611712, query id 288216 192.168.100.1 foederis_dev_user wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540701, ACTIVE 831 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 2767, OS thread handle 139854724912896, query id 287079 192.168.100.1 coiro_tp_user wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540632, ACTIVE 902 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 2715, OS thread handle 139854725723904, query id 284659 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540630, ACTIVE 914 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 2926, OS thread handle 139854714640128, query id 284325 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540629, ACTIVE 914 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 5787, OS thread handle 139854710044416, query id 284320 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540625, ACTIVE 965 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 15699, OS thread handle 139854692202240, query id 283151 192.168.100.1 admin-pxc wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540622, ACTIVE 977 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 3416, OS thread handle 139854708152064, query id 282841 192.168.100.1 foederis_dev_user wsrep: initiating replication for write set (-1) commit ---TRANSACTION 36540621, ACTIVE 1005 sec, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2903, OS thread handle 139854717073152, query id 282155 192.168.100.1 foederis_admin wsrep: initiating replication for write set (-1) INSERT INTO RB_ACT_TRAIL (CUST_ID, TRAIL_ID, OBJ_ID, TRAIL_TEXT, COMM_LOG_ID, CREATED_BY, CREATED_AT) VALUES (94791151, 337653, 12735854, '99981443 ont été définitivement supprimés.', -1, -1, '2019-02-21 09:53:03') -------- 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 161736 OS file reads, 124770 OS file writes, 1902 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.94 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) 0.00 hash searches/s, 5.44 non-hash searches/s --- LOG --- Log sequence number 361939587242 Log flushed up to 361939587242 Pages flushed up to 361939587242 Last checkpoint at 361939587233 Max checkpoint age 1738632684 Checkpoint age target 1684300413 Modified age 0 Checkpoint age 9 0 pending log flushes, 0 pending chkp writes 2026 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8942256128 Dictionary memory allocated 13831291 Internal hash tables (constant factor + variable factor) Adaptive hash index 151409088 (151375424 + 33664) Page hash 1107112 (buffer pool 0 only) Dictionary cache 51675147 (37843856 + 13831291) File system 3049456 (812272 + 2237184) Lock system 21469816 (21250568 + 219248) Recovery system 0 (0 + 0) Buffer pool size 524224 Buffer pool size, bytes 8588886016 Free buffers 352093 Database pages 171900 Old database pages 63300 Modified db pages 5 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7030, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 160963, created 10937, written 120698 0.00 reads/s, 0.00 creates/s, 0.94 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: 171900, unzip_LRU len: 473 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 45270 Database pages 20226 Old database pages 7446 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 948, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 19078, created 1148, written 13994 0.00 reads/s, 0.00 creates/s, 0.00 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: 20226, unzip_LRU len: 64 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 42002 Database pages 23507 Old database pages 8658 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 742, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 22161, created 1346, written 13826 0.00 reads/s, 0.00 creates/s, 0.00 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: 23507, unzip_LRU len: 51 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 45697 Database pages 19831 Old database pages 7302 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1024, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 18503, created 1328, written 13456 0.00 reads/s, 0.00 creates/s, 0.00 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: 19831, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 43870 Database pages 21626 Old database pages 7963 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 726, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 20246, created 1380, written 13482 0.00 reads/s, 0.00 creates/s, 0.00 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: 21626, unzip_LRU len: 64 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 43720 Database pages 21768 Old database pages 8016 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 819, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 20231, created 1537, written 13828 0.00 reads/s, 0.00 creates/s, 0.00 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: 21768, unzip_LRU len: 79 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 44127 Database pages 21382 Old database pages 7872 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 934, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 19993, created 1389, written 13987 0.00 reads/s, 0.00 creates/s, 0.00 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: 21382, unzip_LRU len: 38 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 43852 Database pages 21629 Old database pages 7965 Modified db pages 5 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 884, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 20139, created 1490, written 24144 0.00 reads/s, 0.00 creates/s, 0.94 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: 21629, unzip_LRU len: 93 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 43555 Database pages 21931 Old database pages 8078 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 953, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 20612, created 1319, written 13981 0.00 reads/s, 0.00 creates/s, 0.00 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: 21931, unzip_LRU len: 84 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 14 RW transactions active inside InnoDB Process ID=9171, Main thread ID=139855449016064, state: sleeping Number of rows inserted 317147, updated 149, deleted 2242937, read 842487201 36.94 inserts/s, 0.00 updates/s, 0.00 deletes/s, 38.31 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================