root@ABC-TRUNCATED-live-prod:~# /usr/bin/mariadb --defaults-file=/etc/mysql/debian.cnf -e "SHOW ENGINE INNODB STATUS\G" *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2025-06-02 17:28:45 0x7cd0f894f6c0 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 1 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1523154 srv_idle srv_master_thread log flush and writes: 1523153 ---------- SEMAPHORES ---------- ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2025-06-02 12:00:17 0x7cd0f85fe6c0 *** (1) TRANSACTION: TRANSACTION 473011148, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 234 lock struct(s), heap size 24696, 6626 row lock(s) MariaDB thread id 747365, OS thread handle 137236962076352, query id 657260911 localhost TRUNCATED Updating DELETE FROM wp_options WHERE option_name LIKE '\\_transient\\_%1748865616' *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 14 page no 318 n bits 112 index PRIMARY of table `TRUNCATED`.`wp_options` trx id 473011148 lock_mode X waiting Record lock, heap no 9 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b17; asc { ;; 1: len 6; hex 00001c3193d1; asc 1 ;; 2: len 7; hex 3f000002c5021c; asc ? ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531393837; asc 1748951987;; 5: len 3; hex 6f6666; asc off;; *** CONFLICTING WITH: RECORD LOCKS space id 14 page no 318 n bits 320 index PRIMARY of table `TRUNCATED`.`wp_options` trx id 473011153 lock_mode X locks rec but not gap Record lock, heap no 9 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b17; asc { ;; 1: len 6; hex 00001c3193d1; asc 1 ;; 2: len 7; hex 3f000002c5021c; asc ? ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531393837; asc 1748951987;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 18 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b46; asc {F;; 1: len 6; hex 00001c3193d1; asc 1 ;; 2: len 7; hex 3f000002c50270; asc ? p;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393532303134; asc 1748952014;; 5: len 3; hex 6f6666; asc off;; *** (2) TRANSACTION: TRANSACTION 473011153, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 5 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MariaDB thread id 747381, OS thread handle 137236988413632, query id 657260941 localhost TRUNCATED Updating DELETE FROM wp_options WHERE option_name IN ( '_transient_timeout_wc_related_22714', '_transient_timeout_wc_related_33480', '_transient_timeout_wc_related_34437', '_transient_timeout_wc_related_34439', '_transient_timeout_wc_related_34445', '_transient_timeout_wc_related_34451', '_transient_timeout_wc_related_34726', '_transient_timeout_wc_related_34744', '_transient_timeout_wc_related_35097', '_transient_timeout_wc_related_35100', '_transient_timeout_wc_related_35101', '_transient_timeout_wc_related_7863', '_transient_timeout_wc_related_8105', '_transient_wc_related_22714', '_transient_wc_related_33480', '_transient_wc_related_34437', '_transient_wc_related_34439', '_transient_wc_related_34445', '_transient_wc_related_34451', '_transient_wc_related_34726', '_transient_wc_related_34744', '_transient_wc_related_35097', '_transient_wc_related_35100', '_transient_wc_related_35101', '_transient_wc_related_7863', '_transient_wc_related_8105' ) *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 14 page no 317 n bits 320 index PRIMARY of table `TRUNCATED`.`wp_options` trx id 473011153 lock_mode X locks rec but not gap waiting Record lock, heap no 34 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b0b; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383730; asc 1748951870;; 5: len 3; hex 6f6666; asc off;; *** CONFLICTING WITH: RECORD LOCKS space id 14 page no 317 n bits 104 index PRIMARY of table `TRUNCATED`.`wp_options` trx id 473011148 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; Record lock, heap no 2 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7afd; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373739; asc 1748951779;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 3 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af5; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af6; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313233; asc _transient_wc_related_11123;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 662 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 5 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af7; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 6 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af8; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313236; asc _transient_wc_related_11126;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 662 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 7 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af9; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 8 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7afa; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313238; asc _transient_wc_related_11128;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 662 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 9 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7afb; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 10 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7afc; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313330; asc _transient_wc_related_11130;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 645 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 11 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7ae3; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 12 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7ae4; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313035; asc _transient_wc_related_11105;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 1736 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 13 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7ae7; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 14 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7ae8; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313038; asc _transient_wc_related_11108;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 1736 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 15 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7aed; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 16 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7aee; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313135; asc _transient_wc_related_11115;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 1736 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 17 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7aef; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 18 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af0; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313137; asc _transient_wc_related_11117;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 662 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 19 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af1; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531373639; asc 1748951769;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 20 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7af2; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3131313139; asc _transient_wc_related_11119;; 4: len 30; hex 613a313a7b733a35363a226c696d69743d31303030266578636c7564655f; asc a:1:{s:56:"limit=1000&exclude_; (total 662 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7afe; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3334343339; asc _transient_wc_related_34439;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 284 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 22 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7aff; asc z ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 34 bytes); 4: len 10; hex 31373438393531383130; asc 1748951810;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 23 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b00; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 26; hex 5f7472616e7369656e745f77635f72656c617465645f38313035; asc _transient_wc_related_8105;; 4: len 30; hex 613a313a7b733a35323a226c696d69743d34266578636c7564655f696473; asc a:1:{s:52:"limit=4&exclude_ids; (total 447 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 24 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b01; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383133; asc 1748951813;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b02; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3334373236; asc _transient_wc_related_34726;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 284 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 26 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b03; asc { ;; 1: len 6; hex 00001c31931f; asc 1 ;; 2: len 7; hex 63000002e30164; asc c d;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383236; asc 1748951826;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b04; asc { ;; 1: len 6; hex 00001c31931f; asc 1 ;; 2: len 7; hex 63000002e30204; asc c ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3330353436; asc _transient_wc_related_30546;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 302 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b05; asc { ;; 1: len 6; hex 00001c31930d; asc 1 ;; 2: len 7; hex 5a000002da0164; asc Z d;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383433; asc 1748951843;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 29 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b06; asc { ;; 1: len 6; hex 00001c31930d; asc 1 ;; 2: len 7; hex 5a000002da0258; asc Z X;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3334333536; asc _transient_wc_related_34356;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 471 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 30 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b07; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 34 bytes); 4: len 10; hex 31373438393531383436; asc 1748951846;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 31 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b08; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 26; hex 5f7472616e7369656e745f77635f72656c617465645f37383633; asc _transient_wc_related_7863;; 4: len 30; hex 613a313a7b733a35323a226c696d69743d34266578636c7564655f696473; asc a:1:{s:52:"limit=4&exclude_ids; (total 447 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 32 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b09; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383630; asc 1748951860;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 33 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b0a; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3237393738; asc _transient_wc_related_27978;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 471 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 34 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b0b; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383730; asc 1748951870;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 35 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b0c; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3334343337; asc _transient_wc_related_34437;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 284 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 36 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b0d; asc { ;; 1: len 6; hex 00001c31930d; asc 1 ;; 2: len 7; hex 5a000002da0110; asc Z ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f77635f72656c617465645f; asc _transient_timeout_wc_related_; (total 35 bytes); 4: len 10; hex 31373438393531383930; asc 1748951890;; 5: len 3; hex 6f6666; asc off;; Record lock, heap no 37 PHYSICAL RECORD: n_fields 6; compact format; info bits 32 0: len 8; hex 00000000020f7b0e; asc { ;; 1: len 6; hex 00001c31930d; asc 1 ;; 2: len 7; hex 5a000002da020c; asc Z ;; 3: len 27; hex 5f7472616e7369656e745f77635f72656c617465645f3334323639; asc _transient_wc_related_34269;; 4: len 30; hex 613a313a7b733a35333a226c696d69743d34266578636c7564655f696473; asc a:1:{s:53:"limit=4&exclude_ids; (total 471 bytes); 5: len 3; hex 6f6666; asc off;; Record lock, heap no 38 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 8; hex 00000000020f7b0f; asc { ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 30; hex 5f7472616e7369656e745f74696d656f75745f636d706c7a5f626c6f636b; asc _transient_timeout_cmplz_block; (total 40 bytes); 4: len 10; hex 31373438383635383331; asc 1748865831;; 5: len 3; hex 6f6666; asc off;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 473275204 Purge done for trx's n:o < 473255068 undo n:o < 0 state: running History list length 9003 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x5b8493556140), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 473274131, ACTIVE 217 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 763743, OS thread handle 137236988413632, query id 672968569 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962395, 'action reset', '2025-06-02 17:25:08', '2025-06-02 19:25:08') ---TRANSACTION 473271210, ACTIVE 518 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 763343, OS thread handle 137236969547456, query id 672478125 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962403, 'action created', '2025-06-02 17:20:07', '2025-06-02 19:20:07') ---TRANSACTION 473270228, ACTIVE 674 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 763230, OS thread handle 137236969854656, query id 672342779 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962402, 'action created', '2025-06-02 17:17:31', '2025-06-02 19:17:31') ---TRANSACTION 473269104, ACTIVE 822 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 763123, OS thread handle 137236962076352, query id 672202579 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962394, 'action reset', '2025-06-02 17:15:03', '2025-06-02 19:15:03') ---TRANSACTION 473269071, ACTIVE 823 sec starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MariaDB thread id 763122, OS thread handle 137236967397056, query id 672201919 localhost TRUNCATED Updating DELETE FROM `wp_actionscheduler_logs` WHERE `action_id` = 670947 ---TRANSACTION 473267369, ACTIVE 1100 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 762813, OS thread handle 137236968011456, query id 671952440 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962401, 'action created', '2025-06-02 17:10:25', '2025-06-02 19:10:25') ---TRANSACTION 473264785, ACTIVE 1418 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 762541, OS thread handle 137236968933056, query id 671581110 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962393, 'action reset', '2025-06-02 17:05:07', '2025-06-02 19:05:07') ---TRANSACTION 473262652, ACTIVE 1719 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 762294, OS thread handle 137236970161856, query id 671285779 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962399, 'action created', '2025-06-02 17:00:06', '2025-06-02 19:00:06') ---TRANSACTION 473262698, ACTIVE 1718 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 762295, OS thread handle 137236988106432, query id 671286651 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962400, 'action created', '2025-06-02 17:00:07', '2025-06-02 19:00:07') ---TRANSACTION 473259896, ACTIVE 2021 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 761997, OS thread handle 137236967704256, query id 670999916 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962392, 'action reset', '2025-06-02 16:55:04', '2025-06-02 18:55:04') ---TRANSACTION 473257864, ACTIVE 2301 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 761714, OS thread handle 137236970469056, query id 670760159 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962398, 'action created', '2025-06-02 16:50:24', '2025-06-02 18:50:24') ---TRANSACTION 473256918, ACTIVE 2441 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 761633, OS thread handle 137236966782656, query id 670631494 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962397, 'action created', '2025-06-02 16:48:04', '2025-06-02 18:48:04') ---TRANSACTION 473255529, ACTIVE 2576 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 761514, OS thread handle 137236968625856, query id 670494694 localhost TRUNCATED Update INSERT INTO `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) VALUES (962391, 'action complete via Async Request', '2025-06-02 16:45:49', '2025-06-02 18:45:49') -------- FILE I/O -------- Pending flushes (fsync): 0 37325698 OS file reads, 2538044 OS file writes, 309799 OS fsyncs 1.00 reads/s, 16384 avg bytes/read, 5.99 writes/s, 3.00 fsyncs/s --- LOG --- Log sequence number 407724346945 Log flushed up to 407724346945 Pages flushed up to 407705794801 Last checkpoint at 407705794801 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 134217728 Dictionary memory allocated 1067280 Buffer pool size 7098 Free buffers 1535 Database pages 5563 Old database pages 2033 Modified db pages 6 Percent of dirty pages(LRU & free pages): 0.085 Max dirty pages percent: 90.000 Pending reads 1 Pending writes: LRU 0, flush list 0 Pages made young 76673534, not young 860104218 25.97 youngs/s, 12.99 non-youngs/s Pages read 37325417, created 1064456, written 2485655 1.00 reads/s, 0.00 creates/s, 5.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 5563, unzip_LRU len: 0 I/O sum[2845]:cur[6], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================