最近mysql总是出这种怪事，好多提示看不懂！

imxae

=====================================
071114 13:32:58 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 23 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4820, signal count 4512
--Thread 229391 has waited at btr0cur.c line 424 for 3.00 seconds the semaphore:
S-lock on RW-latch at 0xb5435748 created in file buf0buf.c line 497
a writer (thread id 442396) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
--Thread 344086 has waited at btr0cur.c line 3759 for 218.00 seconds the semaphore:
S-lock on RW-latch at 0xb543f2c4 created in file buf0buf.c line 497
a writer (thread id 344086) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
--Thread 278546 has waited at btr0cur.c line 424 for 218.00 seconds the semaphore:
S-lock on RW-latch at 0xb542b770 created in file buf0buf.c line 497
a writer (thread id 278546) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file ./../include/btr0btr.ic line 28
Last time write locked in file buf0buf.c line 1735
--Thread 376856 has waited at btr0cur.c line 424 for 218.00 seconds the semaphore:
S-lock on RW-latch at 0xb542aeb8 created in file buf0buf.c line 497
a writer (thread id 376856) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
--Thread 327701 has waited at btr0cur.c line 424 for 3.00 seconds the semaphore:
S-lock on RW-latch at 0xb542b770 created in file buf0buf.c line 497
a writer (thread id 278546) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file ./../include/btr0btr.ic line 28
Last time write locked in file buf0buf.c line 1735
--Thread 294931 has waited at btr0cur.c line 3759 for 191.00 seconds the semaphore:
S-lock on RW-latch at 0xb543f2c4 created in file buf0buf.c line 497
a writer (thread id 344086) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
Mutex spin waits 0, rounds 69070, OS waits 125
RW-shared spins 30062, OS waits 4637; RW-excl spins 189, OS waits 58
InnoDB: ###### Diagnostic info printed to the standard error stream
------------
TRANSACTIONS
------------
Trx id counter 0 31310638
Purge done for trx's n < 0 31310578 undo n < 0 0
History list length 5
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 31310626, not started, process no 20875, OS thread id 180236
mysql tables in use 1, locked 1
MySQL thread id 2, query id 416323 init
UPDATE album_images SET
      browse = browse + 1
                        WHERE id = 31415
---TRANSACTION 0 31310637, ACTIVE 45 sec, process no 27871, OS thread id 393241 estimating records in index range
mysql tables in use 1, locked 0
MySQL thread id 44782, query id 416324 localhost root statistics
SELECT * FROM users WHERE username = '891924401er'
Trx read view will not see trx with id >= 0 31310638, sees < 0 31310572
---TRANSACTION 0 31310635, ACTIVE 292 sec, process no 20876, OS thread id 196621 preparing
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 44789, query id 415794 localhost root update
INSERT INTO forum_posts SET
                        forum_id = 6,
                        topic_id = 47079,
                        parent_id = 468835,
                  username = 'horre007',
                        ip = '123.52.31.141',
                  subject = '我喜欢。我正想买这个模型,是多少比例的?你知道郑州那家模型店有的卖.请告诉我.谢谢',
                        append = '',
                  content  = '我喜欢。我正想买这个模型,是多少比例的?\r\n你知道郑州那家模型店有的卖.请告诉我.\r\n谢谢\r\n',
                  postdatetime = '2007-11-14 13:27:41'
