List:General Discussion« Previous MessageNext Message »
From:Chris Wilson Date:January 9 2002 6:07pm
Subject:Re: 2 GB limit reached
View as plain text  
As I said in my message (although I've still not had time to look further
into this) this will not solve your problem completely. My 2.4.17 testbox
will happily create >4gig flies - but as soon as my mysql myisam table
reached 4gig I got a "Table full" error when trying to insert.

Going InnoDB is probably the best solution, from what I've seen
so far - will mysql switch to make that the default table type at some
point in the future?

> Enable large file support:
> 
> [root@xxx array0]# du -h bigfile
> 2.9G    bigfile
> [root@xxx array0]# ls -al bigfile
> -rw-rw-r--    1 root     root     3000000000 Jan  9 11:06 bigfile
> [root@xxx array0]# uname -a
> Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown
> 
> 
> ---------------------
> Johnny Withers
> johnny@stripped
> p. 601.853.0211
> c. 601.209.4985 
> 
> -----Original Message-----
> From: Dennis [mailto:dennis@stripped] 
> Sent: Wednesday, January 09, 2002 10:52 AM
> To: mysql@stripped
> Subject: Re: 2 GB limit reached
> 
> 
> At 11:26 PM 01/08/2002, you wrote:
> >On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
> > > At 07:07 PM 01/08/2002, you wrote:
> > > >Dennis,
> > > >
> > > >You may want to look into using InnoDB tables.  I believe InnoDB
> tables
> > > >are immune to the 2gb limit (which usually comes from the
> filesystem).
> > > >Also, InnoDB claims that the innodb tables are faster than MyISAM
> tables
> > > >in some cases.  See www.innodb.com or
> > > >http://www.mysql.com/doc/I/n/InnoDB_overview.html for further
> detail.
> > >
> > > thanks, but that doesnt tell me how to recover THIS file....the
> right
> > > answer is "use a different OS", but thats out of my control here.
> >
> >Can you at least mysqldump the data out to a file?
> 
> No, but that might be cumbersome with 4 million records. :-)
> 
> db
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread95833@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-johnny=mindbender.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread95841@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-chris=wapmx.com@stripped>> Trouble
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php> 
> 


-- 
Chris Wilson <chris@stripped>
http://www.wapmx.com

Thread
RE: 2 GB limit reachedDennis9 Jan
  • Re: 2 GB limit reachedRandy Katz9 Jan
  • Re: 2 GB limit reachedDan Nelson9 Jan
    • Re: 2 GB limit reachedDennis9 Jan
      • Re: 2 GB limit reachedJeremy Zawodny9 Jan
    • Suggestions - FullText ??Jon Shoberg10 Jan
      • Re: Suggestions - FullText ??Amir Aliabadi13 Jan
RE: 2 GB limit reachedEric Mayers9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedJeremy Zawodny9 Jan
      • Re: 2 GB limit reachedDennis9 Jan
        • RE: 2 GB limit reachedJohnny Withers9 Jan
          • Re: 2 GB limit reachedChris Wilson9 Jan
    • Re: 2 GB limit reachedChris Wilson9 Jan
      • Re: 2 GB limit reachedChris Cooper9 Jan
RE: 2 GB limit reachedQuentin Bennett9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedDan Nelson9 Jan