Status
\n=====================================\n070514 16:49:27 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 27 seconds\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 5, signal count 5\nMutex spin waits 5, rounds 100, OS waits 0\nRW-shared spins 6, OS waits 3; RW-excl spins 3, OS waits 2\n------------\nTRANSACTIONS\n------------\nTrx id counter 0 13717817\nPurge done for trx's n:o < 0 13717790 undo n:o < 0 0\nHistory list length 14\nTotal number of lock structs in row lock hash table 2\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 0 0, not started, process no 31897, OS thread id 1141754800\nMySQL thread id 29, query id 312 localhost root\nshow innodb status\n---TRANSACTION 0 13717816, ACTIVE 6 sec, process no 31897, OS thread id 1116265392 starting index read\nmysql tables in use 1, locked 1\nLOCK WAIT 2 lock struct(s), heap size 320\nMySQL thread id 27, query id 311 localhost muir Updating\nUPDATE charm2object \t\t\tSET loadgroup = id\n------- TRX HAS BEEN WAITING 6 SEC FOR THIS LOCK TO BE GRANTED:\nRECORD LOCKS space id 0 page no 45 n bits 80 index `PRIMARY` of table `rectangle/charm2object` trx id 0 13717816 lock_mode X waiting\nRecord lock, heap no 2 PHYSICAL RECORD: n_fields 13; compact format; info bits 0\n 0: len 8; hex 8000000000000001; asc         ;; 1: len 6; hex 000000d15134; asc     Q4;; 2: len 7; hex 00000000c720d1; asc        ;; 3: len 8; hex 8000000000000001; asc         ;; 4: len 4; hex 48415348; asc HASH;; 5: len 1; hex 48; asc H;; 6: len 1; hex 56; asc V;; 7: len 1; hex 30; asc 0;; 8: len 1; hex 30; asc 0;; 9: len 4; hex 800003ed; asc     ;; 10: len 4; hex 80000001; asc     ;; 11: len 2; hex 8002; asc   ;; 12: len 4; hex 80002710; asc   ' ;;\n\n------------------\n---TRANSACTION 0 13717815, ACTIVE 6 sec, process no 31897, OS thread id 1116130224\n2 lock struct(s), heap size 320\nMySQL thread id 25, query id 306 localhost muir\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\n144 OS file reads, 31 OS file writes, 26 OS fsyncs\n5.33 reads/s, 31886 avg bytes/read, 1.15 writes/s, 0.96 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf for space 0: size 1, free list len 5, seg size 7, is empty\nIbuf for space 0: size 1, free list len 5, seg size 7,\n0 inserts, 0 merged recs, 0 merges\nHash table size 34679, used cells 0, node heap has 1 buffer(s)\n0.00 hash searches/s, 27.74 non-hash searches/s\n---\nLOG\n---\nLog sequence number 10 2404494816\nLog flushed up to   10 2404494816\nLast checkpoint at  10 2404474255\n0 pending log writes, 0 pending chkp writes\n28 log i/o's done, 1.04 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal memory allocated 18347710; in additional pool allocated 1048192\nBuffer pool size   512\nFree buffers       364\nDatabase pages     147\nModified db pages  17\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages read 146, created 1, written 22\n5.41 reads/s, 0.04 creates/s, 0.81 writes/s\nBuffer pool hit rate 995 / 1000\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n1 read views open inside InnoDB\nMain thread process no. 31897, id 1124703152, state: sleeping\nNumber of rows inserted 44, updated 4, deleted 11, read 22808\n1.63 inserts/s, 0.15 updates/s, 0.41 deletes/s, 844.71 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n