BlockC DBA

Data &BlockChain and Security Notes Share Everything

Last_Errno: 1594 the master's binary log is corrupted Last_SQL_Errno: 1062

mysql主从复制不同步异常 查看从库同步状态,发现Slave_SQL_Running: No状态异常,主备库已经不再同步,初步怀疑是断电倒是binlog的问题 mysql> show slave status\G *************************** 1. row **...

2017-10-13 15:06:28

阅读数:322

评论数:0

ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1'

测试环境 1.MYSQL版本 +------------+ | version() | +------------+ | 5.7.18-log | +------------+ 2.建表语句 mysql> show create table M; ...

2017-08-22 11:31:49

阅读数:267

评论数:0

ERROR 1366 (HY000): Incorrect integer value: 'False' for column 'bd_ip' at row 1943555

更改MySQL表的属性,前期没有考虑到性能问题,将存IP端的列设置了varchar类型,由于数据量询量不断增大,使用char类型存储IP地址不仅占用空间而且影响MySQL查询效率,在多表jion时性能差异就更明显了 ,所以存储ip用int类型,int只占用4个字节,因为省空间,空间就是效率,选用...

2017-08-16 13:52:00

阅读数:306

评论数:0

ERROR 1366 (HY000): Incorrect string value: '\ ' for column ' ' at row 1

概述: 01.版本 MYSQL 5.6 mysql> select version(); +-----------+ | version() | +-----------+ | 5.6.29 | +-----------+ 02.操作系统版本 [root@mynode1 ~]#...

2016-05-25 16:39:19

阅读数:965

评论数:0

A slave with the same server_uuid as this slave has connected to the master

Got fatal error 1236 from master when reading data from binary log: 'A slave with the same server_uuid as this slave has connected to the master; my...

2016-05-24 05:43:34

阅读数:2388

评论数:0

解决 libev.so.4()(64bit) is needed by percona-xtrabackup-2.3.4-1.el6.x86_64案例

在mysql主从同步时经常会用到Xtra, XtraBackup可以说是一个相对完美的免费开源数据备份工具,支持在线无锁表同步复制和可并行高效率的安全备份恢复机制相比mysqldump来说优势较大, 在RHEL6中安装XtraBackup时发生缺少依赖包的现象,本人针对缺少依赖包现象进行解决 1...

2016-05-17 05:33:03

阅读数:10956

评论数:0

MYSQL一个简单的问题 error: Failed dependencies: MySQL-server conflicts with mysql-server

RHEL6.7 安装MySQL-server-5.6.28时发现有冲突,报错已经很明显,是RHEL6.7安装时默认自带版本与现有安装版本冲突 [root@mdb mysdata]# rpm -ivh --replacefiles MySQL-s*.rpm warning: MySQL-serve...

2016-03-17 11:18:35

阅读数:1713

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