MySQL performance analysis and explain usage knowledge is the main content of this article, and then let us through some practical examples to introduce the process, I hope to be able to help you.1. Use the Explain statement to view the results of
problem :The MySQL startup report is as follows---------Error 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2 )Scene :Docker creates a MySQL image, and after deletion, it is refactored again. But
This article refers to the MySQL website.The native system environment is: CentOS 7.0, minimized version;MySQL version that will be installed: V5.7 Community versionI. Summary1, the current MySQL only Community Edition (community) is free, the other
Run the script at timed intervals:1. Operationcrontab-eXX * * * * /bin/bash yourpath/mysqlbak.sh2. Open your own initiative to run the fileVi/etc/crontabAdditions such as the following are included in the etc. Let them run the task on their own
In a single query, MySQL can use only one index.
In a real project, a WHERE clause in an SQL statement typically contains multiple query conditions and is sorted, grouped, and so on.
Too many indexes in the table can affect insert and update
Database basic additions and deletions to change1. Increase - Add / Insert data,insert intoInsert which table, those columns, what values,statement:INSERT into table name (column 1, column 2, column 3)values ( value 1, value 2, value 3);Can not
First, MySQL master-slave Replication Introduction(1) MySQL master-slave replication through the logical Binlog log to the server to synchronize local, and then by the local thread to read the log inside the SQL statement, re-applied to the MySQL
1. The MyISAM Storage Engine index key length sum cannot exceed 1000 bytes. 2. The BLOB and text type columns can only create prefix indexes. 3. MySQL does not currently support function indexing. 4. MySQL cannot use an index when it is not equal to
Self-study for a period of time Java, these days to see some interview topics, just to take the previous MySQL database to turn over.Query Statement Writing order: Select–from-where-group By-having-order by-limit Query Statement execution order:
Get information about databases and tablesNormally a normal programmer or DBA would suddenly think of a series of questions when they hit the code: Who am I? What am I doing here? Where's my database? What about my watch? How do I create a table?
This article describes the I/O-related parameter configurations for the two storage engines of the InnoDB and MyISAM.1.InnoDB I/O related configurationInnoDB is a transactional storage engine that, in order to reduce the IO overhead incurred when
Causes of master-slave replication delays:(1) The main library is too many from the library, causing replication delays(2) The difference from the library hardware compared to the main library, resulting in replication delay(3) too many slow SQL
In spring, a sample of the MySQL database was added and hacked, very easy.File structureMAVEN's Pom.xml file, which contains several very important jar packages 4.0.0 MySpring myspring 0.0.1-SNAPSHOT MySpring myspring org.spring Framework
Recently the boss gave a demand, is to write a name of fuzzy query.The problem is simple, the difficulty is that the table has nearly 500W data.If you want to do Chinese fuzzy query, the efficiency is simply appalling.I looked up the information on
If there are multiple duplicate fields in table Test1Some of the data is completely duplicated, and we're going to get him out and then delete it.SELECT * from Test1 a WHERE (A.phone,a.name) in (select Phone,name to Test1 GROUP by Phone,name have
First, configure the MySQL database1, unzip the green version of MySQL, and renamed to mysql5.7, such asCompare the previous version of 5.6 with less data directory (storage) and My-default.ini files (configuration information)Second, installation
PRIMARY KEY Index?? The PRIMARY key index is only a unique index with the name PRIMARY. This means that a table can contain only one primary KEY because it is not possible to have two indexes with the same name in a table.
ALTER TABLE '
Cannot connect to the MySQL service on the host (named localhost) ", localhostmysqlCannot connect to the MySQL service on the host (named localhost"
-If the service is not started. Right-click 'computer '----> Management ---> services and
Mysql index typeIn MySQL, there are four types of indexes: B-Tree index, Hash index, fulltext indexes and RTree indexes 1. B-Tree indexes are the most frequently used index types in MySQL databases, all other storage engines except the Archive
Mysql (1), mysql
1. Database Operations
1. Create a database
Create database dbname;
2. view the databases in the system
Show databases;
3. Select the data to use
Use daname
4. view the data tables in a database
Use dbname
Show tables;
5. delete a
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