Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SHOW ENGINE INNODB STATUS;
- +--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Type | Name | Status |
- +--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | InnoDB | |
- =====================================
- 2021-02-03 09:56:42 0x7f9753905700 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 21 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 382433 srv_active, 0 srv_shutdown, 488805 srv_idle
- srv_master_thread log flush and writes: 871238
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 2378360
- OS WAIT ARRAY INFO: signal count 16277263
- RW-shared spins 0, rounds 16231681, OS waits 630299
- RW-excl spins 0, rounds 61512984, OS waits 772375
- RW-sx spins 1808340, rounds 26502080, OS waits 271325
- Spin rounds per wait: 16231681.00 RW-shared, 61512984.00 RW-excl, 14.66 RW-sx
- ------------------------
- LATEST FOREIGN KEY ERROR
- ------------------------
- 2021-02-01 15:32:22 0x7f974b4f3700 Transaction:
- TRANSACTION 442170378, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1
- MySQL thread id 677343, OS thread handle 140287780271872, query id 557522568 localhost user_c29da update
- INSERT INTO `catalog_product_frontend_action` (`action_id`, `type_id`, `visitor_id`, `customer_id`, `product_id`, `added_at`) VALUES (NULL, 'recently_products', '1568191', NULL, '0', '0')
- Foreign key constraint fails for table `c29da_database`.`catalog_product_frontend_action`:
- ,
- CONSTRAINT `CAT_PRD_FRONTEND_ACTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
- Trying to add in child table, in index CAT_PRD_FRONTEND_ACTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID tuple:
- DATA TUPLE: 2 fields;
- 0: len 4; hex 00000000; asc ;;
- 1: len 8; hex 0000000000004975; asc Iu;;
- But in parent table `c29da_database`.`catalog_product_entity`, in index PRIMARY,
- the closest match we can find is record:
- PHYSICAL RECORD: n_fields 11; compact format; info bits 0
- 0: len 4; hex 00000019; asc ;;
- 1: len 6; hex 000000711ffe; asc q ;;
- 2: len 7; hex e00000016d0110; asc m ;;
- 3: len 2; hex 0004; asc ;;
- 4: len 6; hex 73696d706c65; asc simple;;
- 5: len 14; hex 31303030303635342d3030312f4c; asc 10000654-001/L;;
- 6: len 2; hex 8000; asc ;;
- 7: len 2; hex 0000; asc ;;
- 8: len 4; hex 5b5ec6c6; asc [^ ;;
- 9: len 4; hex 5bdfeba7; asc [ ;;
- 10: len 4; hex 80000000; asc ;;
- ------------------------
- LATEST DETECTED DEADLOCK
- ------------------------
- 2021-02-03 07:26:03 0x7f9753b15700
- *** (1) TRANSACTION:
- TRANSACTION 443857329, ACTIVE 0 sec starting index read
- mysql tables in use 2, locked 2
- LOCK WAIT 4 lock struct(s), heap size 1136, 3 row lock(s)
- MySQL thread id 840430, OS thread handle 140287781082880, query id 613230429 localhost user_c29da Sending data
- UPDATE `cron_schedule` AS `current`
- LEFT JOIN `cron_schedule` AS `existing` ON existing.job_code = current.job_code AND (existing.executed_at > UTC_TIMESTAMP() - INTERVAL 1 DAY OR existing.executed_at IS NULL) AND existing.status = 'running'
- SET `current`.`status` = 'running', `current`.`pid` = 17980
- WHERE (current.schedule_id = '19915961') AND (current.status = 'pending') AND (existing.schedule_id IS NULL)
- *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 153055 page no 260 n bits 256 index PRIMARY of table `c29da_database`.`cron_schedule` trx id 443857329 lock mode S locks rec but not gap waiting
- *** (2) TRANSACTION:
- TRANSACTION 443857328, ACTIVE 0 sec fetching rows
- mysql tables in use 1, locked 1
- 11 lock struct(s), heap size 1136, 1299 row lock(s)
- MySQL thread id 840429, OS thread handle 140287920920320, query id 613230428 localhost user_c29da updating
- DELETE FROM `cron_schedule` WHERE (status = 'missed') AND (job_code in ('indexer_reindex_all_invalid', 'indexer_update_all_views', 'indexer_clean_all_changelogs', 'update_omniva_parcels', 'update_omnivalt_parcels', 'update_omnivalv_parcels', 'navision_full_product_import', 'navision_product_disable_missing', 'navision_product_import', 'navision_full_inventory_import', 'navision_inventory_import')) AND (created_at < '2021-02-02 16:06:03')
- *** (2) HOLDS THE LOCK(S):
- RECORD LOCKS space id 153055 page no 260 n bits 256 index PRIMARY of table `c29da_database`.`cron_schedule` trx id 443857328 lock_mode X
- *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 153055 page no 263 n bits 288 index PRIMARY of table `c29da_database`.`cron_schedule` trx id 443857328 lock_mode X waiting
- *** WE ROLL BACK TRANSACTION (1)
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 443889190
- Purge done for trx's n:o < 443889189 undo n:o < 0 state: running but idle
- History list length 53
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421765413562640, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421765413569456, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- --------
- 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] , aio writes: [0, 0, 0, 0] ,
- ibuf aio reads:, log i/o's:, sync i/o's:
- Pending flushes (fsync) log: 0; buffer pool: 0
- 2293747 OS file reads, 22550692 OS file writes, 2234302 OS fsyncs
- 0.48 reads/s, 16384 avg bytes/read, 3.24 writes/s, 1.76 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 3441, seg size 3443, 98398 merges
- merged operations:
- insert 920582, delete mark 5044198, delete 647542
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 553193, node heap has 1175 buffer(s)
- Hash table size 553193, node heap has 4398 buffer(s)
- Hash table size 553193, node heap has 3658 buffer(s)
- Hash table size 553193, node heap has 2324 buffer(s)
- Hash table size 553193, node heap has 2007 buffer(s)
- Hash table size 553193, node heap has 2237 buffer(s)
- Hash table size 553193, node heap has 1226 buffer(s)
- Hash table size 553193, node heap has 1216 buffer(s)
- 368.32 hash searches/s, 166.04 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 4425881247135
- Log flushed up to 4425881247135
- Pages flushed up to 4425881241588
- Last checkpoint at 4425881241579
- Max checkpoint age 542870693
- Checkpoint age target 525905984
- Modified age 5547
- Checkpoint age 5556
- 0 pending log flushes, 0 pending chkp writes
- 4505409 log i/o's done, 0.86 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 2235564032
- Dictionary memory allocated 7544520
- Internal hash tables (constant factor + variable factor)
- Adaptive hash index 334298560 (35404352 + 298894208)
- Page hash 1107112 (buffer pool 0 only)
- Dictionary cache 16395608 (8851088 + 7544520)
- File system 1478080 (812272 + 665808)
- Lock system 5315688 (5313416 + 2272)
- Recovery system 0 (0 + 0)
- Buffer pool size 131056
- Buffer pool size, bytes 2147221504
- Free buffers 2049
- Database pages 110766
- Old database pages 40847
- Modified db pages 12
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 5237590, not young 143965104
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2292003, created 7659787, written 17453745
- 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: 110766, unzip_LRU len: 0
- I/O sum[526]: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 1025
- Database pages 55313
- Old database pages 20398
- Modified db pages 5
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2623902, not young 74274595
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 1135145, created 3804732, written 8586352
- 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: 55313, unzip_LRU len: 0
- I/O sum[263]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 1
- Buffer pool size 65528
- Buffer pool size, bytes 1073610752
- Free buffers 1024
- Database pages 55453
- Old database pages 20449
- Modified db pages 7
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2613688, not young 69690509
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 1156858, created 3855055, written 8867393
- 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: 55453, unzip_LRU len: 0
- I/O sum[263]:cur[0], unzip sum[0]:cur[0]
- --------------
- ROW OPERATIONS
- --------------
- 0 queries inside InnoDB, 0 queries in queue
- 0 read views open inside InnoDB
- 0 RW transactions active inside InnoDB
- Process ID=30551, Main thread ID=140287937705728, state: sleeping
- Number of rows inserted 789656706, updated 13015053, deleted 24006288, read 115084954426
- 1.19 inserts/s, 0.52 updates/s, 0.00 deletes/s, 50344.32 reads/s
- ----------------------------
- END OF INNODB MONITOR OUTPUT
- ============================
- |
- +--------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement