开发者社区> 问答> 正文

mysql报错InnoDB: Error: semaphore wait has lasted > 600 seconds异常重启

InnoDB: Warning: a long semaphore wait:
--Thread 140438005929728 has waited at buf0flu.cc line 1062 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0x7fc90f447e40 created in file buf0buf.cc line 1069
a writer (thread id 140438047889152) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file buf0flu.cc line 1056
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/row/row0row.cc line 815
InnoDB: Warning: a long semaphore wait:
--Thread 140436965275392 has waited at row0upd.cc line 2354 for 241.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7fc4f5284140 created in file buf0buf.cc line 1069
a writer (thread id 140436965275392) has reserved it in mode wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file row0sel.cc line 4138
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/row/row0upd.cc line 2354
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0

=====================================

2017-06-01 13:23:31 7fba49353700 INNODB MONITOR OUTPUT

Per second averages calculated from the last 29 seconds

BACKGROUND THREAD

srv_master_thread loops: 1197798 srv_active, 0 srv_shutdown, 285 srv_idle

srv_master_thread log flush and writes: 1198083

SEMAPHORES

OS WAIT ARRAY INFO: reservation count 1063799
--Thread 140438005929728 has waited at buf0flu.cc line 1062 for 247.00 seconds the semaphore:
S-lock on RW-latch at 0x7fc90f447e40 created in file buf0buf.cc line 1069
a writer (thread id 140438047889152) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file buf0flu.cc line 1056
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/row/row0row.cc line 815
--Thread 140436965275392 has waited at row0upd.cc line 2354 for 247.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7fc4f5284140 created in file buf0buf.cc line 1069
a writer (thread id 140436965275392) has reserved it in mode wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Last time read locked in file row0sel.cc line 4138
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/row/row0upd.cc line 2354
--Thread 140437984950016 has waited at dict0stats.cc line 2388 for 246.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437388711680 has waited at row0undo.cc line 298 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437959976704 has waited at row0undo.cc line 298 for 239.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437959444224 has waited at row0undo.cc line 298 for 237.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437914982144 has waited at row0undo.cc line 298 for 237.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437962905344 has waited at row0undo.cc line 298 for 235.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437421192960 has waited at row0undo.cc line 298 for 235.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437421725440 has waited at row0undo.cc line 298 for 234.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437443024640 has waited at row0undo.cc line 298 for 233.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437439297280 has waited at row0undo.cc line 298 for 233.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437431576320 has waited at row0undo.cc line 298 for 233.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437382588160 has waited at row0undo.cc line 298 for 232.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437391107840 has waited at row0undo.cc line 298 for 232.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437391906560 has waited at row0undo.cc line 298 for 231.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437399893760 has waited at row0undo.cc line 298 for 229.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437378062080 has waited at row0undo.cc line 298 for 229.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437959177984 has waited at row0undo.cc line 298 for 225.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437395367680 has waited at row0undo.cc line 298 for 221.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437420660480 has waited at row0undo.cc line 298 for 221.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437946664704 has waited at row0undo.cc line 298 for 220.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437393770240 has waited at row0undo.cc line 298 for 220.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437922170624 has waited at row0undo.cc line 298 for 218.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437963437824 has waited at row0undo.cc line 298 for 217.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437386049280 has waited at row0undo.cc line 298 for 216.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437923768064 has waited at row0undo.cc line 298 for 216.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437960775424 has waited at row0undo.cc line 298 for 215.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140438058379008 has waited at srv0srv.cc line 2006 for 214.00 seconds the semaphore:
X-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437402289920 has waited at row0undo.cc line 298 for 213.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437423056640 has waited at row0undo.cc line 298 for 213.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437444089600 has waited at row0undo.cc line 298 for 208.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437406816000 has waited at row0undo.cc line 298 for 207.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437443290880 has waited at row0undo.cc line 298 for 207.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437400426240 has waited at row0undo.cc line 298 for 204.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436961548032 has waited at row0undo.cc line 298 for 204.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437407614720 has waited at row0undo.cc line 298 for 200.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436961281792 has waited at row0undo.cc line 298 for 197.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437920573184 has waited at row0undo.cc line 298 for 190.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437947197184 has waited at row0undo.cc line 298 for 189.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437410543360 has waited at row0undo.cc line 298 for 186.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436962612992 has waited at row0undo.cc line 298 for 178.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437933352704 has waited at row0undo.cc line 298 for 177.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436960216832 has waited at row0undo.cc line 298 for 177.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437962639104 has waited at row0undo.cc line 298 for 175.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437383919360 has waited at row0undo.cc line 298 for 175.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437408679680 has waited at row0undo.cc line 298 for 175.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437394036480 has waited at row0undo.cc line 298 for 175.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437958379264 has waited at row0undo.cc line 298 for 174.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437382321920 has waited at row0undo.cc line 298 for 174.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437427316480 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437398562560 has waited at row0undo.cc line 298 for 170.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437955983104 has waited at row0undo.cc line 298 for 167.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436959151872 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437934683904 has waited at row0undo.cc line 298 for 166.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437413738240 has waited at row0undo.cc line 298 for 164.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436962080512 has waited at row0undo.cc line 298 for 145.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437928826624 has waited at row0undo.cc line 298 for 145.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437424387840 has waited at row0undo.cc line 298 for 142.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437403088640 has waited at row0undo.cc line 298 for 142.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437442758400 has waited at row0undo.cc line 298 for 141.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437387646720 has waited at row0undo.cc line 298 for 140.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437940008704 has waited at row0undo.cc line 298 for 140.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437418796800 has waited at row0undo.cc line 298 for 139.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437383653120 has waited at row0undo.cc line 298 for 138.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437382854400 has waited at row0undo.cc line 298 for 138.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437408945920 has waited at row0undo.cc line 298 for 136.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437422524160 has waited at row0undo.cc line 298 for 134.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437387912960 has waited at row0undo.cc line 298 for 134.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437928294144 has waited at row0undo.cc line 298 for 133.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437392971520 has waited at row0undo.cc line 298 for 132.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437378328320 has waited at row0undo.cc line 298 for 131.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437944801024 has waited at row0undo.cc line 298 for 131.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437416134400 has waited at row0undo.cc line 298 for 131.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437926696704 has waited at row0undo.cc line 298 for 130.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437379925760 has waited at row0undo.cc line 298 for 129.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437927495424 has waited at row0undo.cc line 298 for 129.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437950658304 has waited at row0undo.cc line 298 for 127.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437444355840 has waited at row0undo.cc line 298 for 127.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437437433600 has waited at row0undo.cc line 298 for 126.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437403887360 has waited at row0undo.cc line 298 for 125.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437395633920 has waited at row0undo.cc line 298 for 124.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437955716864 has waited at row0undo.cc line 298 for 120.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437415601920 has waited at row0undo.cc line 298 for 118.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437380990720 has waited at row0undo.cc line 298 for 118.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437431310080 has waited at row0undo.cc line 298 for 116.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436963677952 has waited at row0undo.cc line 298 for 114.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437922436864 has waited at row0undo.cc line 298 for 114.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437961574144 has waited at row0undo.cc line 298 for 114.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437918709504 has waited at row0undo.cc line 298 for 113.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437380458240 has waited at row0undo.cc line 298 for 110.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437923235584 has waited at row0undo.cc line 298 for 109.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437382055680 has waited at row0undo.cc line 298 for 109.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437392705280 has waited at row0undo.cc line 298 for 106.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437430777600 has waited at row0undo.cc line 298 for 106.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437409478400 has waited at row0undo.cc line 298 for 104.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437914715904 has waited at row0undo.cc line 298 for 103.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437923501824 has waited at row0undo.cc line 298 for 103.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437963704064 has waited at row0undo.cc line 298 for 97.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437379127040 has waited at row0undo.cc line 298 for 95.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437441427200 has waited at row0undo.cc line 298 for 94.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437401224960 has waited at row0undo.cc line 298 for 94.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436962346752 has waited at row0undo.cc line 298 for 93.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437379393280 has waited at row0undo.cc line 298 for 92.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437932021504 has waited at row0undo.cc line 298 for 89.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436971398912 has waited at row0undo.cc line 298 for 89.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437921105664 has waited at row0undo.cc line 298 for 87.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437428647680 has waited at row0undo.cc line 298 for 85.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437926962944 has waited at row0undo.cc line 298 for 85.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437925631744 has waited at row0undo.cc line 298 for 83.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436964476672 has waited at row0undo.cc line 298 for 83.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437413472000 has waited at row0undo.cc line 298 for 82.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436972730112 has waited at row0undo.cc line 298 for 82.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437953054464 has waited at row0undo.cc line 298 for 82.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437424654080 has waited at row0undo.cc line 298 for 80.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437436634880 has waited at row0undo.cc line 298 for 76.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437395900160 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140436960483072 has waited at row0undo.cc line 298 for 73.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437417199360 has waited at row0undo.cc line 298 for 72.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437384718080 has waited at row0undo.cc line 298 for 72.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437963171584 has waited at row0undo.cc line 298 for 64.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437427848960 has waited at row0undo.cc line 298 for 64.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437935748864 has waited at row0undo.cc line 298 for 64.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437957048064 has waited at row0undo.cc line 298 for 63.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437957314304 has waited at row0undo.cc line 298 for 62.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437949593344 has waited at row0undo.cc line 298 for 59.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/build/sb_0-18153926-1457023138.3/mysql-5.6.30/storage/innobase/dict/dict0stats.cc line 2388
--Thread 140437442492160 has waited at row0undo.cc line 298 for 57.00 seconds the semaphore:
S-lock on RW-latch at 0x1398f00 created in file dict0dict.cc line 1066
a writer (thread id 140437984950016) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 298
Last time write locked in file /export/home/pb2/bu

