Shulou(Shulou.com)06/01 Report--

This article will explain in detail what the methods of mysql performance optimization are, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (relational database management system) application software.

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

In fact, in web development programs, mysql still has a lot of room for optimization.

Here are the methods to optimize the performance of mysql.

One: choose the appropriate storage engine: InnoDB

Second: make sure to read data from memory. The data is saved in memory.

It is recommended that you save the data completely in innodb_buffer_pool_size, that is, plan the capacity of innodb_buffer_pool_size by storage. This way you can read the data completely from memory. Minimize disk operations.

Third, optimize and rebuild the database regularly.

Mysqlcheck-o-all-databases will make ibdata1 grow. The only real optimization is to rebuild the structure of the data table.

Four: reduce disk write operations

Fifth, improve the speed of reading and writing to disk

Six: make full use of the index

Seven: analyze query log and slow query log

Eight: radical methods. Use memory disk

Nine: use MYSQL in a NOSQL way

Ten: other

a. Add LIMIT 1 at the end of a single query to stop the full table scan.

b. The separation of non-"index" data, such as separating and storing large articles, does not affect other active queries.

c. Do not use the built-in functions of MYSQL. Because the built-in function does not establish a query cache.

The connection speed of d.PHP is very fast, and all of them do not need connection pooling. Otherwise, the number of connections may be exceeded. Of course, without connection pooling, the PHP program may also set the

e. @ ignore_user_abort (TRUE) is used for the example of full number of connections.

f. Use IP instead of the domain name as the database path. Avoid DNS parsing problems

On the mysql performance optimization methods are shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.