Help: 有关 MySQL 和 Oracle 的问题!
MySQL 是否可以用来作为大型数据库网站的数据库?它每个数据库的最大容量是多少?
如果 MySQL 不可以作为制作,用 Oracle 数据库使用什么样的编程语言、Web服务器软件在 Linux/UNIX 下可以达到象 Linux + Apache + PHP + MySQL 这样的完美组合?
是否有网站这么做过? 直接把MySQL换成Oracle不久可以了!
看清楚了:
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.
MySQL Version 3.22 has a 4G limit on table size. With the new MyISAM table type in MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes).
Note, however, that operating systems have their own file-size limits. Here are some examples:
Operating System File-Size Limit
Linux-Intel 32 bit 2G, 4G or more, depends on Linux version
Linux-Alpha 8T (?)
Solaris 2.5.1 2G (possible 4G with patch)
Solaris 2.6 4G (can be changed with flag)
Solaris 2.7 Intel 4G
Solaris 2.7 UltraSPARC 512G
但 PHP 对 Oracle 并没有对 MySQL 支持的好呀!
页:
[1]