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

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

摘要： 需要安装schedule模块，该模块网址： "https://pypi.org/project/schedule/" import schedule import time import sys def job(): print time.strftime("%Y %m %d %H:%M:%S", 阅读全文

摘要： 最简配置文件 [mysqld] port=3306 datadir=/mysql/data/ log_error=/mysql/data/mysql_error.log basedir=/usr/local/mysql/ 初始化 /usr/local/mysql/bin/mysqld --defau 阅读全文

摘要： Determine YARN and MapReduce Memory Configuration Settings "https://docs.hortonworks.com/HDPDocuments/HDP2/HDP 2.0.9.1/bk_installing_manually_book/con 阅读全文

摘要： 原因：内存不足，SWAP不足 创建分区文件，大小 4G [root@mysql05 ~]# dd if=/dev/zero of=/data/swapfile bs=1k count=4096000 4096000+0 records in 4096000+0 records out 4194304 阅读全文