MySQL

Close all connections:# #把全部的MySQL连接kill掉For I in $ (mysql-uroot-p123456-bse "Show processlist" | awk ' {print $} ');d o mysql-uroot-p123456-e "Kill $i";d on E# #把admin用户的连接kill掉For I in $ (mysql-uroot-p123456-se "Show processlist" | awk ' {if ($2==

Install MySQLSeveral common installation packages for MySQL: rpm, source code, binary-free compilationCd/usr/local/srcwget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gzTar zxvf

Usually in the MySQL database backup and recovery, most of the use of CMD in the implementation of the MySQL command to implement. For example:Mysqldump-h127.0.0.1-uroot-ppass Test > D:/test.sql ---Back up test database to D driveMysql-h127.0.0

What is a storage engineLibrary ===> folder created in MySQLTable ===> files created in the libraryIn real life, the files we use to store data should have different types: for example, TXT type for storing text, Excel for Save form, PNG for image,

This article mainly introduced the MySQL database lock generation reason and the solution, needs the friend can refer to the nextThe database, like the operating system, is a shared resource used by multiple users. When multiple users access data

Recently need to write documents, because development mode is first developed after writing documents (do not want to spit groove ...) ), the database table structure and so on, and then write the document need to paste table structure, what field,

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Parse an SQL statement first to see what

1.order by optimizationImplementation method:1. According to the index field sorting, the data extracted from the index is already well sequenced and returned directly to the client;2. The index is not used, and the fetched data is returned to the

The usage of isnull,ifnull,nullif in MySQL is as follows:Usage of IsNull (expr):If expr is null, then the return value of IsNull () is 1, otherwise the return value is 0.Mysql> Select IsNull (+);0Mysql> Select IsNull (1/0);1The comparison of NULL

mysql> Alter table History_text Drop primary key, add index (ID), DROP index history_text_2, add index history_text_2 ( Itemid, id);mysql> Alter table History_log Drop primary key, add index (ID), DROP index history_log_2, add index history_log_2

Naming rules: Table name _ Field name1. Fields that need to be indexed, in the Where condition2. Fields with low data need not be indexed3, if the Where condition is an OR relationship, index does not work4, accord with the left

In our actual infiltration, obviously found an injection point, this thought was lost to Sqlmap can be, the results Sqlmap only show is really injection point, but the database is not get, 1, then we can use manual injection, to determine the filter

Three ways to change the root passwordMethod 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 ')

One: Install MySQL online1, first detect, MySQL has not been installed beforeCommand: RPM-QA | grep MySQL2. Delete mysql command: rpm-e--nodeps ' Rpm-qa | grep MySQL '3. Install MySQL command online: yum-y install Mysql-server4. Turn on the MySQL

Query performance optimizationWhy is the query slower? The life cycle of a query can be roughly in order: from the client to the server, then parse on the server, generate execution plans, execute, and return results to the client. In the execution

The MySQL storage process is a set of SQL statements to accomplish a particular function, compiled and stored in a database, and when the user needs to use that group of SQL statements, it can be called by specifying the name of the stored procedure

I installed on the CentOS6.4 after the MySQL, unable to enter through the root, because the installation, and did not set the root password, seems to have an initial random password, but do not remember, too troublesome, directly reset the root

(1) Problem situationwhen you delete a row of a data table on master, and the row does not exist on the slave, the copy process on the slave error. the following error message was found in the MySQL log file:2017-08-15t04:52:19.529509z [ERROR]

Recently in a search engine, mainly on the book of object-level search, first to understand the next Sphinx bar.It can improve the speed of your queries, this is not general fast.Sphinx is an SQL-based full-text search engine that can be combined

New Features of MySQL 8.0.2 replication (translation), mysql8.0.2 Translator: zhishutang xingyao teamNew Features of MySQL 8.0.2 Replication MySQL 8 is becoming better and better, and this has caused a boom in our MySQL replication R & D team. We