随笔分类 - mysql->工具使用相关
摘要:1.下载binlog2sql[root@localhost soft]#git clone https://github.com/danfengcao/binlog2sql.git[root@localhost soft]#cd binlog2sql[root@localhost soft]#pip
阅读全文
摘要:1.下载canal安装包:地址:https://github.com/alibaba/canal/releases2.解压解压安装包 [root@elasticsearch-010007081120 canal]# mkdir -p /home/middle/canal/[root@elastics
阅读全文
摘要:mysql版本:5.6 赋予权限报错:GRANT index,SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `db_payment`.* TO 'dev'@'%';ERROR 1558 (HY000): Column count of
阅读全文
摘要:下载地址: https://github.com/akopytov/sysbench/tree/1.0.20 1.解压unzip sysbench-1.0.zipmv sysbench-1.0 /opt/ 2.执行脚本[root@localhost sysbench-1.0]# ./autogen.
阅读全文
摘要:benchmarksql 在5.0版本去除了对MySQL的TPC-C测试支持,本文通过修改部分源码,让benchmarksql 5.0支持MySQL。1. 环境: CentOS 7.2 benchmarksql 5.0 Percona MySQL Server 5.7.192. 下载编译benchm
阅读全文
摘要:1.pt-slave-delay 手工设置从库的延迟时间,目的是让主库的应用按照设置的延迟时间进行在从库应用,原理是不停的停掉从库和启动从库 ./pt-slave-delay --delay=1m --interval=15s --run-time=10m --password=mysql u=ro
阅读全文
摘要:环境: OS:Centos 7 centos 7安装xtrabackup8.0.7 1.下载#8.0版本$ wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-8.0.4/binary/redhat/7/x86_6
阅读全文
摘要:执行psc的账号需要具有超级权限,否则会报错: Error creating triggers: 2019-11-27T09:56:16 DBD::mysql::db do failed: You do not have the SUPER privilege and binary logging
阅读全文
摘要:安装 [root@host01 percona]# tar -xvf percona-toolkit-3.0.3_x86_64.tar.gz[root@host01 percona]# mv percona-toolkit-3.0.3 /opt/[root@host01 percona-toolki
阅读全文