List:General Discussion« Previous MessageNext Message »
From:Terence Date:December 24 2003 7:02am
Subject:Re: 100,000,000 row limit?
View as plain text  
Just to help you along, why test 100m when you can test 1b

SELECT FORMAT(count(*),0) as one_billion_rows
FROM test2.test_size

>1,027,346,573

And so as we can see, mysql can handle pretty big tables.

Rgds

----- Original Message ----- 
From: "Andrew Braithwaite" <Andrew@stripped>
To: "'Paul DuBois'" <paul@stripped>; "'Andres Montiel'"
<linuxlists@stripped>; <mysql@stripped>
Sent: Wednesday, December 24, 2003 11:21 AM
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..

Cheers,

Andrew

-----Original Message-----
From: Paul DuBois [mailto:paul@stripped]
Sent: Tuesday 23 December 2003 20:08
To: Andres Montiel; mysql@stripped
Subject: Re: 100,000,000 row limit?


At 0:57 -0500 12/23/03, Andres Montiel wrote:
>I was informed that MySQL has a 100,000,000 row limit. Is this true? We
>were planning to use MySQL for an inventory system. However, our
>current data (rows) for 1 year for one area is already 8.8 million. We
>want to place data for 5 years for 7 areas. This would exceed
>100,000,000. Is there a possible work around for this?

Where did you hear this?

-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
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
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