{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Calibri;}} {\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\sa200\sl276\slmult1\lang7\f0\fs22 mysql> show innodb status\\G\par *************************** 1. row ***************************\par Type: InnoDB\par Name:\par Status:\par =====================================\par 100121 13:50:24 INNODB MONITOR OUTPUT\par =====================================\par Per second averages calculated from the last 1 seconds\par ----------\par SEMAPHORES\par ----------\par OS WAIT ARRAY INFO: reservation count 60955335, signal count 43362466\par --Thread 1146145120 has waited at ../../../storage/innobase/btr/btr0cur.c line 443 for 0.00 seconds the semaphore:\par S-lock on RW-latch at 0x2aaab38e6e68 created in file ../../../storage/innobase/buf/buf0buf.c line 547\par a writer (thread id 1146145120) has reserved it in mode exclusive\par number of readers 0, waiters flag 1\par Last time read locked in file ../../../storage/innobase/btr/btr0cur.c line 443\par Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1797\par Mutex spin waits 0, rounds 1319332848, OS waits 34102857\par RW-shared spins 48138774, OS waits 21645952; RW-excl spins 775701, OS waits 299764\par ------------\par TRANSACTIONS\par ------------\par Trx id counter 0 60012765\par Purge done for trx's n:o < 0 60011625 undo n:o < 0 0\par History list length 19\par LIST OF TRANSACTIONS FOR EACH SESSION:\par ---TRANSACTION 0 0, not started, process no 21505, OS thread id 1150355808\par MySQL thread id 18335, query id 1694275 localhost root\par show innodb status\par ---TRANSACTION 0 0, not started, process no 21505, OS thread id 1167198560\par MySQL thread id 18063, query id 1694274 pD9E3E757.dip.t-dialin.net 217.227.231.87 root\par ---TRANSACTION 0 0, not started, process no 21505, OS thread id 1151408480\par MySQL thread id 17625, query id 1694274 pD9E3E757.dip.t-dialin.net 217.227.231.87 root\par ---TRANSACTION 0 60012265, ACTIVE 452 sec, process no 21505, OS thread id 1146145120 fetching rows, thread declared inside InnoDB 269\par mysql tables in use 11, locked 0\par MySQL thread id 18031, query id 1687482 localhost root Sending data\par explain SELECT list.* , count(DISTINCT com.id) as comments, max(ind.ind_order) + 1 as inv FROM (SELECT kll.kll_id, kll.kll_timestamp, kll.kll_external_id, plt.plt_name, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_system_id, kll.kll_ship_id, kll.kll_victim_id, plt.plt_externalid, kll.kll_crp_id, k\par Trx read view will not see trx with id >= 0 60012266, sees < 0 60012266\par --------\par FILE I/O\par --------\par I/O thread 0 state: waiting for i/o request (insert buffer thread)\par I/O thread 1 state: waiting for i/o request (log thread)\par I/O thread 2 state: doing file i/o (read thread) ev set\par I/O thread 3 state: waiting for i/o request (write thread)\par Pending normal aio reads: 16, aio writes: 0,\par ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0\par Pending flushes (fsync) log: 0; buffer pool: 0\par 166756621 OS file reads, 6744 OS file writes, 4024 OS fsyncs\par 1 pending preads, 0 pending pwrites\par 5804.20 reads/s, 27342 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s\par -------------------------------------\par INSERT BUFFER AND ADAPTIVE HASH INDEX\par -------------------------------------\par Ibuf: size 1, free list len 19, seg size 21,\par 1569 inserts, 1569 merged recs, 668 merges\par Hash table size 17393, node heap has 5 buffer(s)\par 712.29 hash searches/s, 21356.64 non-hash searches/s\par ---\par LOG\par ---\par Log sequence number 1 57410133\par Log flushed up to 1 57410133\par Last checkpoint at 1 57410133\par 0 pending log writes, 0 pending chkp writes\par 2335 log i/o's done, 0.00 log i/o's/second\par ----------------------\par BUFFER POOL AND MEMORY\par ----------------------\par Total memory allocated 26041058; in additional pool allocated 1048576\par Dictionary memory allocated 3943624\par Buffer pool size 512\par Free buffers 0\par Database pages 507\par Modified db pages 0\par Pending reads 16\par Pending writes: LRU 0, flush list 0, single page 0\par Pages read 271741138, created 30, written 3814\par 9677.32 reads/s, 0.00 creates/s, 0.00 writes/s\par Buffer pool hit rate 906 / 1000\par --------------\par ROW OPERATIONS\par --------------\par 1 queries inside InnoDB, 0 queries in queue\par 2 read views open inside InnoDB\par Main thread process no. 21505, id 1140881760, state: waiting for server activity\par Number of rows inserted 865, updated 1190, deleted 0, read 1652513586\par 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 22063.94 reads/s\par ----------------------------\par END OF INNODB MONITOR OUTPUT\par ============================\par \par 1 row in set, 1 warning (0.00 sec)\par }