摘要:
mysql版本:5.7.19 mysqlbinlog mysql bin.000154 mysql bin.000154.txt /home/mysql/mysql_tools/pt query digest type binlog mysql bin.000154.txt zzg.sql mysq 阅读全文
摘要:
已测试版本:5.5.18 OS :RHEL 6.3 前提:数据库无法启动,无备份,ibd文件还在! ibd文件还在! ibd文件还在! 背景:升级失败,undrop-for-innodb 只能读取ibdata 中的表的信息。 方法一 (无工具) 1. 在其他服务器安装相同版本的MySQL,建立空库y 阅读全文
摘要:
OS:RHEL6.3 MySQL:5.7.19 [root@mysql02]# mysql -uroot -p****** -h127.1 -e"SHOW ENGINE INNODB STATUS\G" | sed -n -e '/BUFFER POOL AND MEMORY/,/INDIVIDUA 阅读全文
摘要:
突然。。。有一天,某个库报错 ORA 1578 ORACLE data block corrupted (file 5, block 48353) 版本:11.2.0.3 Error: ORA 01578 (ORA 1578) Text: ORACLE data block corrupted (f 阅读全文
摘要:
Server version: 8.0.18 commercial MySQL Enterprise Server mysql SELECT FROM performance_schema.replication_group_members; + + + + + + + + | CHANNEL_NA 阅读全文
摘要:
Server version: 8.0.18 commercial MySQL Enterprise Server MySQL在8.0.13后支持在线切换single primary和multi primary两种模式 切换至单主模式 mysql select group_replication_s 阅读全文
摘要:
694BF-YUDBG-EAR69-BPRGB-ATQXH 阅读全文
摘要:
环境:RHEL6.3 MySQL:5.7.19 GTID:ON mysqlbinlog skip gtids=TRUE /mysql/binlog/mysql bin.000001 |mysql uroot pfuckwisedu h127.1 mysqlbinlog skip gtids=TRUE 阅读全文
摘要:
Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.' 版本:8.0. 阅读全文
摘要:
_ pstack 7359 pid.info pt pmp pid.info 阅读全文