if your table is indexed, i think it can theoretically hold 4.294.967.295 rows, because that's the maximum for an unsigned integer value in mysql and indexing doesn't work with bigint types as far as i know. but, i'm not really sure about that.
Am 09.04.2005 um 11:42 schrieb Daniel Kiss:
Hi All,
I would like to know how big is the biggest database that can be handled effectively by MySQL/InnoDB.
Like physical size, number of tables, number of rows per table, average row lenght, number of indexes per table, etc.
Practically, what if I have a master/detail table-pair, where the master contains about 30 million rows, the detail in average contains 50 row for each master row, so about 1.5 billion rows in total?
I know that the performace heavily relies on the hardware, but let's assume that the MySQL server runs on a high-end machine with about 2GB or RAM.
Does anyone have experience with extremely large databases?
Thank you, Daniel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
