mysql使用规范（MySQL usage specification）.doc

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) temporary libraries, table names must be prefixed by TMP and dated by suffix. For example, tmp_test01 (6) backup libraries and tables must be prefixed by Bak and prefixed with dates. For example, bak_test01 2. basic specifications (1) using the INNODB storage engine. (2) table character sets are used using the UTF8MB4 character set. (3) all tables need to add annotations; additional fields other than primary keys need to be annotated. English punctuation is recommended to avoid garbled messages. (4) prohibit storing large data such as pictures and files in the database. (5) the data quantity of each table is suggested to be within 5000W. (6) forbid to do the database stress test on line. (7) prohibit direct connection to the database from the test and development environment. 3. library table design (1) zoning tables are forbidden. (2) split large fields, fields with low access frequency into separate tables to separate hot and cold data. (3) it is recommended to use HASH for hash tables, table names, suffixes, decimal numbers, and numbers must begin at 0. (4) according to the date, the time division table must conform to the YYYY[MM][DD][HH] format, for example 2013071601. The year must be represented by a 4 digit number. For example, the daily spread table userand the monthly spread table user_201102. (5) the right split table strategy. For example, thousands of libraries, ten tables, ten libraries, hundreds tables and so on. 4. f