Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[
Variables
|
Buffer Pool
|
InnoDB Status
]
=====================================
2026-08-23 23:11:37 0x2118 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 40 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 19047 srv_active, 0 srv_shutdown, 3029659 srv_idle
srv_master_thread log flush and writes: 3048706
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 127370
OS WAIT ARRAY INFO: signal count 12828
RW-shared spins 14853, rounds 334695, OS waits 10210
RW-excl spins 6663, rounds 23155, OS waits 315
RW-sx spins 432, rounds 3133, OS waits 57
Spin rounds per wait: 22.53 RW-shared, 3.48 RW-excl, 7.25 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2026-07-25 19:22:27 0x12a8 Transaction:
TRANSACTION 1052254, ACTIVE 0 sec updating or deleting
mysql tables in use 5, locked 5
15 lock struct(s), heap size 1128, 18 row lock(s), undo log entries 7
MySQL thread id 2100, OS thread handle 4776, query id 31000 localhost ::1 root Updating
DELETE FROM users WHERE id=?
Foreign key constraint fails for table `oficina_pumagarage`.`services`:
,
CONSTRAINT `services_ibfk_3` FOREIGN KEY (`mechanic_id`) REFERENCES `users` (`id`)
Trying to delete or update in parent table, in index PRIMARY tuple:
DATA TUPLE: 13 fields;
0: len 4; hex 8000000e; asc ;;
1: len 6; hex 000000100e5e; asc ^;;
2: len 7; hex 39000001b024c9; asc 9 $ ;;
3: len 6; hex 44616e69656c; asc Daniel;;
4: len 60; hex 243279243130246d4f7161796a45364e51494a4173343845316a48392e336449586952485239475a47493275506c545649664f4d76324a70664d6357; asc $2y$10$mOqayjE6NQIJAs48E1jH9.3dIXiRHR9GZGI2uPlTVIfOMv2JpfMcW;;
5: len 1; hex 81; asc ;;
6: len 0; hex ; asc ;;
7: len 1; hex 80; asc ;;
8: len 510; hex 636c69656e74732e7068702c636172732e7068702c6170706f696e746d656e74732e7068702c696e76656e746f72792e7068702c75706c6f61645f6176617461722e7068702c6f62645f6c6f636174696f6e2e7068702c6f62645f6661756c74636f6465732e7068702c6f62642e7068702c6469616772616d5f62656c74732e7068702c6469616772616d5f746f72717565732e7068702c746563686e6963616c5f766964656f732e7068702c726164696f5f636f64652e7068702c676574706c6174655f696e666f2e7068702c64617368626f6172642e7068702c6c6f676f75742e7068702c737570706f72742e7068702c696e666f2e7068702c70726f66696c652e7068702c616c657274732e7068702c7469636b6574732e7068702c6e6f7465732e7068702c736176655f636865636b6c6973742e7068702c67656e65726174655f636865636b6c6973745f7064662e7068702c6d656e755f656e7465727461696e6d656e742e7068702c666c617070795f626972642e7068702c7061636d616e2e7068702c706f6e672e7068702c736e616b652e7068702c6361725f636865636b6c697374732e7068702c6361725f636865636b6c6973745f666f726d2e7068702c766965775f636865636b6c6973742e7068702c746563686e6963616c2e7068702c6361726170692e7068702c6175746f646174612e706870; asc clients.php,cars.php,appointments.php,inventory.php,upload_avatar.php,obd_location.php,obd_faultcodes.php,obd.php,diagram_belts.php,diagram_torques.php,technical_videos.php,radio_code.php,getplate_info.php,dashboard.php,logout.php,support.php,info.php,profile.php,alerts.php,tickets.php,notes.php,save_checklist.php,generate_checklist_pdf.php,menu_entertainment.php,flappy_bird.php,pacman.php,pong.php,snake.php,car_checklists.php,car_checklist_form.php,view_checklist.php,technical.php,carapi.php,autodata.php;;
9: len 2; hex 7b7d; asc {};;
10: len 1; hex 81; asc ;;
11: len 27; hex 75706c6f6164732f75736572732f31342f70657266696c2e6a7067; asc uploads/users/14/perfil.jpg;;
12: SQL NULL;
But in child table `oficina_pumagarage`.`services`, in index mechanic_id, there is a record:
PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 4; hex 8000000e; asc ;;
1: len 4; hex 80000149; asc I;;
------------
TRANSACTIONS
------------
Trx id counter 1151773
Purge done for trx's n:o < 1151773 undo n:o < 0 state: running
History list length 12
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283707605819896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605811560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605815728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605803224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605828232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605807392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283707605799056, 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
265344 OS file reads, 297686 OS file writes, 153370 OS fsyncs
11.07 reads/s, 16384 avg bytes/read, 22.97 writes/s, 10.87 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 8, seg size 10, 45 merges
merged operations:
insert 20, delete mark 35, 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)
19.55 hash searches/s, 45.72 non-hash searches/s
---
LOG
---
Log sequence number 727827040
Log flushed up to 727827020
Pages flushed up to 727814788
Last checkpoint at 727792246
0 pending log flushes, 0 pending chkp writes
82071 log i/o's done, 5.25 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 2336232
Buffer pool size 1003
Free buffers 735
Database pages 260
Old database pages 0
Modified db pages 23
Percent of dirty pages(LRU & free pages): 2.309
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1290, not young 948784
0.00 youngs/s, 0.00 non-youngs/s
Pages read 264408, created 4282, written 188208
11.07 reads/s, 0.20 creates/s, 15.70 writes/s
Buffer pool hit rate 958 / 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: 260, unzip_LRU len: 0
I/O sum[1363]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=5908, Main thread ID=6944, state: sleeping
Number of rows inserted 3702, updated 45800, deleted 1687, read 14892896
0.12 inserts/s, 3.62 updates/s, 0.12 deletes/s, 262.67 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 188844
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
