RE: on big mysql .MYD files and linux's 2GB file size limit

-Original Message- From: Eric Gunnett [mailto:[EMAIL PROTECTED] Depends on what file system you are running that is a ext2 limit if you move to ext3 or reiser you should be fine. But then a default config on MySQL will run into a 4.29 Gig limit, which you can change. Ext2

Re: on big mysql .MYD files and linux's 2GB file size limit

David Brodbeck wrote: Ext2 has not had a 2 gig filesize limit for a long time. 32-bit file offsets are still the default in Linux on 32-bit systems, so these systems will still have the 2GB limit by default. You have to compile your programs with special options to get 64-bit offsets. I'm

on big mysql .MYD files and linux's 2GB file size limit

Is the 2GB filesize limit in linux still there? Specially in Gentoo and Debian linux? If so, how can this be addressed when your mysql's .MYD files reach 2GB? Is there any way MySQL can split really big .MYD files? Regards, Shannon __ Do you

Re: on big mysql .MYD files and linux's 2GB file size limit

Depends on what file system you are running that is a ext2 limit if you move to ext3 or reiser you should be fine. But then a default config on MySQL will run into a 4.29 Gig limit, which you can change. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Shannon R.