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

Re: File size limit exceeded, Linux/MySQl-4.0.20-i686-icc

2004-08-02 Thread Egor Egorov
Nathan Boeger <[EMAIL PROTECTED]> wrote: > Its accessed over the net by the web servers. I don't think we would > have file contentions. > > Actually, we just replaced the mysql binary with an older 4.0.16 version > that we compiled and used before we started to use the 4.0,20-i686-icc. > Now

Re: File size limit exceeded, Linux/MySQl-4.0.20-i686-icc

2004-07-30 Thread Nathan Boeger
er if others have had problems with this particular binary. -nb Victor Pendleton wrote: How is this table accessed and updated? Do you have file contention issues? Is the MySQL message 145? -Original Message- From: Nathan Boeger To: [EMAIL PROTECTED] Sent: 7/30/04 9:40 AM Subject: File size

RE: File size limit exceeded, Linux/MySQl-4.0.20-i686-icc

2004-07-30 Thread Victor Pendleton
How is this table accessed and updated? Do you have file contention issues? Is the MySQL message 145? -Original Message- From: Nathan Boeger To: [EMAIL PROTECTED] Sent: 7/30/04 9:40 AM Subject: File size limit exceeded, Linux/MySQl-4.0.20-i686-icc Hello everybody, We have a few Linux

File size limit exceeded, Linux/MySQl-4.0.20-i686-icc

2004-07-30 Thread Nathan Boeger
are hoping that someone could offer some ideas. What we are seeing is the database shuts down with the following error: "File size limit exceeded" and thats all we get. After we repair the db and bring it up a few minutes later MySQL shuts down, again, with that same error and all the web s

Re: file size limit

2002-08-31 Thread Paul DuBois
At 5:19 +0200 9/1/02, David Lloyd wrote: >Paul et al, > >> At 18:59 -0400 8/31/02, qlarry wrote: >> >here a file size limit in my sql >> >> What? > >I think that loosely should translate as "Where is a file size limit in >MySQL" which I wo

Re: file size limit

2002-08-31 Thread David Lloyd
Paul et al, > At 18:59 -0400 8/31/02, qlarry wrote: > >here a file size limit in my sql > > What? I think that loosely should translate as "Where is a file size limit in MySQL" which I would then interpret as "Is there a file size limit in MySQL". All My

Re: file size limit

2002-08-31 Thread Paul DuBois
At 18:59 -0400 8/31/02, qlarry wrote: >here a file size limit in my sql What? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

file size limit

2002-08-31 Thread qlarry
here a file size limit in my sql

Re: file size limit hitting when "LOAD DATA INFILE"

2002-06-24 Thread Bhavin Vyas
Yes, MERGE Tables is useful for getting around the file size limit problem. However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G but these can be altered using ALTER TABLE. You willl need to alter

file size limit hitting when "LOAD DATA INFILE"

2002-06-24 Thread Buding Chen
Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit th

file size limit hitting when "LOAD DATA INFILE"

2002-06-24 Thread Buding Chen
Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit th