脚踏实地、勇往直前！
发布时间：2018-06-11 20:16:29
1.创建表并写入测试数据create table tb_rank_score( city varchar(20), score int);insert into tb_rank_score values('sz',89);insert into tb_rank_score values('sz',76);insert into tb_rank_score values('sz',50);insert into tb_rank_score values('sz',89);insert into tb_rank_score .........【阅读全文】
发布时间：2018-05-19 09:01:42
从库报错,错误号为1062,违反唯一性约束mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Mast.........【阅读全文】
发布时间：2018-04-28 11:22:53
1.解压[root@pxc01 soft]# tar -xvf sysbench-0.4.12.14.tar.gz[root@pxc01 soft]# cd sysbench-0.4.12.142.运行autogen.sh[root@pxc01 sysbench-0.4.12.14]#./autogen.shautomake 1.10.x (aclocal) wasn't found, exiting解决办法:[root@pxc01 sysbench-0.4.12.14]# yum install automake[root@pxc01 sysbench.........【阅读全文】
发布时间：2018-01-19 14:21:31
今天搭建一个主从，启动同步报如下信息:180118 17:20:37 [ERROR] Slave SQL: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE) for operation 'concat'' on query. Default database: 'rdcs_jgs'. Query: 'insert into jgs_bj_lo.........【阅读全文】
发布时间：2017-09-19 18:54:47
1.安装相应的依赖包yum install -y cmake make gcc gcc-c++ ncurses-devel2.解压缩安装包(源码tar安装包在官网下载)tar -zxvf mysql-5.7.19.tar.gztar -zxvf mysql-boost-5.7.19.tar.gzcd mysql-5.7.19 -- 进入到解压目录mkdir debug -- 创建临时目录3.cmake(红色标.........【阅读全文】
