Some understanding and suggestions on MySQL performance optimization

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.

2. When doing statistical functions, try to avoid querying database tables in real time, either by caching or by summarizing the data into a summary table or a cache table.

3. You can check the log to see the current time-consuming query or update, to identify problems, relative optimization.

4. When designing the table, try not to allow null for a field so that there is no way to index the field.

Some understanding and suggestions on MySQL performance optimization