Date: Sun, 26 Aug 2007 17:10:42 -0500 From: CyberLeo Kitsana <cyberleo@cyberleo.net> To: Jim Pazarena <fquest@ccstores.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: filesystem types Message-ID: <46D1FA62.3070405@cyberleo.net> In-Reply-To: <46D1AD3F.1020308@ccstores.com> References: <46D1AD3F.1020308@ccstores.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Jim Pazarena wrote: > I installed an amd 64 bit 6.2 freebsd with the default filesystem (on 3 > drives) > and my MySQL seems to have a 4Gb limit. Is there another filesystem I > can select > which bypasses this limit? > > Where can I read about available filesystems on FreeBSD? http://jeremy.zawodny.com/blog/archives/000796.html The above blog entry indicates that MyISAM tables on x86 platforms have a limit of 4GB or around 4.2 billion rows, depending on create options, due to a limitation in MyISAM's index algorithms. It does say that the limit is raised on 64-bit platforms, so are you sure you compiled MySQL for amd64? The InnoDB storage engine does not have this limitation. -- Fuzzy love, -CyberLeo Technical Administrator CyberLeo.Net Webhosting http://www.CyberLeo.Net <CyberLeo@CyberLeo.Net> Furry Peace! - http://wwww.fur.com/peace/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?46D1FA62.3070405>