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?


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,
Technical Administrator
CyberLeo.Net Webhosting

Furry Peace! - http://wwww.fur.com/peace/
freebsd-questions@freebsd.org mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to