===================================== 030201 1:27:20 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 42 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 23014, signal count 21935 Mutex spin waits 206169, rounds 803270, OS waits 4550 RW-shared spins 33781, OS waits 16506; RW-excl spins 1896, OS waits 946 ------------ TRANSACTIONS ------------ Trx id counter 0 143971568 Purge done for trx's n:o < 0 143970550 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 143971539, not started, OS thread id 1891344 MySQL thread id 4302, query id 7360862 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971477, not started, OS thread id 1892379 MySQL thread id 4301, query id 7360082 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971469, not started, OS thread id 1879106 MySQL thread id 4300, query id 7360093 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971387, not started, OS thread id 1898537 MySQL thread id 4299, query id 7359067 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971437, not started, OS thread id 1896482 MySQL thread id 4298, query id 7359381 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971425, not started, OS thread id 1895457 MySQL thread id 4282, query id 7359292 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971493, not started, OS thread id 1906750 MySQL thread id 4293, query id 7360149 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971397, not started, OS thread id 1900594 MySQL thread id 4287, query id 7359143 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971230, not started, OS thread id 1889320 MySQL thread id 4272, query id 7357977 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970088, not started, OS thread id 1873967 MySQL thread id 4273, query id 7349575 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970960, not started, OS thread id 1890350 MySQL thread id 4269, query id 7356117 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971286, not started, OS thread id 1859638 MySQL thread id 4228, query id 7358268 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971081, not started, OS thread id 1868864 MySQL thread id 4221, query id 7358028 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143935650, not started, OS thread id 1858613 MySQL thread id 4151, query id 7044028 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971231, not started, OS thread id 1852454 MySQL thread id 4106, query id 7357979 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970821, not started, OS thread id 1595481 MySQL thread id 4088, query id 7355333 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143969693, not started, OS thread id 1841197 MySQL thread id 4083, query id 7347693 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143968707, not started, OS thread id 1845299 MySQL thread id 4075, query id 7344631 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970362, not started, OS thread id 1624140 MySQL thread id 4065, query id 7352025 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970760, not started, OS thread id 1838112 MySQL thread id 4064, query id 7355093 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971495, not started, OS thread id 1807397 MySQL thread id 4047, query id 7360181 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971480, not started, OS thread id 1821753 MySQL thread id 4020, query id 7360110 localhost.localdomain 127.0.0.1 wikiuser FULLTEXT initialization SELECT cur_id,cur_namespace,cur_title,cur_text FROM cur,searchindex WHERE cur_id=si_page AND (MATCH (si_text) AGAINST ('Texas Poverty wage') AND (cur_ ---TRANSACTION 0 143971491, not started, OS thread id 1828931 MySQL thread id 4000, query id 7360119 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971241, not started, OS thread id 1796120 MySQL thread id 3965, query id 7358021 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143965377, not started, OS thread id 1644573 MySQL thread id 3953, query id 7313262 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971432, not started, OS thread id 1815601 MySQL thread id 3984, query id 7359342 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971260, not started, OS thread id 1800220 MySQL thread id 3969, query id 7358166 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971535, not started, OS thread id 1798170 MySQL thread id 3967, query id 7360794 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971567, not started, OS thread id 1797145 MySQL thread id 3966, query id 7361002 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971297, not started, OS thread id 1795095 MySQL thread id 3964, query id 7358336 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971548, not started, OS thread id 1794069 MySQL thread id 3963, query id 7360910 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971546, not started, OS thread id 1793043 MySQL thread id 3962, query id 7361003 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971564, not started, OS thread id 1792018 MySQL thread id 3961, query id 7360954 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970835, not started, OS thread id 1790993 MySQL thread id 3960, query id 7355388 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971510, not started, OS thread id 1789967 MySQL thread id 3959, query id 7360431 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970891, not started, OS thread id 1788941 MySQL thread id 3958, query id 7355742 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971497, not started, OS thread id 1787916 MySQL thread id 3957, query id 7360184 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971521, not started, OS thread id 1786891 MySQL thread id 3956, query id 7360635 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143969456, not started, OS thread id 1741846 MySQL thread id 3955, query id 7350002 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143969447, not started, OS thread id 1785866 MySQL thread id 3954, query id 7360352 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143941735, not started, OS thread id 1765396 MySQL thread id 3952, query id 7109506 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970413, not started, OS thread id 1664039 MySQL thread id 3951, query id 7352502 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971509, not started, OS thread id 1730574 MySQL thread id 3950, query id 7360985 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143970700, not started, OS thread id 1776700 MySQL thread id 3949, query id 7360426 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143971255, not started, OS thread id 1777727 MySQL thread id 3948, query id 7358108 localhost.localdomain 127.0.0.1 wikiuser ---TRANSACTION 0 143938343, not started, OS thread id 1768490 MySQL thread id 3947, query id 7069280 localhost.localdomain 127.0.0.1 wikiuser -------- 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: 0; buffer pool: 1 251945 OS file reads, 55745 OS file writes, 11552 OS fsyncs 3.76 reads/s, 17524 avg bytes/read, 5.69 writes/s, 0.76 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 5, seg size 7, 1497 inserts, 1497 merged recs, 1428 merges Hash table size 1593833, used cells 704903, node heap has 914 buffer(s) 624.70 hash searches/s, 309.04 non-hash searches/s --- LOG --- Log sequence number 0 1324192703 Log flushed up to 0 1324192703 Last checkpoint at 0 1324161146 0 pending log writes, 1 pending chkp writes 7212 log i/o's done, 0.43 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 448995006; in additional pool allocated 1798912 Buffer pool size 24576 Free buffers 0 Database pages 23662 Modified db pages 72 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 411420, created 392, written 49000 4.05 reads/s, 0.07 creates/s, 5.45 writes/s Buffer pool hit rate 999 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue; main thread: making checkpoint Number of rows inserted 26902, updated 4719, deleted 24772, read 22899978 2.40 inserts/s, 0.17 updates/s, 2.40 deletes/s, 648.72 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================