Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Base
Forum Newbie
Posts: 13 Joined: Thu May 27, 2004 6:12 am
Post
by Base » Wed Jun 09, 2004 4:01 pm
How many rows can a MySQL table hold? Is their a limit?
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Jun 09, 2004 4:09 pm
there is no limit, as far as I know. If there is a limit, it's extremely large.
tim
DevNet Resident
Posts: 1165 Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio
Post
by tim » Wed Jun 09, 2004 4:13 pm
look at the number of people registered for this forum
thats a large number, n i'm sure (not seeing the code for phpbb) each one is a row in a SQL table.
Base
Forum Newbie
Posts: 13 Joined: Thu May 27, 2004 6:12 am
Post
by Base » Wed Jun 09, 2004 4:14 pm
OK thanks, I use mysql to keep track of logs into my website and I'm already up to 1400. I don't want to lose any data.
Thanks Everyone.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Jun 09, 2004 4:16 pm
I know for a fact, it can store more that 150 million rows in any given table.. so it's substantial..
Joe
Forum Regular
Posts: 939 Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow
Post
by Joe » Wed Jun 09, 2004 4:40 pm
Yeah but remember how much storage capacity you have available on your site!
lostboy
Forum Contributor
Posts: 329 Joined: Mon Dec 30, 2002 8:12 pm
Location: toronto,canada
Post
by lostboy » Wed Jun 09, 2004 7:17 pm
Its more the storage that you have available on the filesystem...Some file systems limit your files to 2Gb..others no limit...there are also many options in adminning the DB as to where you place files etc