List:General Discussion« Previous MessageNext Message »
From:Quentin Bennett Date:January 9 2002 7:19pm
Subject:RE: 2 GB limit reached
View as plain text  
Hi,

I had this too - in the documentation, although maybe not highlighted
enough, there are instructions for overcoming 4G - you have to set MAX_ROWS
for you table to a 'large' number to tell mysqld to use > 4 byte pointers
for the file.

Regards

Quentin

-----Original Message-----
From: Chris Wilson [mailto:chris@stripped]
Sent: Thursday, 10 January 2002 7:07 a.m.
To: Johnny Withers
Cc: mysql@stripped
Subject: Re: 2 GB limit reached



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


---------------------------------------------------------------------
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-thread95854@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-quentin.bennett=infinity.co.nz@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.
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