here's the report
*************************** 1. row ***************************
Status:
=====================================
040607 10:04:41 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 5 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 24, signal count 24
Mutex spin waits 4, rounds 41, OS waits 0
RW-shared spins 48, OS waits 24; RW-excl spins 1, OS waits 0
------------
TRANSACTIONS
------------
Trx id counter 0 22817
Purge done for trx's n:o < 0 22815 undo n:o < 0 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request
I/O thread 1 state: waiting for i/o request
I/O thread 2 state: waiting for i/o request
I/O thread 3 state: waiting for i/o request
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
78 OS file reads, 157 OS file writes, 94 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,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 1345367
Log flushed up to 0 1345367
Last checkpoint at 0 1345367
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 16796660; in additional pool allocated 673536
Buffer pool size 512
Free buffers 473
Database pages 38
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 38, created 0, written 103
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool activity since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue; main thread: waiting for server activity
Number of rows inserted 6, updated 0, deleted 5, read 1264
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
On 06 Jun 2004, at 16:37, Josh Trutwin wrote:
On Sun, 6 Jun 2004 15:48:37 +0200 Dimitri Bosiers <[EMAIL PROTECTED]> wrote:
<snip>
INSERT INTO pages(hidden,name,page_number,data,is_section_root,layout_id,group_ id) VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
this fails with a "ERROR 1216: Cannot add a child row: a foreign key
constraint fails"
Run:
SHOW INNODB STATUS;
And post the results in the "Latest Foreign Key Error" section.
Josh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
