=====================================
120215 17:33:34 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 221691, signal count 185494
Mutex spin waits 0, rounds 14232546, OS waits 131489
RW-shared spins 62666, OS waits 28090; RW-excl spins 67050, OS waits 39498
------------------------
LATEST DETECTED DEADLOCK
------------------------
120214 22:18:19
*** (1) TRANSACTION:
TRANSACTION 0 1144322, ACTIVE 2 sec, process no 27586, OS thread id 1195571520 inserting
mysql tables in use 1, locked 1
LOCK WAIT 45 lock struct(s), heap size 6752, undo log entries 383
MySQL thread id 1010049, query id 185684478 localhost orgf update
INSERT INTO `xf_post` (`post_id`, `thread_id`, `user_id`, `username`, `post_date`, `message`, `attach_count`, `message_state`, `position`, `ip_id`, `likes`, `like_users`, `warning_id`, `warning_message`) VALUES ('3963150', '375854', '52690', 'Gummibear1986', '1280610763', '[QUOTE=LORDPSK;3961616]Sounds like the auto adjuster on the clutch cable to me[/QUOTE]\r\n\r\nI have a similar problem. If it is the adjuster how easy is this to fix?', '0', 'visible', '3', '0', '0', 'a:0:{}', '0', '')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 438 n bits 112 index `PRIMARY` of table `orgf_forums/xf_post` trx id 0 1144322 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;
*** (2) TRANSACTION:
TRANSACTION 0 1144321, ACTIVE 7 sec, process no 27586, OS thread id 1213143360 setting auto-inc lock
mysql tables in use 1, locked 1
226 lock struct(s), heap size 30704, undo log entries 3972
MySQL thread id 1010051, query id 185684482 localhost orgf update
INSERT INTO `xf_post` (`post_id`, `thread_id`, `user_id`, `username`, `post_date`, `message`, `attach_count`, `message_state`, `position`, `ip_id`, `likes`, `like_users`, `warning_id`, `warning_message`) VALUES ('3963016', '376022', '57935', 'Pete27011', '1280606602', 'I would start with the spark plug electrode gaps and work backwards.check everything for damage or wear and replace, a missfire is definately something electrical . Ht leads often look ok and are actually damaged inside. with ignition parts i always buy the best,cheap inferior parts like 3 quid for a moto factors rotor arm never pays off.', '0', 'deleted', '1', '0', '0', 'a:0:{}', '0', '')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 438 n bits 112 index `PRIMARY` of table `orgf_forums/xf_post` trx id 0 1144321 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `orgf_forums/xf_post` trx id 0 1144321 lock mode AUTO-INC waiting
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 0 1439824
Purge done for trx's n:eek: < 0 1439824 undo n:eek: < 0 0
History list length 2
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 27586, OS thread id 1220598080
MySQL thread id 2297507, query id 234454497 localhost 127.0.0.1 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
44919 OS file reads, 3626227 OS file writes, 512535 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 5, seg size 7,
7343 inserts, 7343 merged recs, 1801 merges
Hash table size 6424837, used cells 5326439, node heap has 16733 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 8 863900298
Log flushed up to 8 863900298
Last checkpoint at 8 863900298
0 pending log writes, 0 pending chkp writes
378885 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 3627964234; in additional pool allocated 1048576
Buffer pool size 198144
Free buffers 1
Database pages 181410
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 60522, created 216708, written 5142094
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. 27586, id 1175603520, state: waiting for server activity
Number of rows inserted 19608649, updated 10966681, deleted 79953, read 786624100
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
