Sample output thereof:
=====================================
030128 0:09:00 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 353367, signal count 335552
Mutex spin waits 4128062, rounds 18059900, OS waits 124127
RW-shared spins 378798, OS waits 178138; RW-excl spins 49477, OS waits 14309
------------
TRANSACTIONS
------------
Trx id counter 0 16059415
Purge done for trx's n:o < 0 16057696 undo n:o < 0 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 16059414, not started, OS thread id 15722513
MySQL thread id 116767, query id 7088715 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16059405, not started, OS thread id 15799348
MySQL thread id 116763, query id 7088698 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16059255, not started, OS thread id 15875188
MySQL thread id 116753, query id 7088233 localhost.localdomain 127.0.0.1 wikiuser
SELECT old_timestamp,old_text FROM old WHERE (old_namespace=0 AND
old_title='Kosovo_War') ORDER BY old_timestamp DESC LIMIT 1
---TRANSACTION 1314686283 1314686469, not started, OS thread id 15865888
MySQL thread id 116751, query id 7088181 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('mctaggart')) ) AND (cur_nam
---TRANSACTION 0 16059190, not started, OS thread id 15874163
MySQL thread id 116744, query id 7088126 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('blue')) AND (MATCH (si_titl
---TRANSACTION 0 16059035, not started, OS thread id 15839358
MySQL thread id 116736, query id 7087903 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('hardcore')) AND (MATCH (si_
---TRANSACTION 0 16058880, not started, OS thread id 15867966
MySQL thread id 116708, query id 7087451 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('1953')) AND (MATCH (si_titl
---TRANSACTION 0 16057683, not started, OS thread id 15788044
MySQL thread id 116704, query id 7087345 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('zealand')) AND (MATCH (si_t
---TRANSACTION 1121881935 1121884187, not started, OS thread id 15181937
MySQL thread id 116677, query id 7086907 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('rasputin')) AND (MATCH (si_
---TRANSACTION 0 16058494, not started, OS thread id 15845508
MySQL thread id 116659, query id 7087057 localhost.localdomain 127.0.0.1 wikiuser
REPLACE INTO searchindex (si_page,si_title,si_text) VALUES (48013,'volunteer fire
department',' what is this this is an organizational page in whic
---TRANSACTION 0 16057754, not started, OS thread id 15862858
MySQL thread id 116640, query id 7085876 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_title) AGAINST ('konqueror')) ) AND (cur_nam
---TRANSACTION 0 16057748, not started, OS thread id 15851659
MySQL thread id 116637, query id 7085865 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_text) AGAINST ('music')) AND (cur_is_redirec
---TRANSACTION 0 16057618, not started, OS thread id 15850634
MySQL thread id 116618, query id 7085526 localhost.localdomain 127.0.0.1 wikiuser
SELECT
old_id,old_namespace,old_title,old_user,old_comment,old_user_text,old_timestamp,old_minor_edit
FROM old WHERE old_namespace=0 AND old_title='Ba
---TRANSACTION 0 16057175, not started, OS thread id 15858777
MySQL thread id 116591, query id 7084785 localhost.localdomain 127.0.0.1 wikiuser
INSERT INTO old
(old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit)
VALUES (0, 'Runnymede', '\'\'\'Runn
---TRANSACTION 0 16057679, not started, OS thread id 15841408
MySQL thread id 116588, query id 7086188 localhost.localdomain 127.0.0.1 wikiuser
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_text) AGAINST ('robert')) AND (MATCH (si_tex
---TRANSACTION 0 16057750, not started, OS thread id 15852684
MySQL thread id 116574, query id 7085864 localhost.localdomain 127.0.0.1 wikiuser
REPLACE INTO searchindex (si_page,si_title,si_text) VALUES (16760,'kosovo
war',' the kosovo war was a war between serbia serbian military officially
---TRANSACTION 0 16056404, not started, OS thread id 15828085
MySQL thread id 116527, query id 7083787 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16055875, not started, OS thread id 15812702
MySQL thread id 116470, query id 7082624 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16054972, not started, OS thread id 15823984
MySQL thread id 116411, query id 7080618 localhost.localdomain 127.0.0.1 wikiuser
INSERT INTO old
(old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit)
VALUES (0, 'Ethnic_cleansing', '\'\
---TRANSACTION 0 16054750, not started, OS thread id 15822959
MySQL thread id 116392, query id 7080180 localhost.localdomain 127.0.0.1 wikiuser
SELECT
old_id,old_namespace,old_title,old_user,old_comment,old_user_text,old_timestamp,old_minor_edit
FROM old WHERE old_namespace=4 AND old_title='Vo
---TRANSACTION 0 16054384, not started, OS thread id 15820908
MySQL thread id 116370, query id 7079522 localhost.localdomain 127.0.0.1 wikiuser
INSERT INTO old
(old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit)
VALUES (0, 'Ulrike_Meinhof', '\'\'\
---TRANSACTION 0 16053005, not started, OS thread id 15815781
MySQL thread id 116257, query id 7076554 localhost.localdomain 127.0.0.1 wikiuser
SELECT old_timestamp,old_text FROM old WHERE (old_namespace=0 AND
old_title='Creationism') ORDER BY old_timestamp DESC LIMIT 1
---TRANSACTION 0 16052373, not started, OS thread id 15805516
MySQL thread id 116198, query id 7075244 localhost.localdomain 127.0.0.1 wikiuser
INSERT INTO old
(old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit)
VALUES (0, 'List_of_people_with_vis
---TRANSACTION 0 16052286, not started, OS thread id 15802437
MySQL thread id 116189, query id 7074814 localhost.localdomain 127.0.0.1 wikiuser
INSERT INTO old
(old_namespace,old_title,old_text,old_comment,old_user,old_user_text,old_timestamp,old_minor_edit)
VALUES (5, 'Biography_standards', '
---TRANSACTION 0 16056999, not started, OS thread id 15774818
MySQL thread id 116077, query id 7084525 localhost.localdomain 127.0.0.1 wikiuser Sending
data
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_text) AGAINST ('blue')) AND (MATCH
(si_text)
---TRANSACTION 0 16050115, not started, OS thread id 15687722
MySQL thread id 115924, query id 7087813 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16049514, not started, OS thread id 15757390
MySQL thread id 115948, query id 7068168 localhost.localdomain 127.0.0.1 wikiuser Sorting
result
SELECT old_namespace,old_title,old_timestamp FROM old WHERE old_timestamp >
'20030114000257' AND old_user=188 ORDER BY old_timestamp DESC LIMIT 50
---TRANSACTION 0 15979894, not started, OS thread id 15156290
MySQL thread id 111207, query id 6938758 localhost.localdomain 127.0.0.1 wikiuser
---TRANSACTION 0 16059396, ACTIVE 0 sec, OS thread id 15848583 starting index read
, holds adaptive hash latch
MySQL thread id 116770, query id 7088684 localhost.localdomain 127.0.0.1 wikiuser Sending
data
SELECT cur_id,cur_namespace,cur_title
FROM cur,links
WHERE cur_id=l_to AND l_from='Chinese_astrology'
Trx read view will not see trx with id >= 0 16059397, sees < 0 16057874
---TRANSACTION 0 16059389, ACTIVE 1 sec, OS thread id 15837308 starting index read
, holds adaptive hash latch
MySQL thread id 116768, query id 7088528 localhost.localdomain 127.0.0.1 wikiuser Sending
data
SELECT cur_id,cur_namespace,cur_title
FROM cur,links
WHERE cur_id=l_to AND l_from='Bird'
Trx read view will not see trx with id >= 0 16059390, sees < 0 16057874
---TRANSACTION 0 16058921, ACTIVE 17 sec, OS thread id 15737885 fetching rows
MySQL thread id 116712, query id 7087505 localhost.localdomain 127.0.0.1 wikiuser Sending
data
SELECT cur_id,cur_namespace,cur_title
FROM cur,links
WHERE cur_id=l_to AND l_from='List_of_novelists'
Trx read view will not see trx with id >= 0 16058922, sees < 0 16057227
---TRANSACTION 0 16057874, ACTIVE 46 sec, OS thread id 15835258
MySQL thread id 116636, query id 7085857 localhost.localdomain 127.0.0.1 wikiuser Sending
data
SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page
AND ( (MATCH (si_text) AGAINST ('president')) AND (MATCH (si_
Trx read view will not see trx with id >= 0 16057875, sees < 0 16057227
--------
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: 1; buffer pool: 0
3574938 OS file reads, 351841 OS file writes, 157195 OS fsyncs
25.15 reads/s, 18208 avg bytes/read, 1.35 writes/s, 0.40 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 5, seg size 7,
14079 inserts, 14079 merged recs, 11639 merges
Hash table size 1106407, used cells 176839, node heap has 190 buffer(s)
1313.63 hash searches/s, 203.09 non-hash searches/s
---
LOG
---
Log sequence number 0 1024213263
Log flushed up to 0 1024213253
Last checkpoint at 0 1024193696
1 pending log writes, 0 pending chkp writes
135880 log i/o's done, 0.25 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 305558198; in additional pool allocated 1807360
Buffer pool size 16384
Free buffers 0
Database pages 16194
Modified db pages 83
Pending reads 3
Pending writes: LRU 0, flush list 0, single page 0
Pages read 6266151, created 2988, written 221076
27.85 reads/s, 0.00 creates/s, 1.00 writes/s
Buffer pool hit rate 994 / 1000
--------------
ROW OPERATIONS
--------------
4 queries inside InnoDB, 0 queries in queue; main thread: flushing log
Number of rows inserted 148901, updated 124331, deleted 140389, read 147336329
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1442.78 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
-- brion vibber (brion @
pobox.com)