List:General Discussion« Previous MessageNext Message »
From:DChristensen Date:April 6 2004 10:13pm
Subject:RE: MySQL on Linux
View as plain text  
What we've done on Red Hat 7.3, 8.0 and 9.0 boxes, then on a SuSE 9.0 box is
to set up InnoDB and have multiple files defined at 2GB.  We just keep
adding additional files as we need them and performance seems to be holding
okay.

-----Original Message-----
From: Eric Gunnett [mailto:eric@stripped] 
Sent: Tuesday, April 06, 2004 4:54 PM
To: alan@stripped; mysql@stripped
Subject: Re: MySQL on Linux


  I have had this happen on 2 boxes one running Redhat 7.2 and the other
running Redhat 8. I can tell MySQL does not like not being able to write to
the file anymore. We were using MySQL 3.23 on one box and 4 on the other
box. The table crashed. Causing a lot of corruption. In one instance it
actually took the table and zeroed it out leaving me with no data, and
having to recover the 2 gig table, then watching it happen again.



Eric Gunnett
System Administrator
Zoovy, Inc.
eric@stripped


>>> Alan Williamson <alan@stripped> 04/06/04 02:47PM >>>


dan wrote:

> the most popular would have been Red Hat, which doesn't have this 
> limit you speak of, even plain vanilla install (no twiddling needed).

Not to spoil a perfectly good pontification ... but i have to say that 
we have a Redhat8 distribution running on a Dell PowerEdge Server and 
when Apache gets to the 2GB size on its access file, it does indeed 
stop.  This is not old hardware (12months old).

So don't be spouting any sweeping statements.  If your distribution 
doesn't have that limitation, then fantastic, good for you.  But for 
others it is indeed a real limitation.

The original question was indeed a geniue one, and while the poster 
accidently typed in the wrong size, i wouldn't be so quick to jump all 
over him.

So the question still remains.  What would happen in MySQL when that 
file isn't allowed to grow any further?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

Thread
MySQL on LinuxRonan Lucio6 Apr
  • Re: MySQL on Linuxdan6 Apr
    • Re: MySQL on LinuxRonan Lucio6 Apr
      • Re: MySQL on LinuxBenjamin Arai8 Apr
    • Re: MySQL on LinuxBrad Tilley6 Apr
      • Re: MySQL on Linuxdan6 Apr
        • Re: MySQL on LinuxBrad Tilley6 Apr
          • Re: MySQL on LinuxChris W6 Apr
        • Re: MySQL on LinuxAlan Williamson6 Apr
          • Re: MySQL on LinuxDan Nelson6 Apr
            • Re: MySQL on LinuxAlan Williamson6 Apr
              • Re: MySQL on LinuxPeter J Milanese7 Apr
                • Re: MySQL on Linuxdan7 Apr
            • Re: MySQL on LinuxPaul Smith9 Apr
              • Re: MySQL on LinuxDan9 Apr
  • Re: MySQL on Linux(Pete Harlan)6 Apr
Re: MySQL on LinuxEric Gunnett6 Apr
RE: MySQL on LinuxDChristensen6 Apr