=====================================
070322 14:47:52 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 22, signal count 22
Mutex spin waits 20, rounds 320, OS waits 4
RW-shared spins 36, OS waits 18; RW-excl spins 0, OS waits 0
------------------------
LATEST FOREIGN KEY ERROR
------------------------
070322 14:28:06 Transaction:
TRANSACTION 0 760777, ACTIVE 0 sec, OS thread id 2072 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
3 lock struct(s), heap size 320
MySQL thread id 138, query id 2479 localhost root update
insert into itn_two(name, skin) values ('John', 7)
Foreign key constraint fails for table `itnewbie/itn_two`:
,
CONSTRAINT `itn_two_ibfk_1` FOREIGN KEY (`name`) REFERENCES `itn_one` (`name`) ON DELETE CASCADE
Trying to add in child table, in index `PRIMARY` tuple:
DATA TUPLE: 4 fields;
0: len 4; hex 4a6f686e; asc John;; 1: len 6; hex 0000000b9bc9; asc ›É;; 2: len 7; hex 80000000e60110; asc æ ;; 3: len 4; hex 80000007; asc ;;
But in parent table `itnewbie/itn_one`, in index `PRIMARY`,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 4; compact format; info bits 0
0: len 6; hex 416e64726577; asc Andrew;; 1: len 6; hex 0000000b9bc6; asc ›Æ;; 2: len 7; hex 80000000e60110; asc æ ;; 3: len 19; hex 637970686f724069746e65776269652e636f6d; asc cyphor@itnewbie.com;;
------------
TRANSACTIONS
------------
Trx id counter 0 760799
Purge done for trx's n:o < 0 760790 undo n:o < 0 0
History list length 27
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, OS thread id 2072
MySQL thread id 168, query id 2794 localhost root
show engine innodb status
---TRANSACTION 0 760790, not started, OS thread id 4084
MySQL thread id 127, query id 2789 localhost root
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio (insert buffer thread)
I/O thread 1 state: wait Windows aio (log thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
162 OS file reads, 159 OS file writes, 98 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 for space 0: size 1, free list len 0, seg size 2, is empty
Ibuf for space 0: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 138401, used cells 11, node heap has 1 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 27181403
Log flushed up to 0 27181403
Last checkpoint at 0 27181403
0 pending log writes, 0 pending chkp writes
53 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 40755242; in additional pool allocated 442752
Buffer pool size 2048
Free buffers 1893
Database pages 154
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 152, created 2, written 92
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread id 1652, state: waiting for server activity
Number of rows inserted 6, updated 11, deleted 6, read 5725
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================