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

2004-08-03 Thread Warren Young
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 cer

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

2004-08-03 Thread David Brodbeck
> -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.

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

2004-08-02 Thread Eric Gunnett
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."

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

2004-08-02 Thread Shannon R.
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