查询数据锁

select COUNT(1) from performance_schema.data_locks;

select * from performance_schema.data_lock_waits;

show status like 'innodb_row_lock_%';

删除指定日期以前的日志索引中binlog日志文件

purge master logs before '2023-11-21 00:00:00';

删除指定日志文件的日志索引中binlog日志文件

purge master logs to'mysql-bin.000022';

在binlog中查找指定信息

./mysqlbinlog --database=complaint-boot /www/server/data/mysql-bin.xxx|grep -B 4 x要查找的信息