Analysis of basic specifications used by mysql

1. InoDB must be used as table storage engine.

2. The table character set uses utf8 by default, and utf8mb4 when necessary.

3. It is forbidden to use stored procedures, views, triggers and events.

4. It is forbidden to store large files in the database.

Large files such as photos can be stored in object storage systems and databases.

Prohibit database stress testing in online environments.

Testing, development, and online database environments must be isolated.

Example

说明：
1）通用，无乱码风险，汉字3字节，英文1字节
2）`utf8mb4` 是 `utf8` 的超集，有存储 4 字节例如表情符号时，使用它

The above is the detailed content of Analysis of basic specifications used by mysql. For more information, please follow other related articles on the PHP Chinese website!