Shulou(Shulou.com)05/31 Report--

This article will explain in detail how the basic design specification of MySQL database is. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

All tables must use the Innodb storage engine

Default engine after MySQL5.6

Support for transactions, row-level locks, better resilience, and better performance under high concurrency

All tables and fields should have remarks and use the UTF8 character set

Use comment to add comments for tables and columns

Benefits: it is convenient to maintain and organize data dictionaries from the very beginning

The size of the single table should be controlled as much as possible, and the hot and cold data should be separated.

Try to control the amount of data in a single table. It is recommended that the data be controlled within 5 million rows.

5 million is not the limit of MySQL database. How many thousands of data can MySQL store up to?

This limit depends on the storage settings and file system

The amount of data can be controlled by means of historical data archiving, sub-database and sub-table.

Prohibit the use of reserved fields and the storage of large binary data in tables

Prohibit storing binary data such as pictures, videos and files in the database

Store the picture or file in the corresponding file server, and only the address information of the picture or file is stored in the database

Usually the file is very large, query IO operation, time-consuming will affect the performance of the database

This is the end of this article on "what is the basic design specification of MySQL database?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.