Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Storage engines

InnoDB Documentation

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

[ Variables | Buffer Pool | InnoDB Status ]


=====================================
2025-09-18 08:27:29 0x31a4 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 55 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 71568 srv_active, 0 srv_shutdown, 1977150 srv_idle
srv_master_thread log flush and writes: 2048718
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1715587
OS WAIT ARRAY INFO: signal count 1304325
RW-shared spins 1321652, rounds 31713671, OS waits 874352
RW-excl spins 669735, rounds 1849449, OS waits 26311
RW-sx spins 22718, rounds 194520, OS waits 3439
Spin rounds per wait: 24.00 RW-shared, 2.76 RW-excl, 8.56 RW-sx
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2025-09-10 10:51:09 0x1e3c Transaction:
TRANSACTION 31554573, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1
MySQL thread id 237030, OS thread handle 7740, query id 8533203 CLOUD-PJCQRPUIU 45.58.43.18 freeluma Update
INSERT INTO ticket_messages
                (ticket_id, direction, message_type, author_name, author_email, body_text, body_html, created_at)
             VALUES
                ('3083', 'inbound', 'email', '', 'staciturner41@yahoo.com', 'Good afternoon, \nJustin curious if my order has shipped yet? \n\nThank you \nStaci Turner \nSent from my iPhone', '<html><head><meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\"></head><body dir=\"auto\">Good afternoon,&nbsp;<div>Justin curious if my order has shipped yet?&nbsp;</div><div><br></div><div>Thank you&nbsp;</div><div>Staci 
Foreign key constraint fails for table `customersupport`.`ticket_messages`:
,
  CONSTRAINT `ticket_messages_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE in parent table, in index idx_tm_ticket tuple:
DATA TUPLE: 3 fields;
 0: len 8; hex 0000000000000c0b; asc         ;;
 1: len 4; hex 68c1ba8d; asc h   ;;
 2: len 8; hex 0000000000009a82; asc         ;;

But in parent table `customersupport`.`tickets`, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 23; compact format; info bits 0
 0: len 8; hex 00000000000024ca; asc       $ ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 8; hex 0000000000000002; asc         ;;
 4: len 30; hex 7777772e656c6567616e74657465726e6974792e636f6d2053454f205072; asc www.eleganteternity.com SEO Pr; (total 48 bytes);
 5: len 0; hex ; asc ;;
 6: len 17; hex 696e666f406f637461626c697a2e6e6574; asc info@octabliz.net;;
 7: SQL NULL;
 8: len 1; hex 03; asc  ;;
 9: len 1; hex 02; asc  ;;
 10: SQL NULL;
 11: SQL NULL;
 12: SQL NULL;
 13: SQL NULL;
 14: SQL NULL;
 15: SQL NULL;
 16: len 1; hex 01; asc  ;;
 17: SQL NULL;
 18: len 4; hex 68ad8ccd; asc h   ;;
 19: len 4; hex 68ada017; asc h   ;;
 20: SQL NULL;
 21: len 15; hex 47656e6572616c20496e7175697279; asc General Inquiry;;
 22: len 30; hex 43555252454e54205449434b455420e280942041206d61726b6574696e67; asc CURRENT TICKET     A marketing; (total 272 bytes);

------------
TRANSACTIONS
------------
Trx id counter 31597667
Purge done for trx's n:o < 31597667 undo n:o < 0 state: running but idle
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 283676628521176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 283676628517008, 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
82943369 OS file reads, 2455720 OS file writes, 1035826 OS fsyncs
31.47 reads/s, 16384 avg bytes/read, 2.71 writes/s, 2.15 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 390, seg size 392, 6254 merges
merged operations:
 insert 30211, delete mark 456322, delete 13297
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)
1.89 hash searches/s, 3.95 non-hash searches/s
---
LOG
---
Log sequence number 4301779101
Log flushed up to   4301779081
Pages flushed up to 4301777776
Last checkpoint at  4301777767
0 pending log flushes, 0 pending chkp writes
635865 log i/o's done, 1.36 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 33554432
Dictionary memory allocated 440704
Buffer pool size   1003
Free buffers       736
Database pages     259
Old database pages 0
Modified db pages  3
Percent of dirty pages(LRU & free pages): 0.301
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 16599712, not young 673221385
0.00 youngs/s, 66.53 non-youngs/s
Pages read 82943209, created 25319, written 1663324
31.47 reads/s, 0.02 creates/s, 1.07 writes/s
Buffer pool hit rate 779 / 1000, young-making rate 0 / 1000 not 465 / 1000
Pages read ahead 26.74/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 259, unzip_LRU len: 0
I/O sum[362]:cur[3], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=15956, Main thread ID=15356, state: sleeping
Number of rows inserted 223926, updated 99967, deleted 202038, read 11320769084
0.00 inserts/s, 0.25 updates/s, 0.00 deletes/s, 666.30 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 163301
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================