Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-05-13 12:50:49 0x2b44 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 45 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 16952 srv_active, 0 srv_shutdown, 888310 srv_idle
srv_master_thread log flush and writes: 905262
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3421451
OS WAIT ARRAY INFO: signal count 2004485
RW-shared spins 1164751, rounds 30161318, OS waits 918403
RW-excl spins 480647, rounds 2046071, OS waits 41257
RW-sx spins 59951, rounds 1071557, OS waits 24849
Spin rounds per wait: 25.90 RW-shared, 4.26 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 3570129
Purge done for trx's n:o < 3570129 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
24122146 OS file reads, 2728780 OS file writes, 1312737 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, 5033 merges
merged operations:
 insert 162163, 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.16 hash searches/s, 0.16 non-hash searches/s
---
LOG
---
Log sequence number 749924728
Log flushed up to   749924728
Pages flushed up to 749924728
Last checkpoint at  749924719
0 pending log flushes, 0 pending chkp writes
1171618 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       731
Database pages     264
Old database pages 0
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 468106487, not young 466221477
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24122097, created 29723, written 1503085
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: 264, 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 1173711, updated 118848, deleted 327960, read 41228194358
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.18 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 494
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================