Created
March 1, 2013 15:39
-
-
Save tremes/5065458 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
===================================== | |
130301 10:37:08 INNODB MONITOR OUTPUT | |
===================================== | |
Per second averages calculated from the last 55 seconds | |
---------- | |
SEMAPHORES | |
---------- | |
OS WAIT ARRAY INFO: reservation count 4206113, signal count 3090998 | |
Mutex spin waits 0, rounds 217200007, OS waits 3088564 | |
RW-shared spins 1130940, OS waits 413167; RW-excl spins 957973, OS waits 330596 | |
------------------------ | |
LATEST FOREIGN KEY ERROR | |
------------------------ | |
120626 13:52:14 Error in dropping of a foreign key constraint of table seam/booking, | |
in SQL command | |
alter table Booking drop foreign key FK6713A0396E4A3BD | |
Cannot find a constraint with the given id FK6713A0396E4A3BD. | |
------------------------ | |
LATEST DETECTED DEADLOCK | |
------------------------ | |
130301 4:49:04 | |
*** (1) TRANSACTION: | |
TRANSACTION 0 284505300, ACTIVE 0 sec, process no 3283, OS thread id 1673591104 starting index read | |
mysql tables in use 1, locked 1 | |
LOCK WAIT 2 lock struct(s), heap size 368 | |
MySQL thread id 32947, query id 661686769 qa06.mw.lab.eng.bos.redhat.com 10.16.89.196 seam Sending data | |
select next_val as id_val from hibernate_sequence for update | |
*** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 0 page no 1862 n bits 72 index `GEN_CLUST_INDEX` of table `seam/hibernate_sequence` trx id 0 284505300 lock_mode X locks rec but not gap waiting | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
0: len 6; hex 0000000003e2; asc ;; 1: len 6; hex 000010f534c6; asc 4 ;; 2: len 7; hex 00000007400650; asc @ P;; 3: len 8; hex 8000000000000308; asc ;; | |
*** (2) TRANSACTION: | |
TRANSACTION 0 284505299, ACTIVE 0 sec, process no 3283, OS thread id 1632590144 starting index read, thread declared inside InnoDB 500 | |
mysql tables in use 1, locked 1 | |
3 lock struct(s), heap size 368 | |
MySQL thread id 32953, query id 661686771 qa06.mw.lab.eng.bos.redhat.com 10.16.89.196 seam Updating | |
update hibernate_sequence set next_val= 777 where next_val=776 | |
*** (2) HOLDS THE LOCK(S): | |
RECORD LOCKS space id 0 page no 1862 n bits 72 index `GEN_CLUST_INDEX` of table `seam/hibernate_sequence` trx id 0 284505299 lock_mode X locks rec but not gap | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
0: len 6; hex 0000000003e2; asc ;; 1: len 6; hex 000010f534c6; asc 4 ;; 2: len 7; hex 00000007400650; asc @ P;; 3: len 8; hex 8000000000000308; asc ;; | |
*** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
RECORD LOCKS space id 0 page no 1862 n bits 72 index `GEN_CLUST_INDEX` of table `seam/hibernate_sequence` trx id 0 284505299 lock_mode X waiting | |
Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 | |
0: len 6; hex 0000000003e2; asc ;; 1: len 6; hex 000010f534c6; asc 4 ;; 2: len 7; hex 00000007400650; asc @ P;; 3: len 8; hex 8000000000000308; asc ;; | |
*** WE ROLL BACK TRANSACTION (2) | |
------------ | |
TRANSACTIONS | |
------------ | |
Trx id counter 0 284505394 | |
Purge done for trx's n:o < 0 284505392 undo n:o < 0 0 | |
History list length 16 | |
Total number of lock structs in row lock hash table 0 | |
LIST OF TRANSACTIONS FOR EACH SESSION: | |
---TRANSACTION 0 0, not started, process no 3283, OS thread id 1702345024 | |
MySQL thread id 32960, query id 661687032 localhost root | |
show innodb status | |
-------- | |
FILE I/O | |
-------- | |
I/O thread 0 state: waiting for i/o request (insert buffer thread) | |
I/O thread 1 state: waiting for i/o request (log thread) | |
I/O thread 2 state: waiting for i/o request (read thread) | |
I/O thread 3 state: waiting for i/o request (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 | |
1291259 OS file reads, 23838030 OS file writes, 21830479 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: size 1, free list len 3, seg size 5, | |
71061 inserts, 71061 merged recs, 13546 merges | |
Hash table size 17393, used cells 1036, node heap has 3 buffer(s) | |
0.00 hash searches/s, 0.00 non-hash searches/s | |
--- | |
LOG | |
--- | |
Log sequence number 14 1132002189 | |
Log flushed up to 14 1132002189 | |
Last checkpoint at 14 1132002189 | |
0 pending log writes, 0 pending chkp writes | |
21532358 log i/o's done, 0.00 log i/o's/second | |
---------------------- | |
BUFFER POOL AND MEMORY | |
---------------------- | |
Total memory allocated 20697426; in additional pool allocated 1013760 | |
Buffer pool size 512 | |
Free buffers 3 | |
Database pages 506 | |
Modified db pages 0 | |
Pending reads 0 | |
Pending writes: LRU 0, flush list 0, single page 0 | |
Pages read 1365647, created 149602, written 3384311 | |
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 process no. 3283, id 1175722304, state: waiting for server activity | |
Number of rows inserted 17321319, updated 10191963, deleted 10964614, read 254278279 | |
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s | |
---------------------------- | |
END OF INNODB MONITOR OUTPUT | |
============================ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment