PHP

This article describes how to install and configure MySQL5.7.3.0 in windows. For more information, see the MySQL official website at http://dev.mysql.com/downloads/download the mysqlserver installation package. Mysql-installer-community-5.7.3.0-m13.

This article describes the use of pt-kill in percona-toolkit and some important parameters, for more information, see pt-kill. it is a simple tool to kill mysql threads and query. It is mainly used to prevent long queries from occupying system

With outstanding performance, low cost, and rich resources, MySQL has become the first choice of relational databases for most Internet companies. This article introduces the index optimization of the mysql database. if you are interested, let's

How can I output the content of MySQLhelpcontents in a hierarchical manner? The following small series will provide you with a hierarchical output method recommendation of MySQLhelpcontents content. I think it is quite good. now I will share it with

This article mainly introduces MYSQL import and export. SQL file related information, including MYSQL command line mode settings, command line entry into MYSQL methods, database export database files, import data from external files to the database,

This article mainly introduces MySQL database-error 1166 Incorrectcolumnname. if you need a friend, refer to the MySQL database-error 1166 Incorrect column name field name, which contains spaces in the field, you only need to use alert or phpmyadmin

This article mainly introduces mysqlEventScheduler: Failedtoopentablemysql. event. if you need a friend, you can refer to this error, which literally means you cannot open the mysql. event table, which is caused by permission issues. Mysql cannot

This article mainly introduces the usage of MySQL subquery, and compares and analyzes the setting skills of MySQL subquery based on the instance form. if you need it, you can refer to the following example to describe the usage of MySQL subquery. We

This article mainly introduces the impact of string indexes on update in MySQL, and analyzes the impact of the index addition operation on the performance of update statements based on examples, for more information, see this article. We will share

This article describes how to view and modify the encoding of the current database in MySQL. For more information, see In MySQL, database encoding is a very important issue. sometimes we need to check the encoding of the current database, or even

This article describes how to implement MySQL batch compression for MYISAM tables. The example shows how MySQL uses shell commands to batch compress MYISAM tables, for more information about MySQL batch compression, see the following example. We

This article describes how to delete a field in a table based on the field name in the MySQL database. For more information about how to delete a field, see the following table structure: mysql> select * from test;+------+--------+----------------

MySQL is an open-source relational database management system (RDBMS ). Next, I will introduce to you through this article the data retrieval section in Chapter 4, which is required by MYSQL. if you are interested, join us in learning. MySQL is an

This article describes in detail how to install the MySQL database server on the RHEL6 platform. if you are interested, refer to the MySQL database, which is the most widely used database system in Linux, it can be easily integrated with other

This article is a daily collection and sorting of some notes required for mysql. The second chapter is very practical for you. The current MySQL version is version 5. The major changes to the latest version are listed below: 4. --------- InnoDB

MySQL provides a slow query log record function, which can write statements that query SQL statements for more than a few seconds into the slow query log, during routine maintenance, you can quickly and accurately identify the page where the problem

Backup is the last line of defense for data security. for any data loss scenario, although backup may not be able to restore of the data (depending on the backup cycle ), but at least the loss can be minimized. This article introduces the principle

This article mainly shares with you the graphic tutorial on mysql5.7.12winx64 installation and configuration methods. if you are interested, refer to the text that was not summarized during mysql installation. change your computer and add the

This article mainly introduces how to recover innodb data in case of no primary key for MySQL exception recovery, and analyzes the data recovery steps and related skills in case of no primary key for the innodb engine in the form of examples, for

This article mainly introduces how to locate MySQL performance bottlenecks, and analyzes the steps and related skills of MySQL performance bottleneck troubleshooting based on the instance form, for more information about how to troubleshoot MySQL