MySQL

(This article is no longer syncing updates, see GitHub for the latest code)Log analysis plays a very important role in the troubleshooting and performance analysis of web systems. At present, the open source Elk system is a mature and powerful

I. Why a backup is requiredIn a real-world production environment, it is a mistake to delete the operation, the hardware damage will result in the data is not available, this time we need to backup to achieve disaster recovery. Hardware-level

1. After modifying my.cnf, perform service mysql restart Restart database failed service MySQL restartshutting down MySQL. SUCCESS! starting MySQL ... error! The server quit without updating PID file (/usr/local/mysql/data/vm_0_12_centos.pid)2.

To create an index on a table's fieldsIndexes are like catalogs of books, and if indexed on a field, you can speed up querying data when indexed. 1 Creating a primary key indexQuerying the contents of the database, the primary key query is the

Take the Win7 system, MySQL version 5.5.57 as an example: View the port number of the native MySQL (default is 3306) Open a DOS window Win+r Open the Run interface input cmd or enter CMD in the Start menu search box and

[Client]Port = 3306Socket =/tmp/mysql.sock[Mysqld]Port = 3306Socket =/tmp/mysql.sockBasedir =/usr/local/mysqlDataDir =/data/mysqlPid-file =/data/mysql/mysql.piduser = MySQLBind-address = 0.0.0.0Server-id = 1 #表示是本机的序号为1, which is generally the

One, MySQL free installation version of the installation: 1, MySQL is divided into two versions: Install the MSI format file of the board, click Next directly, then you can install Free installation version of the ZIP format, directly

The reason is that the permission is not opened1. The command line enters MySQL (assuming root user's password is also root) Mysql–uroot–proot 2. Use MySQL database using MySQL; 3. Grant all privileges on * * to ' root ' @ '% ' identified by ' root '

[Email protected] ~]# CD/USR/LOCAL/SRC[Email protected] src]# tar zxvf percona-xtrabackup-2.4.4-linux-x86_64.tar.gz-c/usr/local[Email protected] src]# cd/usr/local[Email protected] local]# MV Percona-xtrabackup-2.4.4-linux-x86_64/xtrabackup[Email

Day04First, manage the root user password1.1 Change Password1.2 Recover PasswordSecond, user authorization and REVOKE authority2.1 Licensing2.2 Revoke permissionsIII. installation of graphical management toolsFour-data backup and recovery-----full

Day06First, MySQL master-slave synchronizationSecond, the data read and write separationThird, MySQL optimization++++++++++++++++++++++++++++++++First, MySQL master-slave synchronization1.1 Introduction to Master-slave synchronization? Automatically

9.9.8 Querying data9.9.8.1 all data rows of a query table(1) Command Syntax:selectfromwhere(2) The following: View all data in the table WWNA. Entering a specified database query[email protected] 04:5152->use wwnDatabase changed[email protected] 04:5

MHA (Master high availability) is a relatively mature solution currently available in MySQL, MHA when monitoring the failure of the master node, the slave node with the most recent data is promoted to become the new Master node, during which MHA

In -type sub-query leads to traps: (Sweep less rows, not temporary tables, do not sort files quickly) title: In the Ecshop Mall table, query 6th items, (note, number 6th is a large column) the most intuitive: MySQL> SelectGoods_id,cat_id,goods_name

1: Remote database (D1) Data: Database User: Root, Database password: root, database IP intranet address 192.168.100.91, database port 3306localhost: IP 192.168.127.1Mode one: Use the Navicat client connection.2: First on the remote database D1 to

Transferred from: http://blog.csdn.net/atco/article/details/24259333DescriptionWhen you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space.mysql-bin.000001mysql-

Previously done a multi-instance MySQL on a single machine, this time separate to do, using two hosts.The host addresses used here are:master:192.168.214.135slave:192.168.214.128The two hosts already have MySQL installed, but two database data are

Mysql5.7.17 winx64.zip unzip version installation configuration graphic tutorial, 1.download mysql-5.7.17-winx64.zip; Link: https://pan.baidu.com/s/1tTqT2sn7cEaOwEvrQ-LrHg password: i444 2. decompress the package to a folder (for example

MariaDB binary installation, mariadb binary Download the binary installation package wget http://mirrors.neusoft.edu.cn/mariadb//mariadb-10.2.12/bintar-linux-x86_64/mariadb-10.2.12-linux-x86_64.tar.gz Create a mysql user and group useradd -r mysql

Ten practical and simple MySQL functions and ten mysql Functions Function 0. display the current time Command: select now (). Purpose: display the current time. Use Cases: default values such as creation time and modification time. Example: mysql>