Database optimization tutorial (13) Other MySQL database Optimization Methods

Database optimization tutorial (13) Other MySQL database Optimization Methods
Vi. Other MySQL database Optimization Methods

In the last chapter, we will talk about some optimization methods not mentioned above.

1. My. ini configuration file

Here we will only introduce two of the most important ones.

1) configure the maximum number of connections

The default value is 100. We recommend that you set it to 1000.

2) Configure Cache

Enable query cache on the [mysqld] node of my. ini. The configuration is as follows:

Query_cache_size = 268435456

Query_cache_type = 1

Query_cache_limit = 1048576

2. Use stored procedures

Compared with SQL statements, stored procedures have the following advantages: compilation is not required, and a process is a compiled object.

3. horizontal segmentation

When an index is getting bigger and bigger, even if it is still slow to add an index, we can use table shards.

 

4. Static Page

Save the static page generated at the end of each request to the server. If the same request exists in the future, the static page will be displayed directly.

The whole database tuning tutorial has come to an end, and I have written all the experience I have learned, if you think there is something you need to add or something is not well written, please contact us.