随笔分类 - MySQL
摘要：环境：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.
阅读全文
摘要：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
阅读全文
摘要：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 版本
阅读全文
摘要：Mysql5.7 stop slave; set @@SESSION.GTID_NEXT='507e80e9 3648 11e9 aa70 fa163e77a52d:20173'; begin; commit; set GTID_NEXT='AUTOMATIC'; start slave; show
阅读全文
摘要：测试用 create table test(num1 varchar(10),num2 varchar(100),num3 varchar(10)); drop procedure test; DELIMITER ;; CREATE PROCEDURE test() BEGIN DECLARE y
阅读全文
摘要：有个小朋友修复从库，但是 后，报错信息如下 Could not execute Write_rows event on table hsfdssdb.mf_textannounce; Got error 1 from storage engine, Error_code: 1030; handler
阅读全文
摘要：参考 https://dev.mysql.com/doc/refman/8.0/en/insert optimization.html https://dev.mysql.com/doc/refman/8.0/en/optimizing innodb bulk data loading.html S
阅读全文
摘要：最简配置文件 [mysqld] port=3306 datadir=/mysql/data/ log_error=/mysql/data/mysql_error.log basedir=/usr/local/mysql/ 初始化 /usr/local/mysql/bin/mysqld --defau
阅读全文
摘要：环境 ：Percona Server for MySQL 5.5.18 1. 报错日志： 171212 19:59:58 [ERROR] Slave SQL: Query partially completed on the master (error on master: 1317) and wa
阅读全文
摘要：准备 yum install cmake yum install -y bison yum install -y libaio-devel yum install -y boost yum install gcc-c++ （不然cmake过程中会报错 ） CMake Error at /usr/cm
阅读全文
摘要：环境：Percona Server for MySQL 5.5.18 模拟三个Terminal，实现当引用锁定表的查询被杀死时，错误日志中出现的Got error 1 when reading table Terminal A mysql set session autocommit=0; Quer
阅读全文
摘要：现象 [ERROR] lines containing "Sort aborted" are present in the MySQL error log file. [Warning] Sort aborted : Out of memory (Needed 24 bytes) [ERROR] S
阅读全文
摘要：系统：Red Hat Enterprise Linux Server release 6.3 (Santiago) 数据库：Percona-Server-5.6.29-rel76.2-Linux.x86_64.ssl101.tar.gz ###1. 准备 ####libjemalloc librar
阅读全文
摘要：MySQL版本：Percona Server 5.6.29 OS：RHEL6.3 1. 安装出错 [mysql@oracle ~]$ /home/mysql/scripts/mysql_install_db user=mysql basedir=/home/mysql datadir=/mysql/
阅读全文
摘要：MySQL半同步安装以及参数 基于MySQL5.5 官档地址： Semisynchronous Replication Administrative Interface https://dev.mysql.com/doc/refman/5.5/en/replication semisync inte
阅读全文
摘要：适用于每天一个分区。。。不断加分区，导致分区不够用的情况 CREATE DEFINER=hehe@XXXXXX PROCEDURE p_auto_partition_day(IN databaseName VARCHAR(50),IN tableName VARCHAR(50),IN daynum
阅读全文
