Handles large databases. We are using MySQL Server with some databases that contain 50 million records and we know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
Up to 32 indexes per table are allowed. Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 500 bytes (this may be changed when compiling MySQL Server). An index may use a prefix of a CHAR or VARCHAR field.
1.可存60000个表
2.每个表可有32个索引,每个索引可由16个字段组成
3.char类型可最多255个字符
4.最大的类型是LONGTEXT,可存4294967295 (2^32 - 1) 个字符
Up to 32 indexes per table are allowed. Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 500 bytes (this may be changed when compiling MySQL Server). An index may use a prefix of a CHAR or VARCHAR field.
1.可存60000个表
2.每个表可有32个索引,每个索引可由16个字段组成
3.char类型可最多255个字符
4.最大的类型是LONGTEXT,可存4294967295 (2^32 - 1) 个字符
1 DB = DIR
1 TABLE = 3 FILE
如果 OS 规定一个 DIR 最多 N 个 FILE:
MAXTABLES = N / 3 2、一个表可存多少个字段?普通的字段应该没有限制吧?只有 INDEX 字段才有限制3、一个字段char最大存贮容量是多少?MySQL: char(255)4、最大能存贮字符的字段是什么字段,最大容量是多少?LONGBLOB
LONGTEXT
最大 4G-1