问题描述 MySQL 5.7.21 业务表无法访问,select 业务表直接导致mysql crash,errorlog 里记录 InnoDB: Page log sequence number 89266322606 is in the future! Current system log sequence number 89266322472. 此处为个人环境模拟复现的错误日志 2024-03-28T20:07:50.690100+08:00 0 InnoDB: Page log seq ...
故障解析丨一次死锁问题的解决 背景 业务端遇到报错为 "Deadlock found when trying to get lock; try restarting transaction" 则表明有死锁发生 名称 配置 数据库版本 GreatSQL 8.0.26 隔离级别 Read-Commited innodb status 日志 show engine innodb status\G *************************** 1. r ...