avg-cpu: %user %nice %sys %iowait %idle 20.95 0.00 4.66 12.95 61.44 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util cciss/c0d0 0.00 35.43 1.95 14.50 15.60 399.42 7.80 199.71 25.23 0.26 15.72 3.24 5.32 cciss/c0d1 0.09 55.28 213.74 38.57 2279.12 1482.54 1139.56 741.27 14.91 2.33 9.23 1.05 26.45 avg-cpu: %user %nice %sys %iowait %idle 36.77 0.00 3.78 32.47 26.98 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util cciss/c0d0 0.00 32.93 71.73 155.63 573.87 1508.80 286.93 754.40 9.16 0.80 3.54 2.59 58.78 cciss/c0d1 0.00 72.03 357.27 43.83 2857.87 926.93 1428.93 463.47 9.44 4.43 11.06 0.88 35.33 avg-cpu: %user %nice %sys %iowait %idle 36.71 0.00 4.02 31.72 27.55 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util cciss/c0d0 0.00 21.63 12.90 160.15 103.17 1454.18 51.58 727.09 9.00 0.68 3.95 3.29 56.91 cciss/c0d1 0.00 121.59 380.37 48.68 3042.99 1362.21 1521.49 681.11 10.27 4.60 10.73 0.88 37.94 avg-cpu: %user %nice %sys %iowait %idle 30.94 0.00 3.97 34.61 30.49 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util cciss/c0d0 0.00 22.44 13.10 164.52 104.83 1495.70 52.42 747.85 9.01 0.74 4.19 3.34 59.29 cciss/c0d1 0.00 114.64 404.80 53.25 3238.41 1343.11 1619.21 671.56 10.00 4.65 10.15 0.80 36.69 ===================================== 070712 1:37:27 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 36 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 262735, signal count 238065 Mutex spin waits 0, rounds 12048492, OS waits 107336 RW-shared spins 250213, OS waits 100007; RW-excl spins 241932, OS waits 27845 ------------ TRANSACTIONS ------------ Trx id counter 0 40030308 Purge done for trx's n:o < 0 40024761 undo n:o < 0 0 History list length 1174 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 22011, OS thread id 1165646176 MySQL thread id 102921, query id 7359436 localhost root show innodb status ---TRANSACTION 0 40030306, COMMITTED IN MEMORY, process no 22011, OS thread id 1162451296 committing, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 , undo log entries 1 -------- 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: 1; buffer pool: 0 944904 OS file reads, 1401489 OS file writes, 1348537 OS fsyncs 52.55 reads/s, 27277 avg bytes/read, 164.19 writes/s, 161.83 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 3978, free list len 3358, seg size 7337, 1189865 inserts, 781317 merged recs, 19977 merges Hash table size 8850487, used cells 7894945, node heap has 29058 buffer(s) 50335.46 hash searches/s, 4613.65 non-hash searches/s --- LOG --- Log sequence number 11 3757957862 Log flushed up to 11 3757957862 Last checkpoint at 11 3542738513 0 pending log writes, 0 pending chkp writes 1337145 log i/o's done, 161.38 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 4818440453; in additional pool allocated 19268608 Buffer pool size 262144 Free buffers 17 Database pages 233069 Modified db pages 22003 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1377811, created 6660, written 106633 87.50 reads/s, 0.72 creates/s, 4.39 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 22011, id 1157658976, state: sleeping Number of rows inserted 814562, updated 1243615, deleted 645, read 7600710400 95.41 inserts/s, 149.50 updates/s, 0.00 deletes/s, 798764.12 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================