Date: Thu, 30 May 2002 22:59:23 -0400 From: Lance M.Westerhoff <lmw188@psu.edu> To: Bill Moran <wmoran@potentialtech.com> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? Message-ID: <692A9F50-7442-11D6-B5D1-00039357F10C@psu.edu> In-Reply-To: <3CF68278.10409@potentialtech.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?692A9F50-7442-11D6-B5D1-00039357F10C>