MySQL Single Table optimization

First, table field optimization

1. Integer type try to use TINYINT, SMALLINT, Medium_int instead of INT, and non-negative numbers to add unsigned

2.VARCHAR length allocation should be reasonable, not too big

3. The time field does not exceed 2037 years using timestamp instead of datetime

4. It is best not to exceed 20 in a single table field

5. Field set default value, do not have null field

6.IP value is best converted to integral type when stored

Second, table index optimization

1. Proper indexing, based on the possible columns of where and ORDER by

2.SQL statements try to avoid NULL in the WHERE clause (the index is discarded and the full table is scanned)

3.

MySQL Single Table optimization