-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 20:05, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
You could either use MERGE tables:
http://www.mysql.com/doc/en/MERGE.h
On Tue, 27 Aug 2002, Scott Pippin wrote:
> I found out my AIX box's maximum file size is 2GB. What can I do if I
> will have MySQL tables that are possibly over 2GB?
Hello,
There are basically two things you should consider:
1) Switch to InnoDB tables and create several data files just under 2
Scott Pippin wrote:
> Which Operating Systems limit MySQL to a 2GB table size?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
wor
