From: Daevid Vincent
Date: January 19 2004 7:24pm
Subject: RE: 100,000,000 row limit?
List-Archive: http://lists.mysql.com/mysql/157914
Message-Id: <200401191924.i0JJOhgI010510@daevid>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

 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
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=daevid@stripped
>