aithwaite
> > Cc: 'Paul DuBois'; 'Andres Montiel'; '[EMAIL PROTECTED]'
> > Subject: Re: 100,000,000 row limit?
> >
> > > I don't believe this. I'm going to write a script to
> > disprove this theory
> &
rom: Will Lowe [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 23, 2003 8:38 PM
> To: Andrew Braithwaite
> Cc: 'Paul DuBois'; 'Andres Montiel'; '[EMAIL PROTECTED]'
> Subject: Re: 100,000,000 row limit?
>
> > I don't believe this. I
SQL
:)
We have ~1 200 000 000 rows in one MyISAM table.
And it works :)
> > 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_r
TED]>
To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "'Andres Montiel'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, December 24, 2003 11:21 AM
Subject: RE: 100,000,000 row limit?
I don't believe this. I'm going to wri
> 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
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:[EMAIL PROTECTED]
Sent: Tuesday 23 December 2003 20:08
To: Andres Montiel; [EMAIL PROTECTED]
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. T
On Tue, Dec 23, 2003 at 12:57:23AM -0500, Andres Montiel wrote:
> I was informed that MySQL has a 100,000,000 row limit. Is this true?
No.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
--
MySQL General Mailing Lis
I'm fairly sure that the ONLY limitation is the size of the table files, adn
those depend on the OS.
http://www.mysql.com/doc/en/Table_size.html
Chris
-Original Message-
From: Andres Montiel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 9:57 PM
To: [EMAIL PROTECTED]
Subject: