Common methods of optimizing Database

This article mainly introduces the common methods of optimizing the database, the article is very detailed, has a certain reference value, interested friends must read it!

Tuning a database can usually be done in the following ways:

Select the most applicable field attribute, minimize the width of the defined field, and set the field to NOTNULL as much as possible. For example, "province" and "gender" are best suited to ENUM.

Use JOIN to replace subqueries

Use UNION instead of manually created temporary tables

Transaction processing

Lock tables, optimize transaction processing

Optimize the locking table by using foreign keys

Build an index

Optimize query statement

The above are all the common methods to optimize the database, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!