db由myisam修改为innodb引擎后,运行了1天,夜里突然收到警报,mysql down了
日志里面大部分报警信息如下:
InnoDB: Warning: a long semaphore wait:
--Thread 140684989069056 has waited at row0purge.cc line 720 for 271.00 seconds the semaphore:
--Thread 140684989069056 has waited at row0purge.cc line 720 for 273.00 seconds the semaphore:
InnoDB: Warning: a long semaphore wait:
--Thread 140684989069056 has waited at row0purge.cc line 720 for 328.00 seconds the semaphore:
见附件
解决方法:在my.cnf中加入:
innodb_adaptive_hash_index = 0 问题即可解决
摘之:
http://hcymysql.blog.51cto.com/5223301/1347504
心得:迁移网站的时候,领导要求将mysql5.5升级到mysql5.6 ,结果造成网站的某些功能不可用,所以在进行mysql 大版本升级的时候,要多测试,不要那么的想当然
阅读(3474) | 评论(0) | 转发(0) |