Six, MySQL optimization--Little knowledge point

1, select the appropriate field type, especially the primary key

The general principle of selecting a field is to keep it small, and the field that can occupy a small amount of bytes is not large. For example, the primary key, the proposed use of self-increment type, so space-saving, space is efficiency! Press 4 bytes and press 32 bytes to locate a record, who is fast who is slow too obvious. When it comes to several tables doing joins, the effect is more pronounced.

It is recommended to use ID keys that do not contain business logic, such as student data tables

Student table

ID Stuno stuname Adress

1 es1234 Teckwah Hong Kong

2, for files and pictures, the database only stores paths, pictures and files placed in the file system, or even placed on a single server (picture bed).

Six, MySQL optimization--Little knowledge point