{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf430
{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww16340\viewh16500\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\ql\qnatural\pardirnatural

\f0\fs24 \cf0 mysql> show engine innodb status \\G\
*************************** 1. row ***************************\
  Type: InnoDB\
  Name: \
Status: \
=====================================\
090508 17:14:45 INNODB MONITOR OUTPUT\
=====================================\
Per second averages calculated from the last 3 seconds\
----------\
SEMAPHORES\
----------\
OS WAIT ARRAY INFO: reservation count 4685785887, signal count 3532412553\
--Thread 1140881760 has waited at row/row0mysql.c line 1676 for 1.00 seconds the semaphore:\
S-lock on RW-latch at 0xdc8ec0 created in file dict/dict0dict.c line 737\
a writer (thread id 1154263392) has reserved it in mode  exclusive\
number of readers 0, waiters flag 1\
Last time read locked in file row/row0mysql.c line 1676\
Last time write locked in file row/row0mysql.c line 1711\
Mutex spin waits 0, rounds 214298510754, OS waits 1528467390\
RW-shared spins 301897840, OS waits 46928787; RW-excl spins 4517530832, OS waits 2220947167\
------------\
TRANSACTIONS\
------------\
Trx id counter 0 200470345\
Purge done for trx's n:o < 0 200470341 undo n:o < 0 1\
History list length 2\
LIST OF TRANSACTIONS FOR EACH SESSION:\
---TRANSACTION 0 200470343, not started, process no 13223, OS thread id 1154263392 dropping table\
MySQL thread id 1345638, query id 2137458194 localhost dbbackup\
drop table fact_cpc_day_uu_new\
---TRANSACTION 0 0, not started, process no 13223, OS thread id 1153587552\
MySQL thread id 1345739, query id 2137458648 10.11.152.44 dbbackup\
show engine innodb status\
---TRANSACTION 0 0, not started, process no 13223, OS thread id 1155479904\
MySQL thread id 1345679, query id 2137458526 10.11.152.44 dbbackup Opening tables\
\
---TRANSACTION 0 0, not started, process no 13223, OS thread id 1154263392\
MySQL thread id 1345638, query id 2137458194 localhost dbbackup\
drop table fact_cpc_day_uu_new\
---TRANSACTION 0 200468887, not started, process no 13223, OS thread id 1142503776\
MySQL thread id 1252979, query id 2137458197 10.11.152.44 repl Opening tables\
INSERT INTO heartbeat (time_int, time_ts, slave_host) VALUES (UNIX_TIMESTAMP(), CURRENT_TIMESTAMP(), 'dmdb906.sc9.admob.int')\
---TRANSACTION 0 200465823, not started, process no 13223, OS thread id 1150073184\
MySQL thread id 587003, query id 2137458351 Opening tables\
---TRANSACTION 0 200468884, ACTIVE 654 sec, process no 13223, OS thread id 1154533728\
1539 lock struct(s), heap size 256784, 3647 row lock(s), undo log entries 4051\
MySQL thread id 1344929, query id 2137458193 10.11.16.77 dmcpcadmin freeing items\
insert into fact_cpc_day_ad_site_location (linked_list_request, traffic, linked_list_traffic, multi_ad_traffic, impression, linked_list_impression, click, affiliate_revenue, site_revenue, bid_spend, fee_spend, coupon_bid_spend, coupon_fee_spend, app_exchange_traffic, app_exchange_impression, app_exchange_click, universal_date_key, ad_key, site_key, location_key)values(0, 0, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 6, 6, 0, 20090508, 85348, 25964, 224) ON DUPLICATE KEY UPDATE linked_list_request = linked_list_request + VALUES(linked_list_request), traffic = traffic + VALUES(traffic),linked_\
--------\
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\
77149800 OS file reads, 154667645 OS file writes, 79430057 OS fsyncs\
1.67 reads/s, 65536 avg bytes/read, 1.00 writes/s, 1.00 fsyncs/s\
-------------------------------------\
INSERT BUFFER AND ADAPTIVE HASH INDEX\
-------------------------------------\
Ibuf: size 1, free list len 11, seg size 13,\
5159 inserts, 5159 merged recs, 9870 merges\
Hash table size 74374277, node heap has 10261 buffer(s)\
2.33 hash searches/s, 12.33 non-hash searches/s\
---\
LOG\
---\
Log sequence number 10049 328133242\
Log flushed up to   10049 328133242\
Last checkpoint at  10048 3915079232\
0 pending log writes, 0 pending chkp writes\
52564667 log i/o's done, 1.00 log i/o's/second\
----------------------\
BUFFER POOL AND MEMORY\
----------------------\
Total memory allocated 39701278738; in additional pool allocated 16774912\
Dictionary memory allocated 171804976\
Buffer pool size   573440\
Free buffers       323\
Database pages     562855\
Modified db pages  65715\
Pending reads 0\
Pending writes: LRU 0, flush list 0, single page 0\
Pages read 111115784, created 138521553, written 679196331\
1.67 reads/s, 0.00 creates/s, 0.00 writes/s\
Buffer pool hit rate 1000 / 1000\
--------------\
ROW OPERATIONS\
--------------\
8 queries inside InnoDB, 0 queries in queue\
1 read views open inside InnoDB\
Main thread process no. 13223, id 1140881760, state: purging\
Number of rows inserted 39722452376, updated 8708735086, deleted 681392569, read 255561399147\
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\
----------------------------\
END OF INNODB MONITOR OUTPUT\
============================}