===================================== 081016 16:44:32 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 34 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2429015, signal count 1595492 Mutex spin waits 0, rounds 11589716, OS waits 155979 RW-shared spins 5307639, OS waits 1909776; RW-excl spins 11195230, OS waits 312945 ------------ TRANSACTIONS ------------ Trx id counter 0 1575344 Purge done for trx's n:o < 0 1575221 undo n:o < 0 0 History list length 1 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1572548, not started, OS thread id 344 MySQL thread id 334, query id 5492568 localhost 127.0.0.1 db_name ---TRANSACTION 0 1572413, not started, OS thread id 343 MySQL thread id 333, query id 5492003 localhost 127.0.0.1 db_name ---TRANSACTION 0 1575327, not started, OS thread id 341 MySQL thread id 331, query id 5502120 localhost 127.0.0.1 db_name ---TRANSACTION 0 1560592, not started, OS thread id 335 MySQL thread id 325, query id 5446520 localhost 127.0.0.1 db_name ---TRANSACTION 0 1560664, not started, OS thread id 331 MySQL thread id 321, query id 5446672 localhost 127.0.0.1 db_name ---TRANSACTION 0 1560724, not started, OS thread id 328 MySQL thread id 318, query id 5446805 localhost 127.0.0.1 db_name ---TRANSACTION 0 1560484, not started, OS thread id 327 MySQL thread id 317, query id 5446526 localhost 127.0.0.1 db_name ---TRANSACTION 0 1393363, not started, OS thread id 284 MySQL thread id 274, query id 4844125 localhost 127.0.0.1 db_name ---TRANSACTION 0 1528427, not started, OS thread id 277 MySQL thread id 267, query id 5502164 localhost root show innodb status ---TRANSACTION 0 1330661, not started, OS thread id 276 MySQL thread id 266, query id 4615624 localhost 127.0.0.1 db_name ---TRANSACTION 0 1329540, not started, OS thread id 275 MySQL thread id 265, query id 4611776 localhost 127.0.0.1 db_name ---TRANSACTION 0 1340901, not started, OS thread id 273 MySQL thread id 263, query id 4650714 localhost 127.0.0.1 db_name ---TRANSACTION 0 1337486, not started, OS thread id 272 MySQL thread id 262, query id 4640111 localhost 127.0.0.1 db_name ---TRANSACTION 0 1331173, not started, OS thread id 267 MySQL thread id 257, query id 4616882 localhost 127.0.0.1 db_name ---TRANSACTION 0 1330645, not started, OS thread id 266 MySQL thread id 256, query id 4616605 localhost 127.0.0.1 db_name ---TRANSACTION 0 1330677, not started, OS thread id 259 MySQL thread id 249, query id 4615625 localhost 127.0.0.1 db_name ---TRANSACTION 0 1288263, not started, OS thread id 248 MySQL thread id 238, query id 4440761 localhost 127.0.0.1 db_name ---TRANSACTION 0 1263428, not started, OS thread id 239 MySQL thread id 229, query id 4352687 localhost 127.0.0.1 db_name ---TRANSACTION 0 1263481, not started, OS thread id 220 MySQL thread id 210, query id 4352841 localhost 127.0.0.1 db_name ---TRANSACTION 0 1575222, not started, OS thread id 135 MySQL thread id 125, query id 5501858 localhost 127.0.0.1 db_name ---TRANSACTION 0 1537713, not started, OS thread id 103 MySQL thread id 93, query id 5365215 localhost 127.0.0.1 db_name ---TRANSACTION 0 1575199, not started, OS thread id 102 MySQL thread id 92, query id 5501808 localhost 127.0.0.1 db_name ---TRANSACTION 0 1574749, not started, OS thread id 101 MySQL thread id 91, query id 5500825 localhost 127.0.0.1 db_name ---TRANSACTION 0 1231305, not started, OS thread id 53 MySQL thread id 43, query id 4239851 localhost 127.0.0.1 db_name ---TRANSACTION 0 1355367, not started, OS thread id 45 MySQL thread id 35, query id 4702129 localhost 127.0.0.1 db_name ---TRANSACTION 0 22038, not started, OS thread id 44 MySQL thread id 34, query id 15245 localhost 127.0.0.1 db_name ---TRANSACTION 0 1575343, ACTIVE 15 sec, OS thread id 342 starting index read, thread declared inside InnoDB 131 mysql tables in use 13, locked 0 MySQL thread id 332, query id 5502162 localhost 127.0.0.1 db_name Sending data SELECT t_Object.c_id AS id, t_Object.c_objectDefName AS objectDefName, t_Object.c_id AS display, t_Object.c_owner AS owner, t_Object.c_ownerDefName AS ownerDefName,t_RegRegister.c_status,t_RegRegister.c_regNumber,t_RegRegister.c_subject,a_User0.c_fullName,t_RegRegister.c_regDocument FROM t_RegRegister LEFT JOIN (SELECT t_Participant.c_Id,t_Participant.c_fullName FROM t_Participant,t_User WHERE t_Participant.c_Id=t_User.c_Id) a_User0 ON t_RegRegister.c_userToProcess=a_User0.c_Id , t_Document, t_Object WHERE t_Document.c_Id = t_RegRegister.c_Id AND t_Object.c_Id = t_Document.c_Id AND (t_RegRegi Trx read view will not see trx with id >= 0 1575344, sees < 0 1575305 ---TRANSACTION 0 1575324, ACTIVE 17 sec, OS thread id 345, thread declared inside InnoDB 83 mysql tables in use 13, locked 0 MySQL thread id 335, query id 5502117 localhost 127.0.0.1 db_name Sending data SELECT t_Object.c_id AS id, t_Object.c_objectDefName AS objectDefName, t_Object.c_id AS display, t_Object.c_owner AS owner, t_Object.c_ownerDefName AS ownerDefName,t_RegRegister.c_status,t_RegRegister.c_regNumber,t_RegRegister.c_subject,a_User0.c_fullName,t_RegRegister.c_regDocument FROM t_RegRegister LEFT JOIN (SELECT t_Participant.c_Id,t_Participant.c_fullName FROM t_Participant,t_User WHERE t_Participant.c_Id=t_User.c_Id) a_User0 ON t_RegRegister.c_userToProcess=a_User0.c_Id , t_Document, t_Object WHERE t_Document.c_Id = t_RegRegister.c_Id AND t_Object.c_Id = t_Document.c_Id AND (t_RegRegi Trx read view will not see trx with id >= 0 1575325, sees < 0 1575286 ---TRANSACTION 0 1575305, ACTIVE 25 sec, OS thread id 340 starting index read, thread declared inside InnoDB 45 mysql tables in use 13, locked 0 MySQL thread id 330, query id 5502071 localhost 127.0.0.1 db_name Sending data SELECT t_Object.c_id AS id, t_Object.c_objectDefName AS objectDefName, t_Object.c_id AS display, t_Object.c_owner AS owner, t_Object.c_ownerDefName AS ownerDefName,t_RegRegister.c_status,t_RegRegister.c_regNumber,t_RegRegister.c_subject,a_User0.c_fullName,t_RegRegister.c_regDocument FROM t_RegRegister LEFT JOIN (SELECT t_Participant.c_Id,t_Participant.c_fullName FROM t_Participant,t_User WHERE t_Participant.c_Id=t_User.c_Id) a_User0 ON t_RegRegister.c_userToProcess=a_User0.c_Id , t_Document, t_Object WHERE t_Document.c_Id = t_RegRegister.c_Id AND t_Object.c_Id = t_Document.c_Id AND (t_RegRegi Trx read view will not see trx with id >= 0 1575306, sees < 0 1575254 -------- 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 (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 417017 OS file reads, 584991 OS file writes, 480771 OS fsyncs 1.35 reads/s, 20658 avg bytes/read, 1.94 writes/s, 0.26 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 8964 inserts, 8964 merged recs, 2313 merges Hash table size 4425293, used cells 4269925, node heap has 21855 buffer(s) 112834.71 hash searches/s, 128429.66 non-hash searches/s --- LOG --- Log sequence number 1 3750102965 Log flushed up to 1 3750102965 Last checkpoint at 1 3750102965 0 pending log writes, 0 pending chkp writes 472304 log i/o's done, 0.12 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2398502192; in additional pool allocated 12940544 Buffer pool size 131072 Free buffers 1 Database pages 109216 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1772514, created 2889, written 132194 1.71 reads/s, 0.00 creates/s, 2.12 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 3 queries inside InnoDB, 0 queries in queue 4 read views open inside InnoDB Main thread id 9, state: waiting for server activity Number of rows inserted 301429, updated 370722, deleted 48431, read 18855602736 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1707179.32 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================