Status
\n=====================================\n070524  8:54:37 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 18 seconds\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 58622, signal count 58121\nMutex spin waits 119704, rounds 1775281, OS waits 6891\nRW-shared spins 248615, OS waits 28079; RW-excl spins 45166, OS waits 23652\n------------\nTRANSACTIONS\n------------\nTrx id counter 0 19661699\nPurge done for trx's n:o < 0 19661674 undo n:o < 0 0\nHistory list length 9\nTotal number of lock structs in row lock hash table 0\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 0 0, not started, process no 25480, OS thread id 2966420400\nMySQL thread id 166991, query id 12273742 localhost root\nshow innodb status\n---TRANSACTION 0 19659689, not started, process no 25480, OS thread id 2966150064\nMySQL thread id 156323, query id 12240709 localhost root Waiting for release of readlock\nCREATE TABLE `forum_reports` (\n  `id` int(10) unsigned NOT NULL auto_increment,\n  `post_id` int(10) unsigned NOT NULL default '0',\n  `topic_id` int(10) unsigned NOT NULL default '0',\n  `forum_id` int(10) unsigned NOT NULL default '0',\n  `reported_by` int(10) unsigned NOT NULL default '0',\n  `created` int(10) unsigned NOT NULL default '0',\n  `message` text NOT NULL,\n  `zapped` int(10) unsigned default NULL,\n  `zapped_by` int(10) unsigned default NULL,\n  PRIMARY KEY  (`id`),\n  KEY `forum_reports_zapped_idx` (`zapped`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for i/o request (insert buffer thread)\nI/O thread 1 state: waiting for i/o request (log thread)\nI/O thread 2 state: waiting for i/o request (read thread)\nI/O thread 3 state: waiting for i/o request (write thread)\nPending normal aio reads: 0, aio writes: 0,\n ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\nPending flushes (fsync) log: 0; buffer pool: 0\n13054281 OS file reads, 2863431 OS file writes, 916970 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf for space 0: size 1, free list len 375, seg size 377, is empty\nIbuf for space 0: size 1, free list len 375, seg size 377,\n23058747 inserts, 23058747 merged recs, 1219908 merges\nHash table size 34679, used cells 192, node heap has 1 buffer(s)\n0.00 hash searches/s, 0.00 non-hash searches/s\n---\nLOG\n---\nLog sequence number 11 306378003\nLog flushed up to   11 306378003\nLast checkpoint at  11 306378003\n0 pending log writes, 0 pending chkp writes\n839664 log i/o's done, 0.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal memory allocated 20544574; in additional pool allocated 1048576\nBuffer pool size   512\nFree buffers       0\nDatabase pages     511\nModified db pages  0\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages read 19760355, created 299860, written 3150683\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n1 read views open inside InnoDB\nMain thread process no. 25480, id 2991123376, state: waiting for server activity\nNumber of rows inserted 35395947, updated 349439, deleted 81024, read 664256845\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n