API tools faq
paste
Advertisement
Guest User

MariaDB 10.11.11 Hang

a guest
Apr 24th, 2025
21
0
362 days
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.03 KB | Help | 0 0
raw download clone embed print report
  1. Id User Host db Command Time State Info Progress
  2. 8597007 redacted localhost redacted Query 72 Update INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('15', '2025-04-24 07:49:23', 1, '', '') 0.000
  3. 8597220 redacted localhost redacted Query 42 Update INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('15', '2025-04-24 07:49:52', 1, '', '') 0.000
  4. 8597326 redacted localhost redacted Query 32 Update INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('02', '2025-04-24 07:50:03', 1, '', '') 0.000
  5. 8597439 redacted localhost redacted Sleep 1 NULL 0.000
  6. 8597458 redacted localhost redacted Query 16 Update INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('<redacted>', '2025-04-24 07:50:18', 1, '', '') 0.000
  7. 8597682 redacted localhost redacted Query 2 Update INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('02', '2025-04-24 07:50:32', 1, '', '') 0.000
  8. 8597699 redacted localhost redacted Sleep 0 NULL 0.000
  9. 8597706 root localhost NULL Query 0 starting SHOW FULL PROCESSLIST 0.000
  10.  
  11. =====================================
  12. 2025-04-23 23:50:35 0x7fbb111f66c0 INNODB MONITOR OUTPUT
  13. =====================================
  14. Per second averages calculated from the last 30 seconds
  15. -----------------
  16. BACKGROUND THREAD
  17. -----------------
  18. srv_master_thread loops: 835 srv_active, 0 srv_shutdown, 798067 srv_idle
  19. srv_master_thread log flush and writes: 798902
  20. ----------
  21. SEMAPHORES
  22. ----------
  23. ------------------------
  24. LATEST DETECTED DEADLOCK
  25. ------------------------
  26. 2025-04-22 22:47:02 0x7fbb9c06c6c0
  27. *** (1) TRANSACTION:
  28. TRANSACTION 15896049065, ACTIVE 0 sec fetching rows
  29. mysql tables in use 3, locked 3
  30. LOCK WAIT 213 lock struct(s), heap size 24696, 18312 row lock(s)
  31. MariaDB thread id 7561112, OS thread handle 140443753301696, query id 1249654721 localhost redacted init for update
  32. UPDATE wp_actionscheduler_actions SET claim_id=3709294, last_attempt_gmt='2025-04-23 05:47:02', last_attempt_local='2025-04-23 06:47:02' WHERE claim_id = 0 AND scheduled_date_gmt <= '2025-04-23 05:47:02' AND status='pending' ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25
  33. *** WAITING FOR THIS LOCK TO BE GRANTED:
  34. RECORD LOCKS space id 1369764 page no 991 n bits 768 index status of table `redacted`.`wp_actionscheduler_actions` trx id 15896049065 lock_mode X waiting
  35. Record lock, heap no 671 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  36. 0: len 7; hex 70656e64696e67; asc pending;;
  37. 1: len 8; hex 0000000000b9bb78; asc x;;
  38.  
  39. *** CONFLICTING WITH:
  40. RECORD LOCKS space id 1369764 page no 991 n bits 768 index status of table `redacted`.`wp_actionscheduler_actions` trx id 15896049073 lock_mode X locks rec but not gap
  41. Record lock, heap no 671 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  42. 0: len 7; hex 70656e64696e67; asc pending;;
  43. 1: len 8; hex 0000000000b9bb78; asc x;;
  44.  
  45.  
  46. 98
  47. *** CONFLICTING WITH:
  48. RECORD LOCKS space id 1369764 page no 991 n bits 768 index status of table `redacted`.`wp_actionscheduler_actions` trx id 15896049065 lock_mode X
  49. Record lock, heap no 662 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  50. 0: len 7; hex 70656e64696e67; asc pending;;
  51. 1: len 8; hex 0000000000b800cf; asc ;;
  52.  
  53. Record lock, heap no 663 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  54. 0: len 7; hex 70656e64696e67; asc pending;;
  55. 1: len 8; hex 0000000000b8044b; asc K;;
  56.  
  57. Record lock, heap no 664 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  58. 0: len 7; hex 70656e64696e67; asc pending;;
  59. 1: len 8; hex 0000000000b84042; asc @B;;
  60.  
  61. Record lock, heap no 665 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  62. 0: len 7; hex 70656e64696e67; asc pending;;
  63. 1: len 8; hex 0000000000b95118; asc Q ;;
  64.  
  65. Record lock, heap no 666 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  66. 0: len 7; hex 70656e64696e67; asc pending;;
  67. 1: len 8; hex 0000000000b9909f; asc ;;
  68.  
  69. Record lock, heap no 667 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  70. 0: len 7; hex 70656e64696e67; asc pending;;
  71. 1: len 8; hex 0000000000b99a64; asc d;;
  72.  
  73. Record lock, heap no 668 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  74. 0: len 7; hex 70656e64696e67; asc pending;;
  75. 1: len 8; hex 0000000000b99a65; asc e;;
  76.  
  77. *** WE ROLL BACK TRANSACTION (1)
  78. ------------
  79. TRANSACTIONS
  80. ------------
  81. Trx id counter 15900136305
  82. Purge done for trx's n:o < 15900136296 undo n:o < 0 state: running
  83. History list length 1407
  84. LIST OF TRANSACTIONS FOR EACH SESSION:
  85. ---TRANSACTION (0x7fbb9f404380), not started
  86. 0 lock struct(s), heap size 1128, 0 row lock(s)
  87. ---TRANSACTION (0x7fbb9f406f80), not started
  88. 0 lock struct(s), heap size 1128, 0 row lock(s)
  89. ---TRANSACTION (0x7fbb9f3ff680), not started
  90. 0 lock struct(s), heap size 1128, 0 row lock(s)
  91. ---TRANSACTION (0x7fbb9f404e80), not started
  92. 0 lock struct(s), heap size 1128, 0 row lock(s)
  93. ---TRANSACTION (0x7fbb9f405980), not started
  94. 0 lock struct(s), heap size 1128, 0 row lock(s)
  95. ---TRANSACTION 15900136247, ACTIVE 3 sec inserting
  96. mysql tables in use 1, locked 1
  97. 1 lock struct(s), heap size 1128, 0 row lock(s)
  98. MariaDB thread id 8597682, OS thread handle 140443754120896, query id 1424570532 localhost redacted Update
  99. INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('02', '2025-04-24 07:50:32', 1, '', '')
  100. ---TRANSACTION (0x7fbb9f402d80), not started
  101. 0 lock struct(s), heap size 1128, 0 row lock(s)
  102. ---TRANSACTION (0x7fbb9f400c80), not started
  103. 0 lock struct(s), heap size 1128, 0 row lock(s)
  104. ---TRANSACTION 15900135437, ACTIVE 17 sec inserting
  105. mysql tables in use 1, locked 1
  106. 1 lock struct(s), heap size 1128, 0 row lock(s)
  107. MariaDB thread id 8597458, OS thread handle 140444290127552, query id 1424555212 localhost redacted Update
  108. INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('<redacted>', '2025-04-24 07:50:18', 1, '', '')
  109. ---TRANSACTION (0x7fbb9f407a80), not started
  110. 0 lock struct(s), heap size 1128, 0 row lock(s)
  111. ---TRANSACTION 15900134864, ACTIVE 32 sec inserting
  112. mysql tables in use 1, locked 1
  113. 1 lock struct(s), heap size 1128, 0 row lock(s)
  114. MariaDB thread id 8597326, OS thread handle 140443754325696, query id 1424540084 localhost redacted Update
  115. INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('02', '2025-04-24 07:50:03', 1, '', '')
  116. ---TRANSACTION 15900134271, ACTIVE 43 sec inserting
  117. mysql tables in use 1, locked 1
  118. 1 lock struct(s), heap size 1128, 0 row lock(s)
  119. MariaDB thread id 8597220, OS thread handle 140441414899392, query id 1424530951 localhost redacted Update
  120. INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('15', '2025-04-24 07:49:52', 1, '', '')
  121. ---TRANSACTION 15900132917, ACTIVE 72 sec inserting
  122. mysql tables in use 1, locked 1
  123. 1 lock struct(s), heap size 1128, 0 row lock(s)
  124. MariaDB thread id 8597007, OS thread handle 140441423496896, query id 1424510658 localhost redacted Update
  125. INSERT INTO `wp_rank_math_404_logs` (`uri`, `accessed`, `times_accessed`, `referer`, `user_agent`) VALUES ('15', '2025-04-24 07:49:23', 1, '', '')
  126. ---TRANSACTION (0x7fbb9f3feb80), not started
  127. 0 lock struct(s), heap size 1128, 0 row lock(s)
  128. --------
  129. FILE I/O
  130. --------
  131. Pending flushes (fsync): 0
  132. 166351415 OS file reads, 6987933 OS file writes, 3639237 OS fsyncs
  133. 156.66 reads/s, 7878 avg bytes/read, 71.50 writes/s, 13.17 fsyncs/s
  134. -------------
  135. INSERT BUFFER
  136. -------------
  137. size 6, free list len 11863, seg size 11870, 0 merges
  138. merged operations:
  139. insert 0, delete mark 0, delete 0
  140. discarded operations:
  141. insert 0, delete mark 0, delete 0
  142. ---
  143. LOG
  144. ---
  145. Log sequence number 17970676587722
  146. Log flushed up to 17970676583883
  147. Pages flushed up to 17970643193368
  148. Last checkpoint at 17970643193368
  149. ----------------------
  150. BUFFER POOL AND MEMORY
  151. ----------------------
  152. Total large memory allocated 2181038080
  153. Dictionary memory allocated 92637472
  154. Buffer pool size 129791
  155. Free buffers 1396
  156. Database pages 128387
  157. Old database pages 47412
  158. Modified db pages 80
  159. Percent of dirty pages(LRU & free pages): 0.062
  160. Max dirty pages percent: 90.000
  161. Pending reads 0
  162. Pending writes: LRU 0, flush list 15
  163. Pages made young 196468759, not young 3200160866
  164. 65.33 youngs/s, 3222.73 non-youngs/s
  165. Pages read 166314664, created 2924018, written 6791751
  166. 156.66 reads/s, 3.00 creates/s, 70.53 writes/s
  167. Buffer pool hit rate 994 / 1000, young-making rate 2 / 1000 not 108 / 1000
  168. Pages read ahead 81.03/s, evicted without access 0.00/s, Random read ahead 0.00/s
  169. LRU len: 128387, unzip_LRU len: 0
  170. I/O sum[10256]:cur[2292], unzip sum[0]:cur[0]
  171. --------------
  172. ROW OPERATIONS
  173. --------------
  174. 1 read views open inside InnoDB
  175. state: sleeping
  176. ----------------------------
  177. END OF INNODB MONITOR OUTPUT
  178. ============================
  179.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!