[求助]MySQL crach
4月30日 20:34:27启动jboss服务
MySQL的hostname.err文件里面一直在打印警告信息。
InnoDB: Warning: a long semaphore wait:
--Thread 3204160416 has waited at btr0cur.c line 366 for 242.00 seconds the semaphore:
S-lock on RW-latch at 0xf6109cbc created in file dict0dict.c line 3706
a writer (thread id 3482712992) has reserved it in mode exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0cur.c line 606
Last time write locked in file btr0cur.c line 359
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
此种信息一致在打印 3天打印了56条
PS:公司对外网数据有控制,每次外发数据不能超过限制,所以每次只能发几百个字,我分楼阐述信息。