MySQL Table size in AIX

2002-08-27 Thread Scott Pippin
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? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL Table size in AIX

2002-08-27 Thread Iikka Meriläinen
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

Re: MySQL Table size in AIX

2002-08-27 Thread Lenz Grimmer
-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: