MySQL Database Design notes and summaries (4) Maintenance optimization

"Maintenance and optimisation of the work"

① Maintaining data dictionaries

② Maintaining Indexes

③ Maintaining table structure

④ horizontal split or vertical splitting of a table at the appropriate time

"Maintain Data dictionary"

A data dictionary is maintained using third-party tools

b Use the Memo field of the database itself to maintain the data dictionary, for example MySQL:

C Export Data dictionary

"Maintain index"

How do I select the appropriate column to index?

"Considerations for maintaining Indexes"

"Maintain table Structure"

Precautions:

"Appropriate operations in the database"

1. Suitable for batch operation

2. Select * can cause I/O waste

3. Using a function, the index on the column will not work

4. It is best to use professional search engine instead of full-text index in database

"Vertical split of table" solves the width problem of the table

Horizontal split of table solves the problem of the amount of data in a single table

Primary KEY hashing: hashes a primary key value, such as a modulo value for a primary key.

MySQL Database Design notes and summaries (4) Maintenance optimization