Max size and row numbers

[Olaf Stein <steino@xxxxxxxx>]

Hey everyone

I have more of a general question regarding your experience with large
tables.

I currently have a table (MyISAM, 6 columns, lots of reading access, some
writing) with about 70.000.000 records, using 2.5GB of diskspace. I am
running MySQL 5.0.* on a RedHat Enterprise AS 4 system (2 CPU, 8GB Ram).

I just read that the max size for a table is 256TB in a default
installation. I have basically no experience with tables that big and mine
is potentially growing to several hundred million records.

First of all, are there theoretical limitations (if the 256TB are correct I
would be fine with that I guess) in size and number of records?

More importantly, what are the practical limitations and/or pitfalls? Is
ext3 as filesystem a limiting factor?

If you have experience or know of good links regarding this topic, please
let me know

Thanks in advance

Olaf


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx