InnoDB: ###### Diagnostic info printed to the standard error
stream
InnoDB: Warning: a long semaphore wait:
--Thread 140229866665728 has waited at trx/trx0roll.c line
1307 for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229880882944 has waited at lock/lock0lock.c line
3065 for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229870126848 has waited at row/row0sel.c line 4607
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232784000768 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229870393088 has waited at trx/trx0trx.c line 213
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229869061888 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229866133248 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232696944384 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140229867730688 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232698275584 has waited at trx/trx0trx.c line 722
for 800.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232734336768 has waited at srv/srv0srv.c line 2139
for 799.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232696411904 has waited at trx/trx0trx.c line 213
for 799.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140232696145664 has waited at trx/trx0trx.c line 366
for 796.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print
diagnostic info:
InnoDB: Pending preads 0, pwrites 0
=====================================
150818 19:19:21 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 175414, signal count
173733
--Thread 140229866665728 has waited at trx/trx0roll.c line
1307 for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229880882944 has waited at lock/lock0lock.c line
3065 for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229870126848 has waited at row/row0sel.c line 4607
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232784000768 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229870393088 has waited at trx/trx0trx.c line 213
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229869061888 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229866133248 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232696944384 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140229867730688 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232698275584 has waited at trx/trx0trx.c line 722
for 807.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232734336768 has waited at srv/srv0srv.c line 2139
for 806.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232696411904 has waited at trx/trx0trx.c line 213
for 806.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
--Thread 140232696145664 has waited at trx/trx0trx.c line 366
for 803.00 seconds the semaphore:
Mutex at 0x7f8a5b8312b8 created file srv/srv0srv.c line 895,
lock var 1
waiters flag 1
Mutex spin waits 0, rounds 15438442, OS waits 59108
RW-shared spins 169269, OS waits 80322; RW-excl spins 96942,
OS waits 8555
FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING
--------
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
3005 OS file reads, 2293807 OS file writes, 675582 OS
fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00
fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 4425293, node heap has 7584 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 1 2350535124
Log flushed up to 1 2349881317
Last checkpoint at 1 1767036368
0 pending log writes, 0 pending chkp writes
1762131 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 2411615230; in additional pool
allocated 20971264
Dictionary memory allocated 2370760
Buffer pool size 131072
Free buffers 81913
Database pages 41575
Modified db pages 12887
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 1877, created 39698, written 701321
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 13 queries in queue
3 read views open inside InnoDB
Main thread process no. 2556, id 140229880882944, state:
purging
Number of rows inserted 21957494, updated 6634092, deleted
16747592, read 160489054
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00
reads/s
----------------------------
END OF INNODB MONITOR OUTPUT