The size limitation is becauseof the operating system parameters. In
order to use tables larger then 3 GB, use either Redhat 7.2 or Solaris 8.
These operating systems allow file sizes greater then 2 GB. For the most
part I achievedtables sizes using these operating system of greater the 50
GB.
Benjamin Arai
benjamin@stripped
On Fri, 11 Jan 2002, Demirchyan Oganes-AOD098 wrote:
> Hello everyone,
>
> I guess I have the similar question, that has been brought up.
>
> I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data.
>
> Provided I have very big hard drive, how many partitions at 2GB each could I
> allocate? As many as my hard drive can handle?
>
> I also have questions with regards, to a table size. In my case it will be (4GB)/36
> bytes per table? Is it distributed uniformly, or some tables can grow bigger on the
> expense of the others (if some only have limited data, and others keep having new data
> inserted into them).
>
> Sincerely,
>
> Oganes Demirchyan
> Motorola Life Science
> 757 S.Raymond
> Pasadena, CA 91105
> Tel: 626-584-5900
> email: Oganes.Demirchyan@stripped
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread96115@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-benjamin=araisoft.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