---TRANSACTION 0 31310634, ACTIVE 296 sec, process no 27870, OS thread id 376856 fetching rows, thread declared inside InnoDB 225
mysql tables in use 1, locked 0
MySQL thread id 44787, query id 415796 localhost root Sending data
SELECT COUNT(*) FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 7 AND forum_topics.in_recycle = 0
Trx read view will not see trx with id >= 0 31310635, sees < 0 31310572
---TRANSACTION 0 31310632, ACTIVE 296 sec, process no 21516, OS thread id 294931 fetching rows, thread declared inside InnoDB 466
mysql tables in use 1, locked 0
MySQL thread id 44764, query id 416320 localhost root Sending data
SELECT * FROM article_topics WHERE (category_id = 80 OR category_id = 81 OR category_id = 82 OR category_id = 83) ORDER BY id LIMIT 0, 12
Trx read view will not see trx with id >= 0 31310633, sees < 0 31310572
---TRANSACTION 0 31310630, ACTIVE 301 sec, process no 25491, OS thread id 344086 fetching rows, thread declared inside InnoDB 466
mysql tables in use 1, locked 0
MySQL thread id 44770, query id 416058 localhost root Sending data
SELECT * FROM article_topics WHERE (category_id = 80 OR category_id = 81 OR category_id = 82 OR category_id = 83) ORDER BY id LIMIT 0, 12
Trx read view will not see trx with id >= 0 31310631, sees < 0 31310572
---TRANSACTION 0 31310629, ACTIVE 306 sec, process no 20907, OS thread id 262161 waiting in InnoDB queue
mysql tables in use 3, locked 0
MySQL thread id 44773, query id 415793 localhost root Sorting result
SELECT forum_topics.* FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 4 AND forum_topics.in_recycle = 0 ORDER BY top DESC, lastdatetime DESC LIMIT 0, 30
Trx read view will not see trx with id >= 0 31310630, sees < 0 31310502
---TRANSACTION 0 31310628, ACTIVE 306 sec, process no 27872, OS thread id 409626 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 44785, query id 415795 localhost root Sending data
SELECT * FROM users WHERE username = 'franklin610'
Trx read view will not see trx with id >= 0 31310629, sees < 0 31310502
---TRANSACTION 0 31310627, ACTIVE 307 sec, process no 28701, OS thread id 475166 waiting in InnoDB queue
mysql tables in use 3, locked 0
MySQL thread id 44765, query id 415792 localhost root Sorting result
SELECT forum_topics.* FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 4 AND forum_topics.in_recycle = 0 ORDER BY top DESC, lastdatetime DESC LIMIT 0, 30
Trx read view will not see trx with id >= 0 31310628, sees < 0 31310502
---TRANSACTION 0 31310624, ACTIVE 335 sec, process no 20885, OS thread id 229391 fetching rows, thread declared inside InnoDB 222
mysql tables in use 1, locked 0
MySQL thread id 44784, query id 415789 localhost root Sending data
SELECT COUNT(*) FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 5 AND forum_topics.in_recycle = 0
Trx read view will not see trx with id >= 0 31310625, sees < 0 31310502
---TRANSACTION 0 31310623, ACTIVE 337 sec, process no 27874, OS thread id 442396 fetching rows, thread declared inside InnoDB 222
mysql tables in use 1, locked 0
MySQL thread id 44783, query id 415781 localhost root Sending data
SELECT COUNT(*) FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 5 AND forum_topics.in_recycle = 0
Trx read view will not see trx with id >= 0 31310624, sees < 0 31310502
---TRANSACTION 0 31310599, ACTIVE 377 sec, process no 20891, OS thread id 245776 waiting in InnoDB queue
mysql tables in use 3, locked 0
MySQL thread id 44774, query id 415727 localhost root Sorting result
SELECT forum_topics.* FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 2 AND forum_topics.in_recycle = 0 ORDER BY top DESC, lastdatetime DESC LIMIT 0, 30
Trx read view will not see trx with id >= 0 31310600, sees < 0 31310502
---TRANSACTION 0 31310584, ACTIVE 384 sec, process no 22777, OS thread id 327701 starting index read, thread declared inside InnoDB 86
mysql tables in use 3, locked 0
, holds adaptive hash latch
MySQL thread id 44769, query id 415707 localhost root Sending data
SELECT COUNT(*) FROM forum_topics WHERE forum_topics.top IN (0, 1) AND forum_topics.forum_id = 1 AND forum_topics.in_recycle = 0
Trx read view will not see trx with id >= 0 31310585, sees < 0 31310502
---TRANSACTION 0 31310572, ACTIVE 387 sec, process no 21367, OS thread id 278546 starting index read, thread declared inside InnoDB 86
mysql tables in use 3, locked 0
MySQL thread id 44778, query id 415684 localhost root Sorting result
SELECT * FROM forum_topics WHERE forum_id = 1 AND in_recycle = 0 ORDER BY lastdatetime DESC LIMIT 0, 6
Trx read view will not see trx with id >= 0 31310573, sees < 0 31310502
--------
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: complete io for buf page (read thread) ev set
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 51, 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
475243 OS file reads, 27239 OS file writes, 15681 OS fsyncs
0.02 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.02 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 281, seg size 283,
541 inserts, 540 merged recs, 536 merges
Hash table size 34679, used cells 8894, node heap has 11 buffer(s)
6.91 hash searches/s, 0.65 non-hash searches/s
---
LOG
---
Log sequence number 0 2125049944
Log flushed up to   0 2125049930
Last checkpoint at  0 2125049868
0 pending log writes, 0 pending chkp writes
10495 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 20083860; in additional pool allocated 1048576
Buffer pool size   512
Free buffers       0
Database pages     501
Modified db pages  3
Pending reads 51
Pending writes: LRU 0, flush list 0, single page 0
Pages read 984822, created 184, written 17179
0.06 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 994 / 1000
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 3 queries in queue
13 read views open inside InnoDB
Main thread process no. 20872, id 131081, state: purging
Number of rows inserted 128, updated 10671, deleted 0, read 290633528
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 23.61 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: Warning: a long semaphore wait:
--Thread 344086 has waited at btr0cur.c line 3759 for 242.00 seconds the semaphore:
S-lock on RW-latch at 0xb543f2c4 created in file buf0buf.c line 497
a writer (thread id 344086) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
InnoDB: Warning: a long semaphore wait:
--Thread 278546 has waited at btr0cur.c line 424 for 334.00 seconds the semaphore:
S-lock on RW-latch at 0xb542b770 created in file buf0buf.c line 497
a writer (thread id 278546) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file ./../include/btr0btr.ic line 28
Last time write locked in file buf0buf.c line 1735
InnoDB: Warning: a long semaphore wait:
--Thread 376856 has waited at btr0cur.c line 424 for 334.00 seconds the semaphore:
S-lock on RW-latch at 0xb542aeb8 created in file buf0buf.c line 497
a writer (thread id 376856) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
InnoDB: Warning: a long semaphore wait:
--Thread 294931 has waited at btr0cur.c line 3759 for 307.00 seconds the semaphore:
S-lock on RW-latch at 0xb543f2c4 created in file buf0buf.c line 497
a writer (thread id 344086) has reserved it in mode  exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 765
Last time write locked in file buf0buf.c line 1735
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0