List:General Discussion« Previous MessageNext Message »
From:Gregory Newby Date:January 19 2004 9:58pm
Subject:Re: 100,000,000 row limit?
View as plain text  
There is an issue in ISAM/MyISAM tables of needing to have correctly
sized row pointers.  I submitted this as a bug report (it's really a
documentation bug), but don't know if it will be fixed.  I was happy
to get an answer, though, so will share it with you :-) 

If you get an error like this:
"ERROR 1030: Got error 136 from table handler."

Try:
ALTER TABLE tablename MAX_ROWS=[very large value];

INNODB tables do not have the same limitation.  I do not
know about BDB tables.

My large table:
mysql> select count(*) from inv0web02;
+-----------+
| count(*)  |
+-----------+
| 498093481 |
+-----------+

  -- Greg

On Mon, Jan 19, 2004 at 11:24:19AM -0800, Daevid Vincent wrote:
>  mysql> select count(*) from atoms_in_universe; 
>  +-------------------------+
>  | count(*)                |
>  +-------------------------+
>  | 30204541410292874012341 |
>  +-------------------------+
>  1 row in set (0.07 sec)
> 
> Daevid Vincent
> http://daevid.com
>   
> 
> > -----Original Message-----
> > From: Will Lowe [mailto:harpo@stripped] 
> > Sent: Tuesday, December 23, 2003 8:38 PM
> > To: Andrew Braithwaite
> > Cc: 'Paul DuBois'; 'Andres Montiel'; 'mysql@stripped'
> > Subject: Re: 100,000,000 row limit?
> > 
> > > I don't believe this.  I'm going to write a script to 
> > disprove this theory
> > > right now..
> > 
> > We have a lot more than 100,000,000 more than that in a single MyISAM
> > table at work:
> > 
> > mysql> select count(*) from probe_result; 
> > +-----------+
> > | count(*)  |
> > +-----------+
> > | 302045414 |
> > +-----------+
> > 1 row in set (0.00 sec)
> > 
> > -- 
> > 					thanks,
> > 		
> > 					Will

Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center
University of Alaska Fairbanks.  PO Box 756020, Fairbanks, AK 99775
e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby
Thread
100,000,000 row limit?Andres Montiel23 Dec
  • RE: 100,000,000 row limit?Chris23 Dec
  • Re: 100,000,000 row limit?Jeremy Zawodny23 Dec
Re: 100,000,000 row limit?Paul DuBois23 Dec
RE: 100,000,000 row limit?Andrew Braithwaite24 Dec
  • Re: 100,000,000 row limit?Will Lowe24 Dec
    • Re: 100,000,000 row limit?Andrey Kotrekhov24 Dec
    • RE: 100,000,000 row limit?Daevid Vincent19 Jan
      • Re: 100,000,000 row limit?Gregory Newby19 Jan
  • Re: 100,000,000 row limit?Terence24 Dec