Storage engines

InnoDB

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

[ Variables | Buffer Pool | InnoDB Status ]

=====================================
2024-07-12 07:36:25 0x2a1c INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 5 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 335659 srv_active, 0 srv_shutdown, 2352877 srv_idle
srv_master_thread log flush and writes: 2688536
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 9528597
--Thread 8028 has waited at row0ins.cc line 2634 for 0.00 seconds the semaphore:
X-lock on RW-latch at 000001C824ED2698 created in file buf0buf.cc line 1568
a writer (thread id 0) has reserved it in mode  SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time write locked in file buf0flu.cc line 1147
OS WAIT ARRAY INFO: signal count 26860677
RW-shared spins 36819871, rounds 210500252, OS waits 2659767
RW-excl spins 95795704, rounds 363183228, OS waits 2578753
RW-sx spins 3974027, rounds 6252667, OS waits 101080
Spin rounds per wait: 5.72 RW-shared, 3.79 RW-excl, 1.57 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 9329594
Purge done for trx's n:o < 9329593 undo n:o < 0 state: running
History list length 29
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283434097111352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283434097107176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 9329593, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 826
MySQL thread id 100736, OS thread handle 8028, query id 463737828 localhost 127.0.0.1 fmc_tsel Update
INSERT INTO data_mydita_order_detail (ORDER_ID, ORDER_CODE, NAME, DESCRIPTION, STATUS_VERIFIKASI, XS15, XS17, ORDER_DESC, CREATE_DTM, XS14, XS1, XS2, LAST_CALL, SF_ID) VALUES ( ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?,  ?)
--------
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
89339543 OS file reads, 107758610 OS file writes, 6179579 OS fsyncs
341.33 reads/s, 16384 avg bytes/read, 393.32 writes/s, 17.60 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 71, free list len 262, seg size 334, 15047642 merges
merged operations:
 insert 298486324, delete mark 491, 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 7 buffer(s)
Hash table size 4441, node heap has 1 buffer(s)
3.00 hash searches/s, 3835.03 non-hash searches/s
---
LOG
---
Log sequence number 1769254440687
Log flushed up to   1769254438485
Pages flushed up to 1769252986429
Last checkpoint at  1769252986429
1 pending log flushes, 0 pending chkp writes
2258592 log i/o's done, 6.20 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 262920
Buffer pool size   1003
Free buffers       212
Database pages     777
Old database pages 268
Modified db pages  774
Percent of dirty pages(LRU & free pages): 78.182
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 96, flush list 0, single page 0
Pages made young 10193428, not young 1247772586
27.19 youngs/s, 961.01 non-youngs/s
Pages read 89339433, created 7264520, written 103277843
341.33 reads/s, 13.60 creates/s, 380.32 writes/s
Buffer pool hit rate 978 / 1000, young-making rate 1 / 1000 not 59 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 777, unzip_LRU len: 0
I/O sum[29704]:cur[229], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=7152, Main thread ID=3012, state: sleeping
Number of rows inserted 462810455, updated 2001, deleted 318024, read 1349300797
385.12 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.40 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 4133
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================