=====================================
|
2019-12-10 18:20:00 0x7f641d759700 INNODB MONITOR OUTPUT
|
=====================================
|
Per second averages calculated from the last 61 seconds
|
-----------------
|
BACKGROUND THREAD
|
-----------------
|
srv_master_thread loops: 136 srv_active, 0 srv_shutdown, 115 srv_idle
|
srv_master_thread log flush and writes: 251
|
----------
|
SEMAPHORES
|
----------
|
OS WAIT ARRAY INFO: reservation count 119640
|
--Thread 140066533009152 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140066527172352 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140067955721984 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140066521028352 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140067954493184 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140065100584704 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140066529322752 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140067962787584 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
--Thread 140067964937984 has waited at log0log.cc line 1087 for 0.00 seconds the semaphore:
|
Mutex at 0xabb52160, Mutex LOG_WRITE created log0log.cc:661, lock var 2
|
|
OS WAIT ARRAY INFO: signal count 10351
|
RW-shared spins 0, rounds 6932, OS waits 2879
|
RW-excl spins 0, rounds 13222, OS waits 385
|
RW-sx spins 4108, rounds 63037, OS waits 1455
|
Spin rounds per wait: 6932.00 RW-shared, 13222.00 RW-excl, 15.34 RW-sx
|