*************************** 1. row ***************************
  Type: InnoDB
  Name: 
Status: 
=====================================
2022-11-09 12:03:12 0x7fda8db15700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 12 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 4902 srv_idle
srv_master_thread log flush and writes: 4902
----------
SEMAPHORES
----------
------------
TRANSACTIONS
------------
Trx id counter 5296050156
Purge done for trx's n:o < 5296050156 undo n:o < 0 state: running
History list length 34
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION (0x7feb101d0a80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cff80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cf480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ce980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cde80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cd380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cc880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cbd80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101cb280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ca780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c9c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c9180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c8680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c7b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c7080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c6580), not started
mysql tables in use 2, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c5a80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c4f80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c4480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c3980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c2e80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c2380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c1880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c0d80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101c0280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bf780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bec80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101be180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bd680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bcb80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bc080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101bb580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101baa80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b9f80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b9480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b8980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b7e80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b7380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b6880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b5d80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b5280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b4780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b3c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b3180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b2680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b1b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b1080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101b0580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101afa80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101aef80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ae480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ad980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ace80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ac380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101ab880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101aad80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101aa280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a9780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a8c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a8180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a7680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a6b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a6080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a5580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a4a80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a3f80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a3480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a2980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a1e80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a1380), not started
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb101a0880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019fd80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019f280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019e780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019dc80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019d180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019c680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019bb80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019b080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1019a580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10199a80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10198f80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10198480), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10197980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10196e80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10196380), not started
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10195880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10194d80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10194280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10193780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10192c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10192180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10191680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10190b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10190080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018f580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018ea80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018df80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018d480), ACTIVE 0 sec
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 133, OS thread handle 140577165747968, query id 47882009 localhost pdns-read-only Starting cleanup
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type='SOA' and name='radiochristmas.co.uk'
---TRANSACTION (0x7feb1018c980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018be80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018b380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1018a880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10189d80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10189280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10188780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10187c80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10187180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10186680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10185b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10185080), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10184580), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10183a80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10182480), not started
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10182f80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10181980), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10180e80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb10180380), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017f880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017ed80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017e280), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017d780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017cc80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017c180), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017b680), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7feb1017ab80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
3580775 OS file reads, 9877 OS file writes, 3933 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.08 writes/s, 0.67 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20619, seg size 20621, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 2162525446920
Log flushed up to   2162525446800
Pages flushed up to 2162500329210
Last checkpoint at  2162500329198
0 pending log flushes, 0 pending chkp writes
9879 log i/o's done, 1.08 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 69273124864
Dictionary memory allocated 428181144
Buffer pool size   4185792
Free buffers       604109
Database pages     3581683
Old database pages 1322124
Modified db pages  14374
Percent of dirty pages(LRU & free pages): 0.343
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 215, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3579829, created 930, written 0
0.00 reads/s, 0.08 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: 3581683, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 23434, updated 2887, deleted 19092, read 1116405503
1.08 inserts/s, 0.75 updates/s, 0.67 deletes/s, 48530.96 reads/s
Number of system rows inserted 8473, updated 0, deleted 8447, read 8468
0.75 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================