EVISWANG的博客

[root@node1bak opt]# mysqldump -uroot -p'evis123' -S /data/3306/mysql.sock  -A -B  --lock-tables=0 >  /opt/evis_test.sql Error: Couldn't read status information for table cond_instances () mysqldump

[root@node1bak opt]# mysqldump -uroot -p'evis123' -S /data/3306/mysql.sock -A -B  >  /opt/evis_test.sql mysqldump: Got error: 1146: Table 'performance_schema.cond_instances' doesn't exist when using

mysql初始化的时候 [root@node1 mysql-5.5.32]# cd /application/mysql-5.5.32/scripts/ [root@node1 scripts]# ./mysql_install_db --basedir=/application/mysql-5.5.32/  --datadir=/application/mysql-5.5.32/data/

mysql> insert emp values ('sss',null,null,null); ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage

root@mysqlcentos01 evis]# mysqldump -uroot -S /tmp/mysql3306.sock -pevis123 test salary  -T . mysqldump: [Warning] Using a password on the command line interface can be insecure. Warning: A partial

问题描述： [root@mysqlcentos01 evis]# mysqldump -uroot -S /tmp/mysql3306.sock -pevis123 test salary  -T . mysqldump: [Warning] Using a password on the command line interface can be insecure. Warning: A

双slave第二个启动slave报错： root@localhost [(none)]>root@slave status \G; *************************** 1. row ***************************                Slave_IO_State:                    Master_Host: 10.1

[root@mysqlcentos01 bin]# masterha_check_repl --conf=/data/mhamanager/3306/log/mha.cnf   Fri Aug 25 16:37:25 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.

pxc节点:10.194.41.231 10.194.41.228 10.194.41.227 ha: 10.194.41.220 主 10.194.41.221 备 vip:10.194.41.199 一.安装keepalived 1.yum install keepalived 2.修改配置 主节点4上 vi /etc/keepalived/keepalived

导言 实验环境说明： OS版本 CentOS7 PXC版本 Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101.tar.gz Xtrabackup版本 percona-xtrabackup-24-2.4.7-2.el6.x86_64.rpm 服务器说明： 主机名称 IP 配置 用途 c1 10.194.41.231 1核

root@localhost [(none)]>reset master; Query OK, 0 rows affected (0.04 sec) root@localhost [(none)]> [root@mysqlcentos01 mysqlback]# mysql -S /tmp/mysql3306.sock -u root -p Enter password:  [

8 Optimization优化 8.10 Buffering and Caching 缓冲和缓存 8.10.1 InnoDB Buffer Pool Optimization 8.10.2 The MyISAM Key Cache 8.10.3 The MySQL Query Cache MySQL查询缓存 The querycache stores the text of a SEL

一. 问题概述：       PXC第三个节点起不来，启动报错如下：       [root@mysqlcentos03 local]# /usr/local/mysql/support-files/mysql.server  start  ERROR! MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lo

删除老版本： 查看安装包： [root@centos1 opt]# rpm -qa | grep -i mysql mysql-libs-5.1.73-7.el6.x86_64 mysql-server-5.1.73-7.el6.x86_64 zabbix-server-mysql-2.4.8-1.el6.x86_64 perl-DBD-MySQL-4.013-3.el6.x86_64

一、问题描述二进制安装MySQL5.5，初始化报错如下：[root@redhat01 mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql  --basedir=/usr/local/mysql --datadir=/data/mysql/mysql3306/dataInstalling MySQL system tables...