Created
July 10, 2012 18:25
-
-
Save denishaskin/3085323 to your computer and use it in GitHub Desktop.
show engine innodb status
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> show engine innodb status\G | |
*************************** 1. row *************************** | |
Type: InnoDB | |
Name: | |
Status: | |
===================================== | |
120710 18:22:35 INNODB MONITOR OUTPUT | |
===================================== | |
Per second averages calculated from the last 3 seconds | |
----------------- | |
BACKGROUND THREAD | |
----------------- | |
srv_master_thread loops: 1000 1_second, 998 sleeps, 93 10_second, 769 background, 769 flush | |
srv_master_thread log flush and writes: 1121 | |
---------- | |
SEMAPHORES | |
---------- | |
OS WAIT ARRAY INFO: reservation count 8570960, signal count 999043 | |
--Thread 1231681856 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1243396416 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1242597696 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1242331456 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1243662656 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1242065216 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1243130176 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1241266496 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1241798976 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1230616896 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1232480576 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1077348672 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1242863936 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1241532736 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae3030c0 created in file buf0buf.c line 916 | |
a writer (thread id 1230084416) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1238071616 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1239669056 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1238337856 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1235142976 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1237539136 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1076468032 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1237006656 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1235675456 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1232746816 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1235941696 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1236474176 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1239402816 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1238870336 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1234078016 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1239935296 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1075652928 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1237805376 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1233545536 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1238604096 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1236207936 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1240201536 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1077696832 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1234876736 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1233811776 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1234610496 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1239136576 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1240467776 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1233013056 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1236740416 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1234344256 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1237272896 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1241000256 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
--Thread 1240734016 has waited at btr0cur.c line 310 for 0.00 seconds the semaphore: | |
S-lock on RW-latch at 0x2aaaae395040 created in file buf0buf.c line 916 | |
a writer (thread id 1235409216) has reserved it in mode exclusive | |
number of readers 0, waiters flag 1, lock_word: 0 | |
Last time read locked in file row0sel.c line 3097 | |
Last time write locked in file /local/mysqlbuild/mysql-5.5.23.R1/storage/innobase/buf/buf0buf.c line 3151 | |
Mutex spin waits 1852967, rounds 4775679, OS waits 13798 | |
RW-shared spins 13559545, rounds 402405124, OS waits 8549704 | |
RW-excl spins 250378, rounds 743905, OS waits 1516 | |
Spin rounds per wait: 2.58 mutex, 29.68 RW-shared, 2.97 RW-excl | |
------------ | |
TRANSACTIONS | |
------------ | |
Trx id counter 8DEE2A | |
Purge done for trx's n:o < 8DABF8 undo n:o < 0 | |
History list length 7190 | |
LIST OF TRANSACTIONS FOR EACH SESSION: | |
---TRANSACTION 0, not started | |
MySQL thread id 141, OS thread handle 0x4961d940, query id 46600 ip-10-46-110-102.ec2.internal 10.46.110.102 root | |
show engine innodb status | |
---TRANSACTION 0, not started | |
MySQL thread id 133, OS thread handle 0x496e0940, query id 46562 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting | |
---TRANSACTION 8DEE26, not started | |
MySQL thread id 6, OS thread handle 0x4955a940, query id 46521 ip-10-50-211-108.ec2.internal 10.50.211.108 app | |
---TRANSACTION 8DEE29, ACTIVE 26 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 142, OS thread handle 0x4959b940, query id 46591 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE2A, sees < 8DABF1 | |
---TRANSACTION 8DEE28, ACTIVE 85 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 139, OS thread handle 0x49762940, query id 46580 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE29, sees < 8DABF1 | |
---TRANSACTION 8DEE27, ACTIVE 141 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 136, OS thread handle 0x49519940, query id 46522 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE28, sees < 8DABF1 | |
---TRANSACTION 8DEE10, ACTIVE 166 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 134, OS thread handle 0x4969f940, query id 46429 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE11, sees < 8DABF1 | |
---TRANSACTION 8DEE0F, ACTIVE 325 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 131, OS thread handle 0x4a20c940, query id 46350 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE10, sees < 8DABF1 | |
---TRANSACTION 8DEE0D, ACTIVE 385 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 130, OS thread handle 0x4a1cb940, query id 46312 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE0E, sees < 8DABF0 | |
---TRANSACTION 8DEE0C, ACTIVE 394 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 129, OS thread handle 0x4a18a940, query id 46311 ip-10-46-110-102.ec2.internal 10.46.110.102 root Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE0D, sees < 8DABF0 | |
---TRANSACTION 8DEE0B, ACTIVE 445 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 128, OS thread handle 0x4a149940, query id 46286 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEE0C, sees < 8DABF0 | |
---TRANSACTION 8DEDEE, ACTIVE 505 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 126, OS thread handle 0x4a045940, query id 46192 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEDEF, sees < 8DABF0 | |
---TRANSACTION 8DEDB1, ACTIVE 565 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 125, OS thread handle 0x4a108940, query id 46182 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DEDB2, sees < 8DABF0 | |
---TRANSACTION 8DED32, ACTIVE 625 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 124, OS thread handle 0x4a0c7940, query id 46173 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DED33, sees < 8DABF0 | |
---TRANSACTION 8DED23, ACTIVE 685 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 123, OS thread handle 0x4a086940, query id 46162 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DED24, sees < 8DABF0 | |
---TRANSACTION 8DB54B, ACTIVE 745 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 122, OS thread handle 0x40370940, query id 37262 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DB54C, sees < 8DABF0 | |
---TRANSACTION 8DACD3, ACTIVE 805 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 119, OS thread handle 0x4a004940, query id 35033 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACD4, sees < 8DABF0 | |
---TRANSACTION 8DACD2, ACTIVE 865 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 118, OS thread handle 0x49fc3940, query id 35024 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACD3, sees < 8DABF0 | |
---TRANSACTION 8DACD1, ACTIVE 925 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 117, OS thread handle 0x49f82940, query id 35015 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACD2, sees < 8DABF0 | |
---TRANSACTION 8DACD0, ACTIVE 985 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 116, OS thread handle 0x49f41940, query id 35006 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACD1, sees < 8DABF0 | |
---TRANSACTION 8DACCF, ACTIVE 1045 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 115, OS thread handle 0x49f00940, query id 34997 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACD0, sees < 8DABF0 | |
---TRANSACTION 8DACAE, ACTIVE 1105 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 113, OS thread handle 0x49ebf940, query id 34896 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACAF, sees < 8DABF0 | |
---TRANSACTION 8DACAD, ACTIVE 1165 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 112, OS thread handle 0x49e7e940, query id 34887 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACAE, sees < 8DABF0 | |
---TRANSACTION 8DACAC, ACTIVE 1225 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 111, OS thread handle 0x49e3d940, query id 34878 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACAD, sees < 8DABF0 | |
---TRANSACTION 8DACAB, ACTIVE 1285 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 110, OS thread handle 0x49dfc940, query id 34869 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DACAC, sees < 8DABF0 | |
---TRANSACTION 8DAC93, ACTIVE 1345 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 109, OS thread handle 0x49dbb940, query id 34780 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC94, sees < 8DABF0 | |
---TRANSACTION 8DAC92, ACTIVE 1400 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 107, OS thread handle 0x49d7a940, query id 34770 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC93, sees < 8DABF0 | |
---TRANSACTION 8DAC91, ACTIVE 1465 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 106, OS thread handle 0x49d39940, query id 34759 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC92, sees < 8DABF0 | |
---TRANSACTION 8DAC90, ACTIVE 1525 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 105, OS thread handle 0x49cf8940, query id 34750 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC91, sees < 8DABF0 | |
---TRANSACTION 8DAC8F, ACTIVE 1585 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 104, OS thread handle 0x49cb7940, query id 34741 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC90, sees < 8DABF0 | |
---TRANSACTION 8DAC8E, ACTIVE 1645 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 103, OS thread handle 0x49c76940, query id 34732 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC8F, sees < 8DABF0 | |
---TRANSACTION 8DAC71, ACTIVE 1705 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 101, OS thread handle 0x49c35940, query id 34635 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC72, sees < 8DABF0 | |
---TRANSACTION 8DAC70, ACTIVE 1765 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 100, OS thread handle 0x49bf4940, query id 34626 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC71, sees < 8DABF0 | |
---TRANSACTION 8DAC6F, ACTIVE 1825 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 99, OS thread handle 0x49bb3940, query id 34617 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC70, sees < 8DABF0 | |
---TRANSACTION 8DAC6E, ACTIVE 1885 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 98, OS thread handle 0x49b72940, query id 34608 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC6F, sees < 8DABF0 | |
---TRANSACTION 8DAC6D, ACTIVE 1945 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 97, OS thread handle 0x49b31940, query id 34599 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC6E, sees < 8DABF0 | |
---TRANSACTION 8DAC55, ACTIVE 2005 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 95, OS thread handle 0x49af0940, query id 34507 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC56, sees < 8DABF0 | |
---TRANSACTION 8DAC54, ACTIVE 2065 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 94, OS thread handle 0x49aaf940, query id 34498 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC55, sees < 8DABF0 | |
---TRANSACTION 8DAC53, ACTIVE 2125 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 93, OS thread handle 0x49a6e940, query id 34489 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC54, sees < 8DABF0 | |
---TRANSACTION 8DAC52, ACTIVE 2185 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 92, OS thread handle 0x49a2d940, query id 34480 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC53, sees < 8DABF0 | |
---TRANSACTION 8DAC51, ACTIVE 2245 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 91, OS thread handle 0x499ec940, query id 34471 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC52, sees < 8DABF0 | |
---TRANSACTION 8DAC31, ACTIVE 2305 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 89, OS thread handle 0x499ab940, query id 34371 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC32, sees < 8DABF0 | |
---TRANSACTION 8DAC30, ACTIVE 2365 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 88, OS thread handle 0x4996a940, query id 34362 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC31, sees < 8DABF0 | |
---TRANSACTION 8DAC2F, ACTIVE 2425 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 87, OS thread handle 0x403c5940, query id 34353 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC30, sees < 8DABF0 | |
---TRANSACTION 8DAC2E, ACTIVE 2485 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 86, OS thread handle 0x401d2940, query id 34344 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC2F, sees < 8DABF0 | |
---TRANSACTION 8DAC2D, ACTIVE 2545 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 85, OS thread handle 0x49929940, query id 34335 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC2E, sees < 8DABF0 | |
---TRANSACTION 8DAC15, ACTIVE 2605 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 83, OS thread handle 0x498e8940, query id 34243 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC16, sees < 8DABF0 | |
---TRANSACTION 8DAC14, ACTIVE 2665 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 82, OS thread handle 0x498a7940, query id 34234 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC15, sees < 8DABF0 | |
---TRANSACTION 8DAC13, ACTIVE 2725 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 81, OS thread handle 0x49866940, query id 34225 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC14, sees < 8DABF0 | |
---TRANSACTION 8DAC12, ACTIVE 2785 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 80, OS thread handle 0x40299940, query id 34216 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC13, sees < 8DABF0 | |
---TRANSACTION 8DAC11, ACTIVE 2845 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 79, OS thread handle 0x497e4940, query id 34207 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DAC12, sees < 8DABF0 | |
---TRANSACTION 8DABF1, ACTIVE 2905 sec fetching rows | |
mysql tables in use 73, locked 0 | |
MySQL thread id 77, OS thread handle 0x497a3940, query id 34107 ip-10-46-110-102.ec2.internal 10.46.110.102 reporting Sending data | |
select sysdate(), c.time_received, c.archive_time_received, | |
time_to_sec(timediff(sysdate(), c.time_received)) as 'LocProxyReceivedLatency', | |
time_to_sec(timediff(sysdate(), c.archive_time_received)) as 'LocDbReceivedLatency', | |
time_to_sec(timediff(c.archive_time_received, c.time_received)) as 'LocProxyToDbLatency' | |
from obanyc_cclocationreport c where time_received>=subtime(sysdate(), '1:00') order by time_received desc limit 1 | |
Trx read view will not see trx with id >= 8DABF2, sees < 8DABF0 | |
-------- | |
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 (read thread) | |
I/O thread 4 state: waiting for i/o request (read thread) | |
I/O thread 5 state: waiting for i/o request (read thread) | |
I/O thread 6 state: waiting for i/o request (write thread) | |
I/O thread 7 state: waiting for i/o request (write thread) | |
I/O thread 8 state: waiting for i/o request (write thread) | |
I/O thread 9 state: waiting for i/o request (write thread) | |
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , | |
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 | |
Pending flushes (fsync) log: 0; buffer pool: 0 | |
1378452 OS file reads, 74273 OS file writes, 49139 OS fsyncs | |
2 pending preads, 0 pending pwrites | |
815.39 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s | |
------------------------------------- | |
INSERT BUFFER AND ADAPTIVE HASH INDEX | |
------------------------------------- | |
Ibuf: size 1, free list len 22911, seg size 22913, 29829 merges | |
merged operations: | |
insert 61761, delete mark 0, delete 0 | |
discarded operations: | |
insert 16, delete mark 0, delete 0 | |
Hash table size 11641807, node heap has 4407 buffer(s) | |
0.00 hash searches/s, 18480.51 non-hash searches/s | |
--- | |
LOG | |
--- | |
Log sequence number 275726168382 | |
Log flushed up to 275726168382 | |
Last checkpoint at 275726168382 | |
0 pending log writes, 0 pending chkp writes | |
45171 log i/o's done, 0.00 log i/o's/second | |
---------------------- | |
BUFFER POOL AND MEMORY | |
---------------------- | |
Total memory allocated 6020382720; in additional pool allocated 0 | |
Dictionary memory allocated 1748190 | |
Buffer pool size 359039 | |
Free buffers 0 | |
Database pages 354632 | |
Old database pages 130889 | |
Modified db pages 0 | |
Pending reads 2 | |
Pending writes: LRU 0, flush list 0, single page 0 | |
Pages made young 2199445, not young 0 | |
816.06 youngs/s, 0.00 non-youngs/s | |
Pages read 1413997, created 44249, written 111774 | |
815.39 reads/s, 0.00 creates/s, 0.00 writes/s | |
Buffer pool hit rate 993 / 1000, young-making rate 7 / 1000 not 0 / 1000 | |
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s | |
LRU len: 354632, unzip_LRU len: 0 | |
I/O sum[32445]:cur[608], unzip sum[0]:cur[0] | |
-------------- | |
ROW OPERATIONS | |
-------------- | |
0 queries inside InnoDB, 0 queries in queue | |
50 read views open inside InnoDB | |
Main thread process no. 30991, id 1197816128, state: waiting for server activity | |
Number of rows inserted 3799642, updated 20788, deleted 10893, read 246074274 | |
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 162117.96 reads/s | |
---------------------------- | |
END OF INNODB MONITOR OUTPUT | |
============================ | |
1 row in set (0.01 sec) | |
mysql> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment