rendered paste bodyavg-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
============================