mysql gtid_mode ERROR 1786
在 mysql 5.7 执行 create table a1 select * from event;执行失败，失败原因：ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECT. 查看状...
写作热力图
加载中...
加载中...
少
多
2017
Innodb 和 Mysql 索引不一致
客户反馈建立索引时报错，具体错误如下: [ERROR] Table db/table contains 7 indexes inside InnoDB, which is different from the number of indexes 6 defined in the MySQL 查了...
mysql5.7.19 迁移数据库失败
在服务器的 mysql 版本是 mysq l5.7.19，迁移后 mysql 日志内容如下 重点是这里 2017-09-29T13:24:30.716454+08:00 60 [Warning] Timeout waiting for reply of binlog (file: mysql-bi...
Centos7安装 mysql 5.7 并配置主从复制
mysql 5.7安装安装rpm -ivh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm yum install mysql-community-server 启动systemctl enable mys...
编译安装PHP7
安装库yum install libxml2-devel gd-devel libmcrypt-devel libcurl-devel openssl-devel 下载wget -c http://be2.php.net/distributions/php-7.1.8.tar.gz 编译1.解压...