Storage engines

InnoDB

Supports transactions, row-level locking, foreign keys and encryption for tables

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-09-12 06:52:09 0x1cc INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 50 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 410657 srv_active, 0 srv_shutdown, 857662 srv_idle
srv_master_thread log flush and writes: 1268319
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 639915
OS WAIT ARRAY INFO: signal count 613658
RW-shared spins 600400, rounds 14732533, OS waits 468118
RW-excl spins 361740, rounds 543649, OS waits 2525
RW-sx spins 638, rounds 12626, OS waits 316
Spin rounds per wait: 24.54 RW-shared, 1.50 RW-excl, 19.79 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2025-08-28 09:34:21 0x1694
*** (1) TRANSACTION:
TRANSACTION 1272553, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1
MySQL thread id 39, OS thread handle 4748, query id 1791 localhost ::1 blog1 Update
INSERT INTO `rce_blogoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_site_transient_timeout_wp_theme_files_patterns-0a7a016d5e227886def40dc10d12de93', '1756355661', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1315 page no 27 n bits 384 index option_name of table `rce_blog1`.`rce_blogoptions` trx id 1272553 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 18 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 30; hex 5f736974655f7472616e7369656e745f74696d656f75745f77705f746865; asc _site_transient_timeout_wp_the; (total 80 bytes);
 1: len 8; hex 000000000007c0fc; asc         ;;

*** (2) TRANSACTION:
TRANSACTION 1272558, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
4 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 1
MySQL thread id 38, OS thread handle 5780, query id 1796 localhost ::1 blog1 Update
INSERT INTO `rce_blogoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_site_transient_timeout_wp_theme_files_patterns-0a7a016d5e227886def40dc10d12de93', '1756355661', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1315 page no 27 n bits 384 index option_name of table `rce_blog1`.`rce_blogoptions` trx id 1272558 lock_mode X
Record lock, heap no 18 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 30; hex 5f736974655f7472616e7369656e745f74696d656f75745f77705f746865; asc _site_transient_timeout_wp_the; (total 80 bytes);
 1: len 8; hex 000000000007c0fc; asc         ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1315 page no 27 n bits 384 index option_name of table `rce_blog1`.`rce_blogoptions` trx id 1272558 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 18 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 30; hex 5f736974655f7472616e7369656e745f74696d656f75745f77705f746865; asc _site_transient_timeout_wp_the; (total 80 bytes);
 1: len 8; hex 000000000007c0fc; asc         ;;

*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 2629586
Purge done for trx's n:o < 2629586 undo n:o < 0 state: running
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283312581648744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581644576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581640408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581636240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581682088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581677920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581673752, not started flushing log
mysql tables in use 1, locked 1
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581669584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581657080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283312581652912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: native aio handle (insert buffer thread)
I/O thread 1 state: native aio handle (log thread)
I/O thread 2 state: native aio handle (read thread)
I/O thread 3 state: native aio handle (read thread)
I/O thread 4 state: native aio handle (read thread)
I/O thread 5 state: native aio handle (read thread)
I/O thread 6 state: native aio handle (write thread)
I/O thread 7 state: native aio handle (write thread)
I/O thread 8 state: native aio handle (write thread)
I/O thread 9 state: native aio handle (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: 1; buffer pool: 0
39029986 OS file reads, 5457404 OS file writes, 3407817 OS fsyncs
11.46 reads/s, 16384 avg bytes/read, 5.78 writes/s, 3.78 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 192, seg size 194, 281 merges
merged operations:
 insert 0, delete mark 732, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
6.00 hash searches/s, 18.88 non-hash searches/s
---
LOG
---
Log sequence number 3771175477
Log flushed up to   3771174149
Pages flushed up to 3771168109
Last checkpoint at  3771168100
1 pending log flushes, 0 pending chkp writes
1967990 log i/o's done, 2.28 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 1287056
Buffer pool size   1003
Free buffers       245
Database pages     750
Old database pages 287
Modified db pages  13
Percent of dirty pages(LRU & free pages): 1.305
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16375836, not young 840495069
0.28 youngs/s, 23.92 non-youngs/s
Pages read 39029467, created 29323, written 2980744
11.46 reads/s, 0.08 creates/s, 2.98 writes/s
Buffer pool hit rate 969 / 1000, young-making rate 0 / 1000 not 62 / 1000
Pages read ahead 1.28/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 750, unzip_LRU len: 0
I/O sum[644]:cur[22], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=2932, Main thread ID=4640, state: sleeping
Number of rows inserted 156986, updated 586937, deleted 6320, read 12826976292
0.00 inserts/s, 0.70 updates/s, 0.00 deletes/s, 2763.78 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 2654499
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================