Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2025-05-11 14:46:51 0x34d0 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 15 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 16677 srv_active, 0 srv_shutdown, 724798 srv_idle
srv_master_thread log flush and writes: 741475
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2918145
OS WAIT ARRAY INFO: signal count 1532914
RW-shared spins 669008, rounds 15767066, OS waits 464908
RW-excl spins 354105, rounds 1885932, OS waits 39847
RW-sx spins 59951, rounds 1071557, OS waits 24849
Spin rounds per wait: 23.57 RW-shared, 5.33 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 3569255
Purge done for trx's n:o < 3569255 undo n:o < 0 state: running but idle
History list length 5
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
13688080 OS file reads, 2724913 OS file writes, 1311036 OS fsyncs
0.40 reads/s, 16384 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, 4918 merges
merged operations:
 insert 161899, 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.00 hash searches/s, 0.53 non-hash searches/s
---
LOG
---
Log sequence number 749443017
Log flushed up to   749443017
Pages flushed up to 749443017
Last checkpoint at  749443008
0 pending log flushes, 0 pending chkp writes
1170607 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       1
Database pages     994
Old database pages 371
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 466579711, not young 429675387
0.00 youngs/s, 0.73 non-youngs/s
Pages read 13688031, created 29708, written 1500418
0.40 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 454 / 1000, young-making rate 0 / 1000 not 1000 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 994, unzip_LRU len: 0
I/O sum[0]:cur[6], 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 1173336, updated 118762, deleted 327960, read 40787603447
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.33 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
============================