*************************** 1. row *************************** Status: ===================================== 110416 10:44:37 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ---------- BACKGROUND THREAD ---------- fsync callers: 1517 buffer pool, 0 other, 4 checkpoint, 365 log aio, 40509 log sync, 0 archive ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 63340, signal count 1334829 Mutex spin waits 121706552, rounds 110490808, OS waits 7081 RW-shared spins 905900, OS waits 46944; RW-excl spins 21092, OS waits 7907 Spin rounds per wait: 0.91 mutex, 2.44 RW-shared, 88.59 RW-excl -------- 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: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (read thread) I/O thread 7 state: waiting for i/o request (read thread) I/O thread 8 state: waiting for i/o request (read thread) I/O thread 9 state: waiting for i/o request (read thread) I/O thread 10 state: waiting for i/o request (write thread) I/O thread 11 state: waiting for i/o request (write thread) I/O thread 12 state: waiting for i/o request (write thread) I/O thread 13 state: waiting for i/o request (write thread) I/O thread 14 state: waiting for i/o request (write thread) I/O thread 15 state: waiting for i/o request (write thread) I/O thread 16 state: waiting for i/o request (write thread) I/O thread 17 state: waiting for i/o request (write thread) 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: 0 96588 OS file reads, 72037 OS file writes, 42394 OS fsyncs 10.80 reads/s, 16384 avg bytes/read, 48.40 writes/s, 47.35 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 594 inserts, 594 merged recs, 510 merges Hash table size 17700857, used cells 5040611, node heap has 8750 buffer(s) 336476.18 hash searches/s, 25892.66 non-hash searches/s --- LOG --- Log sequence number 124 309088674 Log flushed up to 124 309088674 Last checkpoint at 124 308239039 Max checkpoint age 167270769 Modified age 849635 Checkpoint age 849635 0 pending log writes, 0 pending chkp writes 40894 log i/o's done, 47.15 log i/o's/second, 40509 syncs, 364 checkpoints log sync callers: 35178 buffer pool, background 5137 sync and 0 async, 15 internal, checkpoint 364 sync and 0 async, 0 archive, commit 38730 sync and 0 async log sync syncers: 275 buffer pool, background 1514 sync and 0 async, 0 internal, checkpoint 1 sync and 0 async, 0 archive, commit 38719 sync and 0 async ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 0; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 284971064 (141606856 + 143364208) Page hash 8851256 Dictionary cache 107907864 (106207080 + 1700784) File system 83520 (82672 + 848) Lock system 21290312 (21250568 + 39744) Recovery system 0 (0 + 0) Threads 408056 (406936 + 1120) innodb_io_pattern 0 (0 + 0) Buffer pool size 524288 Buffer pool size, bytes 8589934592 Free buffers 400996 Database pages 114542 Modified db pages 513 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 114065, created 477, written 35178 10.75 reads/s, 0.15 creates/s, 2.05 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 6836, id 1316325696, state: sleeping Number of rows inserted 29546, updated 6515, deleted 24383, read 4736208291 7.10 inserts/s, 11.60 updates/s, 4.60 deletes/s, 721883.81 reads/s ------------ TRANSACTIONS ------------ Trx id counter 1 3455575642 Purge done for trx's n:o < 1 3455573829 undo n:o < 0 0 History list length 20 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1336826176 MySQL thread id 34436, query id 6043486 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1342150976 MySQL thread id 34447, query id 6043449 localhost root SHOW INNODB STATUS ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1339488576 MySQL thread id 34434, query id 6043436 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1105615168 MySQL thread id 34442, query id 6043400 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1326442816 MySQL thread id 34429, query id 6043385 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1342683456 MySQL thread id 34439, query id 6043375 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1338423616 MySQL thread id 34441, query id 6043369 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1320851776 MySQL thread id 34433, query id 6043335 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1334430016 MySQL thread id 34431, query id 6043332 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1342417216 MySQL thread id 34435, query id 6043313 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1324845376 MySQL thread id 34432, query id 6043272 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1341618496 MySQL thread id 34438, query id 6043120 100.100.100.101 dbuser ---TRANSACTION 1 3455575634, not started, process no 6836, OS thread id 1335761216 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34437, query id 6043605 100.100.100.101 dbuser Sending data SELECT dst FROM url_alias WHERE src = 'node/986653' AND language IN('en', '') ORDER BY language DESC, pid DESC ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1318721856 MySQL thread id 34415, query id 6043042 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1322449216 MySQL thread id 34425, query id 6042990 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1328040256 MySQL thread id 34416, query id 6043133 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1325111616 MySQL thread id 34422, query id 6042937 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1103382848 MySQL thread id 34409, query id 6042345 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1341352256 MySQL thread id 34411, query id 6042327 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1318189376 MySQL thread id 34410, query id 6042250 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1333098816 MySQL thread id 34388, query id 6041471 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1335494976 MySQL thread id 34403, query id 6041176 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1334696256 MySQL thread id 34404, query id 6041032 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1323780416 MySQL thread id 34397, query id 6041010 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1317923136 MySQL thread id 34392, query id 6040987 100.100.100.100 dbuser ---TRANSACTION 1 3455575541, not started, process no 6836, OS thread id 1324579136 MySQL thread id 34402, query id 6042959 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1328306496 MySQL thread id 34396, query id 6040455 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1329371456 MySQL thread id 34380, query id 6040442 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1344813376 MySQL thread id 34389, query id 6040333 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1317124416 MySQL thread id 34387, query id 6040288 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1317390656 MySQL thread id 34386, query id 6040280 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1330968896 MySQL thread id 34384, query id 6040239 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1333365056 MySQL thread id 34383, query id 6040195 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1343748416 MySQL thread id 34379, query id 6040057 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1344280896 MySQL thread id 34381, query id 6040015 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1344014656 MySQL thread id 34378, query id 6039954 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1332033856 MySQL thread id 34372, query id 6039918 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1343482176 MySQL thread id 34376, query id 6039885 100.100.100.100 dbuser ---TRANSACTION 1 3455575551, not started, process no 6836, OS thread id 1103649088 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34370, query id 6043603 100.100.100.101 dbuser statistics SELECT * FROM users u WHERE uid = 6 ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1345079616 MySQL thread id 34390, query id 6039784 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1316858176 MySQL thread id 34373, query id 6039578 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1100183872 MySQL thread id 34361, query id 6039228 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1325644096 MySQL thread id 34355, query id 6039149 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1321384256 MySQL thread id 34360, query id 6039066 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1099385152 MySQL thread id 34357, query id 6039002 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1342949696 MySQL thread id 34352, query id 6038724 100.100.100.100 dbuser ---TRANSACTION 1 3455575613, not started, process no 6836, OS thread id 1328838976 MySQL thread id 34344, query id 6043246 100.100.100.101 dbuser ---TRANSACTION 1 3455575631, not started, process no 6836, OS thread id 1341086016 MySQL thread id 34341, query id 6043387 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1102313792 MySQL thread id 34254, query id 6043582 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1316591936 MySQL thread id 34314, query id 6035155 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1101515072 MySQL thread id 34294, query id 6034622 100.100.100.100 dbuser ---TRANSACTION 1 3455575073, not started, process no 6836, OS thread id 1101248832 MySQL thread id 34300, query id 6043553 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1329637696 MySQL thread id 34256, query id 6032675 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1324312896 MySQL thread id 34255, query id 6032611 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1319254336 MySQL thread id 34257, query id 6032528 100.100.100.100 dbuser ---TRANSACTION 1 3455575641, not started, process no 6836, OS thread id 1319786816 mysql tables in use 1, locked 0 MySQL thread id 34249, query id 6043602 100.100.100.100 dbuser SELECT dst FROM url_alias WHERE src = 'taxonomy/term/15171' AND language IN('en', '') ORDER BY language DESC, pid DESC ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1100450112 MySQL thread id 34261, query id 6032188 100.100.100.101 dbuser ---TRANSACTION 1 3455575171, not started, process no 6836, OS thread id 1331235136 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34243, query id 6043604 100.100.100.100 dbuser Sending data SELECT dst FROM url_alias WHERE src = 'node/104452' AND language IN('en', '') ORDER BY language DESC, pid DESC ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1340287296 MySQL thread id 34228, query id 6031533 100.100.100.100 dbuser ---TRANSACTION 1 3455575596, not started, process no 6836, OS thread id 1324046656 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34235, query id 6043610 100.100.100.100 dbuser Sending data SELECT dst FROM url_alias WHERE src = 'taxonomy/term/47' AND language IN('en', '') ORDER BY language DESC, pid DESC ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1338956096 MySQL thread id 34232, query id 6043601 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1337092416 MySQL thread id 34229, query id 6030797 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1322182976 MySQL thread id 34223, query id 6030675 100.100.100.101 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1337624896 MySQL thread id 34208, query id 6030557 100.100.100.100 dbuser ---TRANSACTION 1 3455575583, not started, process no 6836, OS thread id 1337358656 MySQL thread id 34211, query id 6043292 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1338689856 MySQL thread id 34210, query id 6030379 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1099651392 MySQL thread id 34199, query id 6030366 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1325377856 MySQL thread id 34191, query id 6030263 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1100716352 MySQL thread id 34192, query id 6030250 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1100982592 MySQL thread id 34200, query id 6030212 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1101781312 MySQL thread id 34196, query id 6030205 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1339222336 MySQL thread id 34193, query id 6043515 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1105881408 MySQL thread id 34197, query id 6030152 100.100.100.100 dbuser ---TRANSACTION 1 3455575621, not started, process no 6836, OS thread id 1336559936 MySQL thread id 34201, query id 6043286 100.100.100.100 dbuser ---TRANSACTION 1 3455575529, not started, process no 6836, OS thread id 1320319296 MySQL thread id 34194, query id 6043613 100.100.100.100 dbuser SELECT * FROM menu_router WHERE path IN ('node/add/brain-trust-blog','node/add/%','node/%/brain-trust-blog','node/%/%','node/add','node/%','node') ORDER BY fit DESC LIMIT 0, 1 ---TRANSACTION 1 3455575587, not started, process no 6836, OS thread id 1104554304 MySQL thread id 34195, query id 6043031 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1318455616 MySQL thread id 34198, query id 6043401 100.100.100.100 dbuser ---TRANSACTION 1 3455575589, not started, process no 6836, OS thread id 1323247936 MySQL thread id 34188, query id 6043612 100.100.100.100 dbuser SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 1 ---TRANSACTION 1 3455575197, not started, process no 6836, OS thread id 1104820544 MySQL thread id 34181, query id 6042361 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1330170176 MySQL thread id 34185, query id 6043490 100.100.100.100 dbuser ---TRANSACTION 1 3455575605, not started, process no 6836, OS thread id 1320053056 MySQL thread id 34167, query id 6043279 100.100.100.100 dbuser ---TRANSACTION 1 3455575640, not started, process no 6836, OS thread id 1327507776 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34156, query id 6043609 100.100.100.100 dbuser statistics SELECT * FROM uc_zones WHERE zone_id = 0 ---TRANSACTION 1 3455575437, not started, process no 6836, OS thread id 1334163776 MySQL thread id 34155, query id 6043435 100.100.100.100 dbuser ---TRANSACTION 1 3455575594, not started, process no 6836, OS thread id 1332300096 MySQL thread id 34151, query id 6043030 100.100.100.100 dbuser ---TRANSACTION 1 3455575562, not started, process no 6836, OS thread id 1333897536 MySQL thread id 34152, query id 6042523 100.100.100.100 dbuser ---TRANSACTION 1 3455575392, not started, process no 6836, OS thread id 1102580032 MySQL thread id 34139, query id 6041509 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1332832576 MySQL thread id 34115, query id 6041753 100.100.100.100 dbuser ---TRANSACTION 1 3455575318, not started, process no 6836, OS thread id 1340553536 MySQL thread id 34112, query id 6042526 100.100.100.100 dbuser ---TRANSACTION 1 3455575575, not started, process no 6836, OS thread id 1331501376 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34131, query id 6043606 100.100.100.100 dbuser Sending data SELECT dst FROM url_alias WHERE src = 'premium/services' AND language IN('en', '') ORDER BY language DESC, pid DESC ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1103116608 MySQL thread id 34110, query id 6043139 100.100.100.100 dbuser ---TRANSACTION 1 3455575516, not started, process no 6836, OS thread id 1322981696 MySQL thread id 34120, query id 6042129 100.100.100.100 dbuser ---TRANSACTION 1 3455575620, not started, process no 6836, OS thread id 1333631296 MySQL thread id 34119, query id 6043575 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1319520576 MySQL thread id 34108, query id 6038359 100.100.100.100 dbuser ---TRANSACTION 1 3455575608, not started, process no 6836, OS thread id 1327241536 MySQL thread id 34068, query id 6043271 100.100.100.100 dbuser ---TRANSACTION 1 3455575007, not started, process no 6836, OS thread id 1337891136 MySQL thread id 34097, query id 6038631 100.100.100.100 dbuser ---TRANSACTION 1 3455575380, not started, process no 6836, OS thread id 1105086784 MySQL thread id 34027, query id 6043590 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1321916736 MySQL thread id 34089, query id 6025051 100.100.100.101 dbuser ---TRANSACTION 1 3455575572, not started, process no 6836, OS thread id 1329903936 MySQL thread id 34055, query id 6043489 100.100.100.100 dbuser ---TRANSACTION 1 3455575568, not started, process no 6836, OS thread id 1106413888 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34072, query id 6043608 100.100.100.100 dbuser statistics SELECT title FROM blocks WHERE module = 'bzads' AND delta = 'IC_INVST_300_250_2_BEHAV' AND theme = 'dbuser_new' ---TRANSACTION 1 3455574761, not started, process no 6836, OS thread id 1330436416 MySQL thread id 34041, query id 6043577 100.100.100.100 dbuser ---TRANSACTION 1 3455574487, not started, process no 6836, OS thread id 1330702656 MySQL thread id 34024, query id 6033299 100.100.100.100 dbuser ---TRANSACTION 1 3455575586, not started, process no 6836, OS thread id 1327774016 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 34028, query id 6043607 100.100.100.100 dbuser statistics SELECT name, mail FROM users WHERE uid = 6 ---TRANSACTION 1 3455575514, not started, process no 6836, OS thread id 1335228736 MySQL thread id 33997, query id 6042716 100.100.100.100 dbuser ---TRANSACTION 1 3455575099, not started, process no 6836, OS thread id 1323514176 MySQL thread id 33971, query id 6038127 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1318988096 MySQL thread id 33937, query id 6018316 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1332566336 MySQL thread id 33938, query id 6017985 100.100.100.100 dbuser ---TRANSACTION 0 0, not started, process no 6836, OS thread id 1321650496 MySQL thread id 32717, query id 5946110 100.100.100.100 dbuser ---TRANSACTION 1 3455575635, ACTIVE 0 sec, process no 6836, OS thread id 1099917632, thread declared inside InnoDB 163 mysql tables in use 2, locked 0 , holds adaptive hash latch MySQL thread id 34178, query id 6043372 100.100.100.100 dbuser Copying to tmp table SELECT tn.nid, n.title, n.created FROM term_node tn LEFT JOIN node n ON n.nid = tn.nid WHERE tn.tid = 57 AND n.created < '1264424561' ORDER by n.created DESC LIMIT 1 Trx read view will not see trx with id >= 1 3455575636, sees < 1 3455575636 ---------------------------- END OF INNODB MONITOR OUTPUT ============================