MySQL

>>>>>>soft_wsx>>>>>>--Data backup and restore >> synchronous standby server--1, fully backing up the primary database--2, using a RESTORE DATABASE statement with a sandby clause to recover from a full backup of the primary database to build the

[Client]Port = 3306 #端口号Socket =/ryzc/mysql/data/mysql.sock #sock文件路径[Mysqld]Port = 3306Socket =/ryzc/mysql/data/mysql.sock # server-side sock file pathPid-file =/ryzc/mysql/data/localhost.pid # PID file storage pathDataDir =/ryzc/mysql/data # data

Bidirectional Association triggers//Increase delimiter// Create TriggerInsertdemo afterInsert onVaccine.demo forEach rowBeginif Not exists(Select * fromWechat.demowhereWechat.demo.id=New.id) ThenINSERT intoWechat.demo (wechat.demo. ' Name ',

MySQL supports a variety of data types, and the big nephew can be divided into three categories: numeric type, Time type, string type, and conforming type;Numeric type: Type Size Range (signed) Range (unsigned) Use

One: MySQL master-slave configuration environmentBuild MySQL master-slave on the same serverMysql-5.1.72-linux-i686-glibc23.tar.gzSecond: Building steps1. Download:  cd/usr/local/src; wget

Edit the configuration file for MySQL: My.ini (under MySQL installation directory).Open the configuration file, add: Skip-grant-tables on the last line of the file, and then save the exit.This means that the grant-tables does not start when you

Failure phenomena:　　Website access is slow.The database is RDS:CPU full, the connections are full, and the rest of the values are idle.Apache server: CPU normal, Io Normal, traffic alarm, memory full.　Solution Ideas:First, have not encountered this

A very useful mysql boot parameter ——--Skip-grant-tables. As the name implies, when you start MySQL, do not start the grant-tables, authorization table. What's the use of it? Of course it is useful to forget the administrator password.Add Skip-grant-

[Plain] view plaincopy # wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm --http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpmParsing host repo.mysql.com (repo.mysql.com) ... 23.4.241.142Connecting

Locate the MySQL configuration file, search for "bind-address", and find this line:bind-address = 127.0.0.1 in front add a #, comment out this line, save, restart MySQL.Remote access is available, and Telnet can discover that the port is also

MySQL master-slave replication and read/write separation2016.3.16 by linuxfan.cnEnvironment Introduction:Primary server (Master): 192.168.100.155Slave Server (slave1,slave2): 192.168.100.153-154Proxy Server (amoeba): 192.168.100.156App Client (APP):

MySQL Replication introduction MySQL replication is a MySQL server (slave) that replicates logs from another MySQL server (master) and then parses the logs and applies them to itself, similar to data Guard in Oracle.MySQL replication has those

1. mysql master-slave principle and application scenario MySQL's replication principle is very simple, summed up:Only one master can be set from each.After the master executes the SQL, log the binary log file (Bin-log).From the connection master,

When we need to back up the data in the database, we need to know how much disk size the database occupies, the capacity of the entire database can be queried through some SQL statements, or the capacity of the table can be viewed separately.1, to

I. Numeric type Integer type Bytes Range (signed) Range (unsigned) Use TINYINT 1 bytes (-128,127) (0,255) Small integer value SMALLINT 2 bytes (-32 768,32 767

Solve the MySQL connection error: Can't connect to MySQL server (10060) When you use the graphic interface management tool Navicat forMySQL to connect to the Mysql database, the following error occurs: Can't connect to MySQL server (10060) Cause:

Mysql (master/slave) master-slave replication principle and configuration details, mysqlslave 1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism

How much is the proper mysql tmp_table_size optimization and tmptablesize optimization? You can set the tmp_table_size option to increase the size of a temporary table, for example, a temporary table generated BY the advanced group by operation. If

Check whether mysql is successfully started (bat + bash), mysqlbash Many of my friends prefer windows. For more information, see the following code. Method 1: Skip @echo off for /f "usebackq" %%i in (`"tasklist|find /c "mysqld.exe""`) do ( set

Percona-Server-5.5.33-31.1 installation, perconaserver Installation 1. Download   Http://www.percona.com/downloads/Percona-Server-5.5/ Percona-Server-5.5.33-31.1     SelectBinary     SelectLinux SelectX86_64     Ii.