展开
收起
丶阿狸不哭 2017-06-01 15:02:44 6318 0
2 条回答
写回答
取消 提交回答
  • 解决了吗

    2019-07-17 21:14:42
    赞同 展开评论 打赏
  • 最后报错貌似看不到了

    FILE I/O

    I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
    I/O thread 1 state: waiting for completed aio requests (log thread)
    I/O thread 2 state: waiting for completed aio requests (read thread)
    I/O thread 3 state: waiting for completed aio requests (read thread)
    I/O thread 4 state: waiting for completed aio requests (read thread)
    I/O thread 5 state: waiting for completed aio requests (read thread)
    I/O thread 6 state: waiting for completed aio requests (read thread)
    I/O thread 7 state: waiting for completed aio requests (read thread)
    I/O thread 8 state: waiting for completed aio requests (read thread)
    I/O thread 9 state: waiting for completed aio requests (read thread)
    I/O thread 10 state: waiting for completed aio requests (write thread)
    I/O thread 11 state: waiting for completed aio requests (write thread)
    I/O thread 12 state: waiting for completed aio requests (write thread)
    I/O thread 13 state: waiting for completed aio requests (write thread)
    I/O thread 14 state: waiting for completed aio requests (write thread)
    I/O thread 15 state: waiting for completed aio requests (write thread)
    I/O thread 16 state: waiting for completed aio requests (write thread)
    I/O thread 17 state: waiting for completed aio requests (write thread)
    Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 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
    3228795 OS file reads, 79307426 OS file writes, 53415531 OS fsyncs

    0.12 reads/s, 16384 avg bytes/read, 18.57 writes/s, 18.57 fsyncs/s

    INSERT BUFFER AND ADAPTIVE HASH INDEX

    Ibuf: size 1, free list len 7343, seg size 7345, 221744 merges
    merged operations:
    insert 760128, delete mark 30713, delete 10041
    discarded operations:
    insert 0, delete mark 0, delete 0
    Hash table size 151384511, node heap has 0 buffer(s)

    0.00 hash searches/s, 125235.99 non-hash searches/s

    LOG

    Log sequence number 1211209887140
    Log flushed up to 1211209886822
    Pages flushed up to 1211199528202
    Last checkpoint at 1211199528202
    0 pending log writes, 0 pending chkp writes

    21554306 log i/o's done, 18.57 log i/o's/second

    BUFFER POOL AND MEMORY

    Total memory allocated 70330089472; in additional pool allocated 0
    Dictionary memory allocated 3050346
    Buffer pool size 4194296
    Free buffers 612428
    Database pages 3581868
    Old database pages 1322105
    Modified db pages 6988
    Pending reads 0
    Pending writes: LRU 0, flush list 2, single page 0
    Pages made young 21711, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 3221371, created 360497, written 48025498
    0.12 reads/s, 0.17 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 3581868, unzip_LRU len: 0

    I/O sum[0]:cur[0], unzip sum[0]:cur[0]

    INDIVIDUAL BUFFER POOL INFO

    ---BUFFER POOL 0
    Buffer pool size 524287
    Free buffers 74538
    Database pages 449749
    Old database pages 166003
    Modified db pages 1559
    Pending reads 0
    Pending writes: LRU 0, flush list 2, single page 0
    Pages made young 2734, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 404393, created 45356, written 10818227
    0.00 reads/s, 0.02 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 449749, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 1
    Buffer pool size 524287
    Free buffers 75464
    Database pages 448823
    Old database pages 165664
    Modified db pages 675
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2696, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 403809, created 45014, written 4014919
    0.02 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 448823, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 2
    Buffer pool size 524287
    Free buffers 73881
    Database pages 450406
    Old database pages 166244
    Modified db pages 636
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2662, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 403732, created 46674, written 3996952
    0.02 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 450406, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 3
    Buffer pool size 524287
    Free buffers 76810
    Database pages 447477
    Old database pages 165181
    Modified db pages 947
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2910, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 402913, created 44564, written 8574913
    0.02 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 447477, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 4
    Buffer pool size 524287
    Free buffers 77520
    Database pages 446767
    Old database pages 164920
    Modified db pages 770
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2546, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 402432, created 44335, written 6831057
    0.02 reads/s, 0.05 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 446767, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 5
    Buffer pool size 524287
    Free buffers 81699
    Database pages 442588
    Old database pages 163359
    Modified db pages 677
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2803, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 398192, created 44396, written 4150831
    0.00 reads/s, 0.02 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 442588, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 6
    Buffer pool size 524287
    Free buffers 75357
    Database pages 448930
    Old database pages 165700
    Modified db pages 907
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2625, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 404076, created 44854, written 4554463
    0.02 reads/s, 0.00 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 448930, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    ---BUFFER POOL 7
    Buffer pool size 524287
    Free buffers 77159
    Database pages 447128
    Old database pages 165034
    Modified db pages 817
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 2735, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 401824, created 45304, written 5084136
    0.00 reads/s, 0.07 creates/s, 0.00 writes/s
    Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 447128, unzip_LRU len: 0

    I/O sum[0]:cur[0], unzip sum[0]:cur[0]

    ROW OPERATIONS

    0 queries inside InnoDB, 0 queries in queue
    2 read views open inside InnoDB
    Main thread process no. 7890, id 140438058379008, state: enforcing dict cache limit
    Number of rows inserted 25334846, updated 19974009, deleted 3278941, read 1085167903960

    14.57 inserts/s, 9.70 updates/s, 0.15 deletes/s, 630031.82 reads/s

    END OF INNODB MONITOR OUTPUT

    InnoDB: ###### Diagnostic info printed to the standard error stream
    InnoDB: Error: semaphore wait has lasted > 600 seconds
    InnoDB: We intentionally crash the server, because it appears to be hung.
    2017-06-01 13:35:18 7fba49d54700 InnoDB: Assertion failure in thread 140438079358720 in file srv0srv.cc line 1756
    InnoDB: We intentionally generate a memory trap.
    InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
    InnoDB: If you get repeated assertion failures or crashes, even
    InnoDB: immediately after the mysqld startup, there may be
    InnoDB: corruption in the InnoDB tablespace. Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
    InnoDB: about forcing recovery.
    05:35:18 UTC - mysqld got signal 6 ;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help
    diagnose the problem, but since we have already crashed,
    something is definitely wrong and this may fail.

    key_buffer_size=8388608
    read_buffer_size=2097152
    max_used_connections=1221
    max_threads=2000
    thread_count=1221
    connection_count=1221
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8225785 K bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    Thread pointer: 0x0
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    stack_bottom = 0 thread_stack 0x40000
    /app/mysql/bin/mysqld(my_print_stacktrace+0x35)[0x910535]
    /app/mysql/bin/mysqld(handle_fatal_signal+0x3d8)[0x6755e8]
    /lib64/libpthread.so.0[0x31b3e0f710]
    /lib64/libc.so.6(gsignal+0x35)[0x31b3a32625]
    /lib64/libc.so.6(abort+0x175)[0x31b3a33e05]
    /app/mysql/bin/mysqld[0x9e53bd]
    /lib64/libpthread.so.0[0x31b3e079d1]
    /lib64/libc.so.6(clone+0x6d)[0x31b3ae89dd]
    The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
    information that should help you find out what is causing the crash.
    170601 13:35:18 mysqld_safe Number of processes running now: 0
    170601 13:35:18 mysqld_safe mysqld restarted


    没人吗?问下怎么解决

    2019-07-17 21:14:42
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像