From owner-freebsd-questions Thu May 30 19:59:10 2002 Delivered-To: freebsd-questions@freebsd.org Received: from babylon.chem.psu.edu (babylon.chem.psu.edu [146.186.189.194]) by hub.freebsd.org (Postfix) with ESMTP id 208E037B400 for ; Thu, 30 May 2002 19:59:04 -0700 (PDT) Received: from mentat.chem.psu.edu [216.169.171.140] by babylon.chem.psu.edu with ESMTP (SMTPD32-7.06) id A6ED1FFE013C; Thu, 30 May 2002 22:58:53 -0400 Date: Thu, 30 May 2002 22:59:23 -0400 Subject: Re: DB2 on FreeBSD?? Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v481) Cc: freebsd-questions@FreeBSD.ORG To: Bill Moran From: Lance M.Westerhoff In-Reply-To: <3CF68278.10409@potentialtech.com> Message-Id: <692A9F50-7442-11D6-B5D1-00039357F10C@psu.edu> Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.481) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Thursday, May 30, 2002, at 03:50 PM, Bill Moran wrote: > Jan Grant wrote: >>> What about database >>> software? As the databases grow, I expect each of them to encompass >>> several TB, so I don't think MySQL will work in the long run (though I >>> could be wrong). >> You may well be. MySQL uses single files per table, so you'll have a >> practical limit of 1TB per table inherited from the filesystem unless >> you look at UFS2. > > Not true. > MySQL has a RAID option that will cause a table to use several files, > and can get around the 1T limit. That might be some good reading anyway. I don't plan to store these databases on one partition as that sounds like a dangerous way to go, but my hope would be that whatever DBMS we choose would be able to stripe or spread the data between several partitions. Hopefully MySQL would have that capability. > However, I'm not aware of any 1T limit on FreeBSD filesystems. Here's > the authoritative answer: > http://www.freebsd.org/FAQ/install.html#AEN936 > If these number aren't reliable, someone who knows what the numbers > really are should take responsibility for updating the FAQ. They sure > look out of date, I wonder if 4.X has increased the sizes further? Agreed. There seems to be some question here. -Lance To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message