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

摘要： Mysql5.7 stop slave; set @@SESSION.GTID_NEXT='507e80e9 3648 11e9 aa70 fa163e77a52d:20173'; begin; commit; set GTID_NEXT='AUTOMATIC'; start slave; show 阅读全文

摘要： ``` [root@oracle ~] echo "hehe\"hehe" hehe"hehe [root@oracle ~] echo "hehe\`hehe" hehe`hehe [root@oracle ~] echo "hehe\\hehe" hehe\hehe [root@oracle ~ 阅读全文

摘要： Linux运行级别 0 halt (Do NOT set initdefault to this) 1 Single user mode 2 Multiuser, without NFS (The same as 3, if you do not have networking) 3 Full mu 阅读全文