From owner-freebsd-questions Thu May 30 12:45: 0 2002 Delivered-To: freebsd-questions@freebsd.org Received: from infinity.aesredfish.net (ns1.aesredfish.net [65.168.0.12]) by hub.freebsd.org (Postfix) with ESMTP id 52F0337B400 for ; Thu, 30 May 2002 12:44:55 -0700 (PDT) Received: from potentialtech.com (mhope-dhcp-65-168-1-181.dashfast.com [65.168.1.181]) by infinity.aesredfish.net (8.11.6/8.11.0) with ESMTP id g4UJiUU27178; Thu, 30 May 2002 15:44:31 -0400 Message-ID: <3CF68278.10409@potentialtech.com> Date: Thu, 30 May 2002 15:50:16 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0rc1) Gecko/20020502 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jan Grant Cc: "Lance M.Westerhoff" , freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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 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. 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? -- Bill Moran Potential Technology http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message