Untitled

SHOW ENGINE INNODB STATUS;
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type   | Name | Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB |      |
=====================================
2024-02-05 07:03:35 0x7f7f38e7a700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 24 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 132407 srv_active, 0 srv_shutdown, 4284 srv_idle
srv_master_thread log flush and writes: 136691
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 12676706
OS WAIT ARRAY INFO: signal count 41691982
RW-shared spins 112906233, rounds 1875483192, OS waits 8122506
RW-excl spins 7418058, rounds 166586996, OS waits 4366368
RW-sx spins 6720, rounds 187078, OS waits 5639
Spin rounds per wait: 16.61 RW-shared, 22.46 RW-excl, 27.84 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 6901807622
Purge done for trx's n:o < 6901806703 undo n:o < 0 state: running but idle
History list length 372
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421659389534736, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 437426, OS thread handle 140176604219136, query id 113564402 localhost mywebsite Sending data
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
Trx read view will not see trx with id >= 6901807622, sees < 6901807622
---TRANSACTION 421659389530480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421659389526224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421659389538992, ACTIVE 3 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 437409, OS thread handle 140176622847744, query id 113560992 localhost mywebsite Sending data
SELECT post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = 'product' GROUP BY post_status
Trx read view will not see trx with id >= 6901807522, sees < 6901807522
---TRANSACTION 421659389577296, ACTIVE 41 sec fetching rows
mysql tables in use 6, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 437197, OS thread handle 140184391665408, query id 113531499 localhost mywebsite Sending data
SELECT  DISTINCT wp_posts.ID
                                        FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
                                        WHERE 1=1  AND (
  wp_posts.ID NOT IN (
                                SELECT object_id
                                FROM wp_term_relationships
                                WHERE term_taxonomy_id IN (1582,3909,4718,14183)
                        )
) AND ( ((wp_posts.post_title LIKE 'sony%') OR (wp_posts.post_content LIKE 'sony%')) OR  ((wp_posts.post_title LIKE 'a7%') OR (wp_posts.post_content LIKE 'a7%')) OR  ((wp_posts.post_title LIKE 'iv%') OR (wp_posts.post_content LIKE 'iv%')))  AND (wp_posts.post_password = '')  AND (
  ( wp_postmeta.meta_key = '_stock_status' AND w
Trx read view will not see trx with id >= 6901806700, sees < 6901806700
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
9299966429 OS file reads, 8895921 OS file writes, 3738389 OS fsyncs
110891.67 reads/s, 13179 avg bytes/read, 18.12 writes/s, 9.21 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 990, free list len 85702, seg size 86693, 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, 305168.12 non-hash searches/s
---
LOG
---
Log sequence number 9219253891647
Log flushed up to   9219253891647
Pages flushed up to 9219205528245
Last checkpoint at  9219205528057
0 pending log flushes, 0 pending chkp writes
3126708 log i/o's done, 7.67 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 7516192768
Dictionary memory allocated 32609160
Buffer pool size   322600
Free buffers       0
Database pages     322600
Old database pages 119065
Modified db pages  581
Percent of dirty pages(LRU & free pages): 0.180
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 699410555, not young 49317516937
844.55 youngs/s, 524083.79 non-youngs/s
Pages read 9291980638, created 557399, written 5605071
110730.09 reads/s, 0.46 creates/s, 10.12 writes/s
Buffer pool hit rate 921 / 1000, young-making rate 0 / 1000 not 370 / 1000
Pages read ahead 21521.39/s, evicted without access 17586.14/s, Random read ahead 0.00/s
LRU len: 322600, unzip_LRU len: 0
I/O sum[4458832]:cur[728801], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
3 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 918696, updated 4374700, deleted 577061, read 122617648295
5.67 inserts/s, 0.87 updates/s, 2.33 deletes/s, 695540.39 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
 |
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.003 sec)

MariaDB [(none)]>