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 <[EMAIL PROTECTED]> Furry Peace! - http://wwww.fur.com/peace/ _______________________________________________ email@example.com mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"