EVISWANG的博客

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

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

一. 问题概述：      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

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

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: [

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

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

[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.

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

问题描述：[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

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

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

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/

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

一、问题描述二进制安装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...