MySQL Question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Base
Forum Newbie
Posts: 13
Joined: Thu May 27, 2004 6:12 am

MySQL Question

Post by Base »

How many rows can a MySQL table hold? Is their a limit?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

there is no limit, as far as I know. If there is a limit, it's extremely large.
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

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.

:wink:
Base
Forum Newbie
Posts: 13
Joined: Thu May 27, 2004 6:12 am

Post by Base »

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. :)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I know for a fact, it can store more that 150 million rows in any given table.. so it's substantial.. :)
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

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 »

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