Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-05-09 21:56:18 0x3f0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 59 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 16463 srv_active, 0 srv_shutdown, 579499 srv_idle
srv_master_thread log flush and writes: 595962
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2818426
OS WAIT ARRAY INFO: signal count 1440124
RW-shared spins 570691, rounds 12938219, OS waits 376225
RW-excl spins 324900, rounds 1846574, OS waits 39491
RW-sx spins 59946, rounds 1071504, OS waits 24849
Spin rounds per wait: 22.67 RW-shared, 5.68 RW-excl, 17.87 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-05-07 14:50:03 0x36e8 Error in foreign key constraint of table `textmessaging`.`email_clicks`:
FOREIGN KEY (emailId) REFERENCES email(Id)  
):
Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
Please refer to https://mariadb.com/kb/en/library/foreign-keys/ for correct foreign key definition.
Create  table `textmessaging`.`email_clicks` with foreign key constraint failed. Field type or character set for column 'emailId' does not mach referenced column 'Id' near 'FOREIGN KEY (emailId) REFERENCES email(Id)  
)'.
------------
TRANSACTIONS
------------
Trx id counter 3567537
Purge done for trx's n:o < 3567537 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 284346449400024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 284346449395856, 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: 0; buffer pool: 0
11606986 OS file reads, 2717962 OS file writes, 1307824 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 202, seg size 204, 4800 merges
merged operations:
 insert 161625, delete mark 133863, delete 5806
discarded operations:
 insert 4, 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)
0.22 hash searches/s, 0.34 non-hash searches/s
---
LOG
---
Log sequence number 747999188
Log flushed up to   747999188
Pages flushed up to 747999188
Last checkpoint at  747999179
0 pending log flushes, 0 pending chkp writes
1168620 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 122696
Buffer pool size   1003
Free buffers       0
Database pages     995
Old database pages 347
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 466312258, not young 422309451
0.00 youngs/s, 0.00 non-youngs/s
Pages read 11606937, created 29659, written 1495812
0.00 reads/s, 0.00 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: 995, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=4024, Main thread ID=13840, state: sleeping
Number of rows inserted 1172791, updated 118445, deleted 327809, read 40700500685
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.22 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 247
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================