文档介绍：mysql使用规范(MySQL usage specification)
1. naming conventions
(1) the library name, table name, field names must use lowercase letters, and the underline segmentation.
(2) the library name, table name and field name no more than 32 characters.
(3) the library name, table name, field names must see the name know. Naming is associated with business, product line, and so on.
(4) the library name, table name, field names to prohibit the use of MySQL reserved words. (list of reserved words, see official website)
(5) the temporary database, table name must be prefixed by TMP, and to date for the suffix. For example, tmp_test01_20130704.
(6) backup database, table must be prefixed by Bak, and to date for the suffix. For example, bak_test01_20130704.
2. basic norms
(1) using the INNODB storage engine.
Table (2) character set using the UTF8MB4 character set.
(3) all the tables are required to add notes in addition to other fields; but the key is required to add notes. mend the use
of English punctuation, avoid garbled.
(4) no pictures stored in the database, and other large data files.
(5) suggested that within 5000W of each data table.
(6) prohibit online database pressure test.
(7) banned from direct database testing, development environment.
3. library table design
(1) zoning table is prohibited.
(2) the field, access to low frequency field split storage separate table, separate hot and cold data.
(3) mended the use of HASH hash table name suffix, decimal number, number must be from the beginning of 0.
(4) according to the date and time table ply with the YYYY[MM][DD][HH] format, for example 2013071601. The year must be represented by 4 digits. For example, the monthly daily hash table user_201102 powder user_20110209.
(5) the right split table strategy. For example, thousands of libraries, ten tables, ten libraries, hundreds tables, etc..
4. field design
(1) it is mended to use UNSIGNED to store nonnegative values.
(2) INT UNSIGNED is mended to sto