MySQL

To create a MySQL group and users:-r-g mysql-s/bin/false MySQLTo create a related directory:mkdir -p/data/mysql/mysql3306/{data,logs,tmp}chown -R mysql.mysql/data/mysqlInitialize MySQL:LN -s/opt/mysql-5.7. -LINUX-GLIBC2.

Why does the master copy from? Master-slave replication allows the primary database of the MySQL database master server to replicate to one or more MySQL slave servers from the database, enabling real-time disaster preparedness for disaster

ZhuqzLinks: https://www.zhihu.com/question/19719997/answer/81930332Source: KnowCopyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please specify the source.Many people's first

First, Preface: The basic principle of reading and writing separationThe basic principle of MySQL's read-write separation is to have master (the primary database) respond to transactional operations,Let slave (from the database) respond to select

Pro-Test can be, recorded February 5, 2018 11:03:221,/etc/my.cnf [mysqld] Increase datadir =/DATA/NAS2,/etc/rc.d/init.d/mysql from "datadir=/data" revision to "Datadir=/data/nas" from "datadir_set=" to "datadir_set=1" 3, move/data directory from the

Master-Slave synchronization, the essence is the use of database logs, the main library data copy to the library, in essence, the use of data replication technology.This article outlines Basic configuration of the main library Basic

MySQL log is divided into error log, binary log, slow query log, query log 1. The error log can be used to view the file of the error log through the following command: Show variables like ' Log_error '; the above command can be used to locate the

The table was previously updated with SQL Server, UPDATE statement:Update a set a.xx= (select yy from B); Yes, I can.However, in MySQL, you cannot directly use the result of the set Select,UPDATE ecs_users_copySET ' user_name ' = (SELECT'

Knowledge Background:MySQL the default value of the maximum number of connections is 100, for a large number of concurrent connections of the database, when the connection request is greater than the default number of connections, there will be no

Backing Up the database#mysqldump database name > database backup name #mysqldump -a-u user name-p password database name > database backup name #mysqldump1. Export structure does not export data2. Export data does not export structure3. Export Data

Why to build an index In most cases, not using indexes, trying to improve performance by other means is a waste of time (from the inside of MySQL Technology Insider). How does the index raise the performance? The index can get

//Create a database (the end of MySQL statement in PHP is not added, because the MySQL tone in PHP can only execute one sentence at a time)Create Databasetestdatabase;//Select Database Usetestdatabase;//Create a data tableCreate TableTest_table

Bo Master Original, reproduced annotated Source:In the MySQL application, the scope of the query is a lot of time range as a condition for the scope of query, time range query hasMany kinds of writing, first summed up the Between....and ... How to

Bo Master Original, reproduced please indicate the source:The use of the IF () function in MySQL is similar to the three-mesh expression in Java, and is more useful, with the following syntax:if (EXPR1,EXPR2,EXPR3), if the value of EXPR1 is true,

Installation and configuration tutorial for mysql 5.7.20 \ 5.7.21 without installation, 5.7.205.7.21 Download and install mysql 5.7.20/5.7.21 for your reference. The specific content is as follows: 1. Download mysql, Select the operating system and

A Preliminary Study on MySQL statistics and estimation methods, and a preliminary study on mysql statistics   The statistical information in the database describes the data distribution in the table to varying degrees. The execution plan obtains the

Add, delete, modify, and query MySQL DML and DQL, dmldql Add, delete, modify, and query DML and DQL   SELECT * FROM grade -- Add insert -- Adds three data entries to the grade Table.Insert into grade (gradeID, gradeName) VALUES (4, '4 ');Insert into

Advanced query (1), advanced query ( Data TypeInteger intDecimal doubleHigh Precision --- Decimal)Corresponding to the type BigDecimal in Java String: nvarchar (32) varchar charChar: fixed-length string (once the length is set, the space of the

MySQL basic statement and MySQL statement Create a table If it is a keyword, use the key below the back quotation mark ''esc Create table [if not exists] table Name (Field 1 Data Type [constraints, indexes, comments],Field 2 Data Type [constraints,

Install MySql 5.7.21 in Linux. Preface MySQL is the most widely used database in Linux. This article will introduce the steps for installing MySql 5.7.21 in Linux, it has some reference and learning value for everyone's learning or work. I will not