1. MySQL master-Slave synchronization configuration 1.1. Basic informationDatabase master server ip:127.0.0.1Database from server ip:192.168.1.311.2. Primary server configuration file My.ini configuration (Master)[Mysqld]#打开日志 (the host needs to
The project needs to be backed up regularly, and the following are its own operating notes1. Check disk space # Df-hfilesystem Size used Avail use% mounted on/dev/vda1 40G 3.6G 34G 10%/tmpfs 16G 0 16G
Method 1: Use the Set password commandFirst log in to MySQL.Format:mysql> set password for user name @localhost = password (' new password ');Example:mysql> set password for [email protected] = password (' 123 ');Method 2: Use MysqladminFormat:
At the time of creationCREATE TABLE si (Id INT auto_increment)Automatic numbering, can not have more than one automatic column (can be automatically coded for you)If you add a column to it in a S11 form (this is not the same as inserting data)ALTER
Install two database version 5.7.1910.168.21.180 GSM1 Gsm1.localdomain10.168.21.181 gsm2 Gsm2.localdomainInstalling the SoftwareConfigure/ETC/MY.CNFBuild Library mysqld--defaults-file=/etc/my.cnf--initialize--user=mysqlStart
Download preparationphp:http://windows.php.net/downloads/releases/archives/apache:https://www.apachehaus.com/cgi-bin/download.plx#apache24vc09Get readyCreate folder under E-disk webserver for PHP + apache + mysql and www directoriesPut the
I. Periodic checklists and Analysis tablesThe syntax for the parse table is as follows:ANALYZE [LOCAL | No_write_to_binlog] TABLE tbl_name [, Tbl_name] ...This statement is used to analyze and store the keyword distribution of the table, and the
Description: mysql-bin.000001, mysql-bin.000002 files, such as the database operation log, such as update a table, or delete some data, even if the statement does not have matching data, the command will be stored in the log file, also includes the
1. Views ViewA view is a virtual table whose contents are defined by a query. A filter that defines a view can come from one or more tables or other views of the current or other database.Advantages of the View:① simplifies operations by defining
MyD is a file that stores data, and Myi is an index file.The index improves the query speed, reduces the speed of adding and deleting, not the more the better.Type of index:1, key, general index2. Unique key, single indexCREATE TABLE T12 (Name Char (
A brief introduction: Today we talk about research and development normsTwo specifications1 table1 Choosing the right character set and storage engine recommended InnoDB UTF8MB42 table name do not include MySQL keyword, conform to naming convention3
Telnet to the Linux server above MySQL, there are two minor errors:1:10,060 Error Server firewall on stateSetup-> shut down the firewall (sometimes you may not find the related settings and need to install the relevant management software)2: Host is
A classic multi-column index case, such as the title:
假设某个表有一个联合索引(c1,c2,c3,c4)一下——只能使用该联合索引的 c1,c2,c3 部分Awhere c1=x and c2=x and c4>x and c3=xB where c1=x and c2=x and c4=x order by c3C where c1=x and c4= x group by c3,c2D where c1=x and c5=x
The steps are as follows:First, downloadAddress: https://launchpad.net/test-db/employees-db-1/1.0.6Second, decompressionUnzip the downloaded files and store them in any directory, but for convenience, it is recommended to place them in a shorter
Today to help run the data found that SQL execution is very slow, well, according to the previous writing habits, and later with the architect to analyze the discussion, improved, the current record analysis is as followsFirst, the test table, SQL
My Computer system is a WIN10 64-bit system.I installed MySQL not less than 5 times, loaded and unloaded, unloaded and loaded, read the old articles and blogs, very grateful to bloggers for their selfless help, the following are the bloggers of the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service