How is mysql optimization done?

This article mainly shows you "how to do mysql optimization", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to do mysql optimization" this article.

How is mysql optimization done?

A: mysql optimization is mainly realized from the following aspects:

1) Design perspective: storage engine selection, field type selection, paradigm

2) functional perspective: you can take advantage of mysql's own features, such as indexing, query caching, defragmentation, partitioning, table partitioning, etc.

3) the optimization of sql statement: simplify the query statement as much as possible, query as few fields as possible, optimize paging statement, grouping statement and so on.

4) deploy the heavy load architecture: the database server comes out separately, and when the load is heavy, the master-slave replication and read-write separation mechanism can be used to design.

5) upgrade the database server from hardware.

The above is all the contents of the article "how to optimize mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!