MySQL Forums
Forum List  »  InnoDB

Re: MySQL lock wait timeout exceeded need help badly
Posted by: Jay Izzo
Date: March 18, 2006 09:02PM

|
=====================================
060318 22:00:41 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 23 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 56, signal count 56
Mutex spin waits 49, rounds 627, OS waits 11
RW-shared spins 88, OS waits 44; RW-excl spins 1, OS waits 1
------------
TRANSACTIONS
------------
Trx id counter 0 56791
Purge done for trx's n:o < 0 56790 undo n:o < 0 0
History list length 9
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 2040
MySQL thread id 28, query id 1393 localhost 127.0.0.1 root
SHOW INNODB STATUS
---TRANSACTION 0 56790, not started, OS thread id 2716
MySQL thread id 27, query id 1392 localhost 127.0.0.1 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
32 OS file reads, 633 OS file writes, 295 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 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 283835
Log flushed up to 0 283835
Last checkpoint at 0 283835
0 pending log writes, 0 pending chkp writes
154 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 14280458; in additional pool allocated 192128
Buffer pool size 512
Free buffers 478
Database pages 33
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 22, created 11, written 427
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
Main thread id 1864, state: waiting for server activity
Number of rows inserted 16, updated 0, deleted 4, read 167
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL lock wait timeout exceeded need help badly
3871
March 18, 2006 09:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.