Re: filesystem types
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? UFS2 doesn't have 4GB limit and it's the default. i have 9GB file at present. it is mysql limit Where can I read about available filesystems on FreeBSD? Thanks. Jim 2nd post. I think I screwed up the first post. sorry for the bandwidth. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
filesystem types
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? Thanks. Jim 2nd post. I think I screwed up the first post. sorry for the bandwidth. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: filesystem types
On Sun, Aug 26, 2007 at 09:41:35AM -0700, 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? The default filesystem in FreeBSD does not have any 4GB limitation. If you have run into such a limit it is something else that is responsible for the limit - probably the application you are using. Where can I read about available filesystems on FreeBSD? Thanks. Jim -- Insert your favourite quote here. Erik Trulsson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: filesystem types
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://.fur.com/peace/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]