- 博客(6)
- 收藏
- 关注
RSS订阅原创 基于GTID搭建主从
1 停止iptables （主从）service iptables stopchkconfig iptables off2 添加配置文件 （主从)------主库-------------------------log-bin=mysql-bin server-id=553306gtid-mode=on enforce-gtid-consistency=truelo
2015-12-22 23:32:45
1263
原创 MySQL主从基本搭建
1 停止iptables （主从）service iptables stopchkconfig iptables off2 添加配置文件 （主从)log-bin=mysql-bin server-id=/etc/init.d/mysql restart3 创建用户 （主库）GRANT REPLICATION SLAVE ON *.* to 'daoslave'@'%' id
2015-12-15 23:22:42
655
1
原创 10053 事件浅析
1 session 级别设置eventSQL> ALTER SESSION SET EVENTS='10053 trace name context forever, level 1';Session altered.2 执行语句SQL> select /*+10053 test*/* 2 from dao_objects1 t1 ,dao_objects2 t2
2015-12-06 21:12:53
2611
原创 MYSQL— perror 错误码详情
[root@localhost ~]# cat test_nothread.py import paramikoimport threadingimport osdef ssh2(ip,username,passwd,cmd): file_path='/root/perror.log' logfile=file(file_path,'a') try:
2015-12-04 21:27:17
114018
13
原创 percona默认安装目录研究
[root@localhost ~]# rpm -qa |grep PerPercona-Server-client-56-5.6.27-rel75.0.el6.x86_64Percona-Server-shared-56-5.6.27-rel75.0.el6.x86_64Percona-XtraDB-Cluster-shared-55-5.5.41-25.11.853.el6.x86_64
2015-12-02 08:10:53
1828
原创 innochecksum使用
[root@localhost mysql]# innochecksum InnoDB offline file checksum utility.innochecksum Ver 5.6.27-75.0, for Linux (x86_64)Copyright (c) 2009-2015 Percona LLC and/or its affiliatesCopyright (c) 20
2015-12-01 12:22:45
4942
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人