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:linuxlists@stripped]
Sent: Monday, December 22, 2003 9:57 PM
To: mysql@stripped
Subject: 100,000,000 row limit?
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?
Thank you.
--
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 Montiel | 23 Dec |
| • RE: 100,000,000 row limit? | Chris | 23 Dec |
| • Re: 100,000,000 row limit? | Jeremy Zawodny | 23 Dec |
| • Re: 100,000,000 row limit? | Paul DuBois | 23 Dec |
| • RE: 100,000,000 row limit? | Andrew Braithwaite | 24 Dec |
| • Re: 100,000,000 row limit? | Will Lowe | 24 Dec |
| • Re: 100,000,000 row limit? | Andrey Kotrekhov | 24 Dec |
| • RE: 100,000,000 row limit? | Daevid Vincent | 19 Jan |
| • Re: 100,000,000 row limit? | Gregory Newby | 19 Jan |
| • Re: 100,000,000 row limit? | Terence | 24 Dec |