mysql 5.7不定期的hang住重启-问答-阿里云开发者社区-阿里云

开发者社区> daxi11> 正文

mysql 5.7不定期的hang住重启

2017-05-03 14:06:33 7885 1

线上一台mysql 5.7.17版本实例,系统centos 6.4 ,96G内存,SSD磁盘,buffer pool 60G,buffer pool instance 8,24 CPU。实例访问情况如下:
screenshot
不定期的夯住重启,每次状态都是一致,error log如下输出:
nnoDB: ###### Diagnostic info printed to the standard error stream
2017-05-01T19:21:24.095658+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139927055582976 has waited at buf0flu.cc line 1209 for 303.00 seconds the semaphore:
SX-lock on RW-latch at 0x7f448b83aa70 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0sel.cc line 3652
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/btr/btr0cur.cc line 299
2017-05-01T19:21:24.095746+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139927087052544 has waited at buf0flu.cc line 1209 for 303.00 seconds the semaphore:
SX-lock on RW-latch at 0x7f463e8eeb08 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0sel.cc line 3652
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/btr/btr0cur.cc line 315
2017-05-01T19:21:24.095798+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139921740433152 has waited at row0ins.cc line 2481 for 303.00 seconds the semaphore:
S-lock on RW-latch at 0x7f49d5fc2be8 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0ins.cc line 2481
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mtr0mtr.ic line 153
2017-05-01T19:21:24.095871+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139921726056192 has waited at row0ins.cc line 2481 for 303.00 seconds the semaphore:
S-lock on RW-latch at 0x7f49d5fc2be8 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0ins.cc line 2481
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mtr0mtr.ic line 153
2017-05-01T19:21:24.095917+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139921718867712 has waited at row0ins.cc line 2481 for 303.00 seconds the semaphore:
S-lock on RW-latch at 0x7f49d5fc2be8 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0ins.cc line 2481
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mtr0mtr.ic line 153
2017-05-01T19:21:24.095959+08:00 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139927097542400 has waited at buf0flu.cc line 1209 for 303.00 seconds the semaphore:
SX-lock on RW-latch at 0x7f49d5fc2be8 created in file buf0buf.cc line 1459
a writer (thread id 139928763602688) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0ins.cc line 2481
Last time write locked in file /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mtr0mtr.ic line 153
从日志看,是长时间的信号等待触发了重启,之前5.7.13版本也出现,升级到5.7.17还是一样。
最开始怀疑是系统信号集设置不够,从250 32000 32 128 调整到2500 3200000 3200 1280,
还是出现了重启。从日志中看都在等待139928763602688 线程,从日志的下文可以得到该线程只是一条简单的insert语句,并没有其他异常查询,而且每次夯住时的语句并不相同。此外该实例之前运行在5.5版本下,没出现过该问题。请问该问题应该如何处理?

取消 提交回答
全部回答(1)
  • themoment
    2019-07-17 21:07:57

    glibc内存分配 bug,升级glibc

    0 0
相关问答

17

回答

【大咖问答】对话PostgreSQL 中国社区发起人之一,阿里云数据库高级专家 德哥

阿里ACE 彭飞 2019-07-10 09:36:10 964427浏览量 回答数 17

162

回答

惊喜翻倍:免费ECS+免费环境配置~!(ECS免费体验6个月活动3月31日结束)

豆妹 2014-10-29 17:52:21 222953浏览量 回答数 162

8

回答

OceanBase 使用动画(持续更新)

mq4096 2019-02-20 17:16:36 333816浏览量 回答数 8

18

回答

阿里云开放端口权限

xcxx 2016-07-20 15:03:33 643050浏览量 回答数 18

38

回答

安全组详解,新手必看教程

我的中国 2017-11-30 15:23:46 256845浏览量 回答数 38

294

回答

Linux Bash严重漏洞修复紧急通知(已全部给出最终修复方案)

qilu 2014-09-25 13:26:50 431590浏览量 回答数 294

249

回答

阿里云LNAMP(Linux + Nginx + Apache + MySQL + PHP)环境一键安装脚本

云代维 2014-02-14 15:26:06 302573浏览量 回答数 249

40

回答

阿里云ecs从购买到环境搭建和建站!!(phpstudy一件包)

梦丫头 2014-07-29 20:51:49 162074浏览量 回答数 40

24

回答

【精品问答】python技术1000问(1)

问问小秘 2019-11-15 13:25:00 471305浏览量 回答数 24

2

回答

区域选择帮助

fanyue88888 2012-12-07 15:54:30 203990浏览量 回答数 2
+关注
0
文章
1
问答
推荐问答
相关电子书
更多
文娱运维技术
立即下载
《SaaS模式云原生数据仓库应用场景实践》
立即下载
《看见新力量:二》电子书
立即下载