GhostXu. 2021-06-01 18:48 采纳率: 0%
浏览 76

MySQL集群日志一直报警，提示连接超时，且报警时数据库写入性能很慢，求解

数据库版本：MySQL 5.7.29

警告日志如下：

2021-06-01T07:31:22.284817Z 0 [Warning] WSREP: Failed to report last committed 1079198639, -110 (Connection timed out)
2021-06-01T07:36:55.200317Z 0 [Warning] WSREP: Failed to report last committed 1079234253, -110 (Connection timed out)
2021-06-01T07:42:48.571254Z 0 [Warning] WSREP: Failed to report last committed 1079270292, -110 (Connection timed out)
2021-06-01T07:53:49.342484Z 0 [Warning] WSREP: Failed to report last committed 1079341904, -110 (Connection timed out)
2021-06-01T07:58:37.615106Z 0 [Warning] WSREP: Failed to report last committed 1079373858, -110 (Connection timed out)
2021-06-01T08:09:21.168413Z 0 [Warning] WSREP: Failed to report last committed 1079442824, -110 (Connection timed out)
2021-06-01T08:14:52.744521Z 0 [Warning] WSREP: Failed to report last committed 1079476984, -110 (Connection timed out)
2021-06-01T08:20:05.343405Z 0 [Warning] WSREP: Failed to report last committed 1079511918, -110 (Connection timed out)
2021-06-01T08:21:00.267930Z 0 [Warning] WSREP: Failed to report last committed 1079516012, -110 (Connection timed out)
2021-06-01T08:26:10.508639Z 0 [Warning] WSREP: Failed to report last committed 1079553076, -110 (Connection timed out)
2021-06-01T08:31:12.158566Z 0 [Warning] WSREP: Failed to report last committed 1079587545, -110 (Connection timed out)
2021-06-01T08:31:15.344613Z 0 [Warning] WSREP: Failed to report last committed 1079587546, -110 (Connection timed out)
2021-06-01T08:31:30.967206Z 0 [Warning] WSREP: Failed to report last committed 1079587600, -110 (Connection timed out)
2021-06-01T08:37:04.798784Z 53060149 [ERROR] Invalid (old?) table or database name '#innodb_temp'
2021-06-01T08:37:05.027493Z 53060187 [ERROR] Invalid (old?) table or database name '#innodb_temp'
2021-06-01T08:37:06.627930Z 0 [Warning] WSREP: Failed to report last committed 1079628241, -110 (Connection timed out)
2021-06-01T08:53:55.831331Z 0 [Warning] WSREP: Failed to report last committed 1079740261, -110 (Connection timed out)
2021-06-01T08:54:42.893846Z 0 [Warning] WSREP: Failed to report last committed 1079745363, -110 (Connection timed out)
2021-06-01T09:16:09.647397Z 0 [Warning] WSREP: Failed to report last committed 1079874823, -110 (Connection timed out)

求大神指点

  • 写回答

2条回答 默认 最新

  • CSDN专家-赖老师（软件之家） 2021-06-01 18:51
    关注

    排除一下是不是网络问题，还是内存不足的原因。

    评论

报告相同问题？

悬赏问题

  • ¥15 加热介质是液体，换热器壳侧导热系数和总的导热系数怎么算
  • ¥15 想问一下树莓派接上显示屏后出现如图所示画面，是什么问题导致的
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥15 cmd cl 0x000007b
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差（基于双目相机）
  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败