摘要： 环境：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 阅读全文

摘要： Server 1 [mysqld] server configuration datadir=/data/s1 basedir=/mysql 5.7/ port=3306 socket=/s1.sock server_id=1 gtid_mode=ON enforce_gtid_consistenc 阅读全文

摘要： 1 [root@archsitdb203 ~] ip a 1: lo: mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope 阅读全文

摘要： Navicat 11 连MySQL 8.0.16 报 Client does not support authentication。。。。。。。。 解决： alter user 'fabu'@'%' identified with mysql_native_password by 'FuckWise 阅读全文

摘要： 官档原文，懒得翻译了 "https://dev.mysql.com/doc/refman/5.7/en/innodb locks set.html" INSERT sets an exclusive lock on the inserted row. This lock is an index re 阅读全文

摘要： 用XtraBackup对备份集进行apply log 的时候，卡在 xtrabackup 版本：2.4.3 InnoDB: Waited for 1535930 seconds for 128 pending reads 中了个BUG，乍一看现象是一样一样的。。。 只好升级xtrabackup 版本 阅读全文

摘要： "官网" "下载" 装包 yum y install make automake libtool pkgconfig libaio devel 编译安装 ./autogen.sh ./configure make j make install 官网给出的 "安装步骤" 漏了 这步，直接./confi 阅读全文

摘要： "Linux error numbers, straight from the horse's mouth. " define EPERM 1 / Operation not permitted / define ENOENT 2 / No such file or directory / defi 阅读全文